SQL Server Performance

Archiving CSV files into a folder with the System date in the folder name

Discussion in 'SQL Server 2005 Integration Services' started by GL193, Feb 27, 2008.

  1. GL193 New Member

    Hi,
    I'm currently creating an SSIS package to load CSV files into SQL on a weekly basis. Once the data flow has completed I need to archive these CSV files into a new folder each week with the system date to be included in the folder name. Any ideas how I can do this?
    Would it be best to create a Script Task or use a File System task? I'm a little lost any help would be great thanks!
    GL193, Feb 27, 2008
    #2

  2. dineshasanka Moderator

    You can use File System Task and select Move file as the operation
    dineshasanka, Feb 28, 2008
    #3

  3. satya Moderator

    ...and when you are scheduling this task ensure the SQLagent account has relevant permissions on specified directories.
    satya, Feb 28, 2008
    #4

Share This Page