Post reply

SSIS Package

  • December 31, 2008 at 7:06 am

    #195542

    i want to create SSIS package so that i can copy objects in a database from one server to another server on different machines. thanks in advance for your help.

    urgent response will highly be appreciated.

    best regards.

  • December 31, 2008 at 7:30 am

    #919639

    This is fairly straight foward in SSIS, you can even run the SSIS import-export wizard to get you started.

    Is there something in particular that you are struggling with?

    The best place to start is to run the wizard and then have a look at the package that is created and use this as a basis for your project.

  • January 6, 2009 at 1:10 am

    #921604

    Thanks. this is the case scenario:

    Two computers on the same network have the same database (sasDB) present on their respective SQL SERVER. But I want to copy just a single table from sasDB in ComputerA into sasDB in ComputerB. how possible is this?

    regards.

  • January 6, 2009 at 5:21 am

    #921677

    You can use the "Data Flow Task" in SSIS and in that flow you need to set the source & destination connections & the mappings between them.

    --Ramesh

  • January 6, 2009 at 9:15 am

    #921886

    ibnzakariyyahh,

    I think what respondents are telling you is that it's fairly easy to use SSIS to do what you want but it would be difficult to walk you through creating a package in this forum.

    Steveb gave you a good tip for getting started with the Import/Export wizard. Please give it a try and post back with any specific questions you may have.

    Greg

  • January 8, 2009 at 10:58 am

    #923563

    great thanks to u all for the wonderful contributions. i'd try out the ssis, particularly on charles post. and would get back to u guys if am successful or not.

    thanks. best regards

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

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