SQL Server Performance

Source Location From a Table.

Discussion in 'SQL Server 2008 Integration Services' started by Arman, Jun 15, 2011.

  1. Arman New Member

    All, I need your help in creating one SSIS package. Below is the Detail :

    1. Copy the data from source to a destination table base of some condition (Straight Forward)
    2. Move the files from Source location to Target Location ( this is the tricky part)

    · The Source Path is in given in the Table.
    · Each file which needs to be move has a FILE_ID and one FILE_ID may have more than one file assosiated with it.
    · Create a new folder on the destination with the FILE_ID number and Date Time.
    · If one File_Id have more than one file, all the files should go the same folder.

    3. Update the destination table Stats Columns after moving the files..

    Please let me know that what is the best approch of doing this.

    Thanks in advance..Ar

Share This Page