SSIS

  • Dear All,

    I have a working COpy of a dtsx (SSIS package) which correctly FTPs data across.

    Now I hava a need for another dtsx package (similar to the one above) that will also FTPs data across to another FTP account (and of course using different sql script from the above).

    My question is CAN I JUST COPY THE DTSX AND NAME IT INTO A NEW NAME. Then, can I just change the corresponding sql script and the corresponding FTP account details. Will, by copying just the dtsx and do what I have stated work or should I also do something else. I AM RELATIVELY NEW TO SSIS SO I NEED ALL THE HELP IN THE WORLD.

    MANY THANKS.

    REGARDS,

    CARMEL

  • The easiest way to do copy an existing package is to open the project that contains the package, copy the current package (using CTRL + C), click on the "SSIS Packages" node and the paste the package (using CTRL + V).

    This will create a copy of the package with a name like "'package name' 1". You can then rename it to whatever you want and make your changes.

Viewing 2 posts - 1 through 2 (of 2 total)

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