SSIS Problem

[baddulas]

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...

 

[fredericofonseca]

search the net for examples - plenty around - I would advise you to use 7zip command line execute process to unzip - use of variables highly advisable.



Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886

 

[gk53]

where is your problem? Can you tell as on which topic you need help?

 

[jjefferson]

As suggested, use a program like 7zip for the compression. After the flat file is created, use an Execute Process Task to invoke the 7zip.exe program. Follow that with a File System Task to copy the zip file wherever you want.