Post reply

Transfer SQL Server Objects

  • May 21, 2009 at 11:22 pm

    #137966

    We are using Transfer SQL Server Objects in SSIS Package for copying tables and data from one SQL server database to another database. We have 2 requirements:

    1. We need to copy only some tables not all

    2. Also for those tables we need to copy only some data depending on user input. for eg. if user selects A bank then we need to copy data only for that bank. Is this possible ? If yes how ? If no what is the other way of doing this ? Is this possible through SSIS ?

  • May 22, 2009 at 12:12 am

    #998688

    Anjali, if its only a one time requirement u can go with import and export wizard........

    Tanx 😀

  • May 22, 2009 at 12:25 am

    #998691

    As I mentioned in 2nd point, we need to cpoy selective data depending on user input. So its going to be dynamic at runtime. Its not a one time process.

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

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