Open expressions for Send Mail Task and set FileAttachments property like shown below.
Multiple files are separated by pipe(vertical bar) ( | )
Posts Tagged ‘SSIS send mail as attachment’
Top Posts
- SSIS: Dynamically Generate Excel Table/Sheet
- SSIS: Attach Multiple files in Send Mail task
- SQL Server: Create Table If Not Exists Else Truncate?
- Sybase - Drop a table if it already exists
- SSIS: CSV import, returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page
- SSIS:Set expressions of a variable,Rename in File System task
-
Recent Posts
- SQL Server : Search a table in entire database
- SQL Server : ALTER SCHEMA
- SQL Server – WITH ROLLUP
- Sybase – Drop a table if it already exists
- SQL Server – Size of all Tables
- SQL Server – Size of all Databases
- SQL Server- Database restores history
- SQL Server – Execution status of job
- SQL Server – Remove duplicates
- SQL Server – Dynamic PIVOT
- SSIS – Dynamic file connection
- Checkpoints in SSIS
- How to execute a job step without executing the entire job ?
- SQL Server: Find Column in entire Database
- SQL Server: Determine Table Size
- SSIS: Dynamically Generate Excel Table/Sheet
- SQL Server:Generate SELECT script for all tables in a database
- SSIS:Send Email from Event handler
- SSIS:Output table value as XML
- SSIS:Create a dynamic file using script task
- SQL Server:Get First Name , Get characters before space
- Import Data from Multiple Excel Files using SSIS
- SQL Server:Exclusive access could not be obtained because the database is in use,The tail of the log for the database has not been backed up
- SQL Server:Check for all running process and Kill ?
- SQL Server:Return table variable as output parameter from User defined function ?
- SQL Server:Drop existing Column/Add default value to existing Column/Add new column with default value
- SQL Server:Convert a SQL date/time to just date?
- SQL Server: Create Table If Not Exists Else Truncate?
- SQL Server: Check for blank/empty and null values in a column
- SQL Server: JOIN, What if joining columns contains NULL values/JOIN on column having NULL values
- SQL Server:Find table Differences
- SQL Server :Generate create scripts for Procedure,Views and Function
- Specifying multiple file types in SSIS Foreach loop
- SQL Server:Change Existing database to case sensitive
- SQL Server: Trigger Example
Archives
RSS
-
Join 32 other subscribers
Tag
ALTER DATABASE SET SINGLE_USER With Attach more than one file send mail task Attach multiple file send mail task SSIS BACKUP DATABASE charindex CHARINDEX REVERSE SQL SERVER check file exists using ssis Check for all running process check for file using ssis Convert a SQL datetime to just date Create a file Create a text file using script task is SSIS Create Table If Not Exists Else Truncate date time to date Deadlock Difference between Identity and Truncate dynamically load excel files in SSIS Dynamic Pivot SQL Server example of MySQL Transactions Exclusive access could not be obtained because the database is in use Export table as XML SQL Server export table output as CSV Export using SQLCMD Find primary key in oracle table for each loop For loop multiple excel files load SSIS generate select script for all tbales Get characters before space Get First Name import error csv inserted and deleted table Kill Prcoess Level 16 Line 1 Exclusive access could not be obtained because the database is in use. Msg 3013 Line 1 RESTORE DATABASE is terminating abnormally Line 1 RESTORE DATABASE is terminating abnormally. Line 1 The tail of the log for the database "Foodmart" has not been backed up. Use BACKUP LOG WITH NORECOVERY to backup the log if it contains work you do not want to lose. Use the WITH REPLACE or WIT Load multiple files in SSIS Msg 3101 Msg 3159 multiple files MySQL transactions oracle primary key Oracle view pass parameter from command line to SSIS pACKAGE RESTORE DATABASE Return table variable as output parameter from User defined function send mail dynamically SSIS Sequence Container SSIS Example SET MULTI_USER SQLCMD SQL Server SQL Server example Identity and Truncate SQL SERVER get charcters from end of string SQL Server get last name SQL Server Trigger Example SQL to find primary key in oracle ssis 7 zip SSIS CSV Import status 4 error ssis dynamic file name SSIS import XML SSIS import XML file in database. SSIS package with parameter command line SSIS send mail as attachment SSIS status 4 error SSIS status 4 or column is truncated error SSIS with parameter ssis zip State 1 TEXT using SQLCMD The tail of the log for the database has not been backed up Transactions in SSIS trigger example view in database zip 7 zip ssis zip using ssis
Data Warehousing 