Post reply

SSIS Extract and Load

  • January 31, 2013 at 12:40 pm

    #288575

    HI,

    I am trying to write a ssis package which moves clients file from certain directory to another.

    Source Path : D:\Temp\Source\Client A_CSV

    D:\Temp\Source\Client B_CSV etc

    Source Directory has many folders of clients like Client A_CSV etc.

    I want that when i move files to ARCHIVE directory,so that it rename the files with time stamp.

    So far, i have been able to move with file task, but it does not allow me to rename file as I retrieve

    FULLY QUALIFIED PATH as loop enumerates,

    So,,any idea ,, how i accomplish renaming with file system task or Script Task,

    Thanks

  • January 31, 2013 at 6:47 pm

    #1583246

    Go through the following articles. Let us know if this still doesn't solve your question.

    http://www.bidn.com/blogs/KeithHyer/bidn-blog/2465/copy-and-rename-a-file-in-ssis-using-the-file-system-task

    http://www.rafael-salas.com/2007/03/ssis-file-system-task-move-and-rename.html

    Sam Vanga
    http://SamuelVanga.com

  • February 1, 2013 at 3:51 am

    #1583348

    a bundle of Thanks

  • February 1, 2013 at 7:03 am

    #1583436

    It is a lot of work to do this in SSIS. Do you have to use SSIS? You could do this with a single line of PowerShell too.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • February 14, 2013 at 4:56 am

    #1587850

    i have a new problem .

    i am writing ssis package having For Each Loop Container Which iterates through DropBox Folder ..

    But when it iterates, it gives error : Desktop.ini File in DropBox is not Recognized.

    How do i ignore this .ini file while iterating through Dropbox ?

  • February 14, 2013 at 5:15 am

    #1587858

    iamsql1 (2/14/2013)

    i have a new problem .

    i am writing ssis package having For Each Loop Container Which iterates through DropBox Folder ..

    But when it iterates, it gives error : Desktop.ini File in DropBox is not Recognized.

    How do i ignore this .ini file while iterating through Dropbox ?

    Please do not cross-post. Answers here please.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply