SQL Server Performance

SSIS issue

Discussion in 'SQL Server 2008 Integration Services' started by Baddulas, Jun 1, 2014.

  1. Baddulas New Member

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

Share This Page