Check File exists and generate File

  • i need to create package,if file exists then copy the file to different location but with different name such as using today date.

    Shaun

  • Here is a good link with information on how to check if the file exists.

    http://www.bidn.com/blogs/DevinKnight/ssis/76/does-file-exist-check-in-ssis

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

  • Im still not getting how to do it..

    im lost when using import

    im using ssis 2008

  • Do you have a specific question or a part you are having trouble getting? There are a ton of articles on the web with this process described in detail.

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

  • Shaun2012 (9/18/2013)


    Im still not getting how to do it..

    im lost when using import

    im using ssis 2008

    You don't have to do an import if you're just copying a file. SSIS can copy files without importing the data.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • Hi Dan and Alvin,

    I want to copy ther files from a folder and delete the files after moving in it

    ex:

    Folder A: abc.txt

    Folder b:

    Now copy from from folder a to b with new name and then remove the files from a: as result be

    Folder A:

    Folder b: abc120130918.txt

    Thats how i want to do..

    Shaun..

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

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