May 31, 2014 at 10:21 am
Hi All,
Please help on the SSIS issue.
i have a package.It contains Foreach loop container,Inside foreach loop container,I have one Dataflow task(Inside dataflow task,i am using Oledb source(table),I am populating
Data into Flat file)with flat file name YYYYMMDD_HH24MISS.txt. After i want to Zip that file with same file name.
YYYYMMDD_HH24MISS.txt.zip,After that i want copy that Zip file into another location.
Thanks in advance...
June 2, 2014 at 7:49 am
You can use an Execute Process task in your control flow to call a command line zip utility. I am assuming this is what you are having issues with since there is no "out of the box" zipper in SSIS.
Alternatively you could use the Zip task in SSIS extensions (http://ssisextensions.codeplex.com/)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply