locked
SSIS Issue RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    User-1688574779 posted

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

    Sunday, June 1, 2014 3:30 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    User1975998971 posted

    What is the issue?  Zipping a file is possible for SSIS mostly done by script task or executing a process task.

    Zipping a File

    The move task is done by a File System Task but other than that I am not sure what your question is.

    Monday, June 2, 2014 5:29 PM