I will add all links in this article, here we go..
SSIS Step by Step 001 - Load data from a flat file
SSIS Step by Step 002 - Output data to multiple flat files
SSIS Step by Step 003 - Load multiple flat files in a loop container
SSIS Step by Step 003 - Sync files in database
SSIS Step by Step 004 - Output XML Data from database
SSIS Step by Step 005 - Load data from XML file
SSIS Step by Step 006- Use XSLT to transform XML documents
SSIS Step by Step 001 - Load data from a flat file
SSIS Step by Step 002 - Output data to multiple flat files
SSIS Step by Step 003 - Load multiple flat files in a loop container
SSIS Step by Step 003 - Sync files in database
SSIS Step by Step 004 - Output XML Data from database
SSIS Step by Step 005 - Load data from XML file
SSIS Step by Step 006- Use XSLT to transform XML documents
Hi simon,
ReplyDeleteI have to show the current date and time in the Send email task subject line. Also the file names that are generated in its body. Can you help me out with it. I am a fresher with SSIS, dont have much knowledge on it and this is my first assignemnt. My package contains multiple tasks and at the end of the task i have to send email whteher it is a success or failure. If its a success have to mention the files name genreated. and show the date and time of the job in email. REqyest you to please help.
Hope m able to convey my problem to you.