Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 SSIS expression issue

Author  Topic 

baddulas
Starting Member

11 Posts

Posted - 2014-05-31 : 09:05:25
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...
   

- Advertisement -