Post reply

Import Data package - how to change connections?

  • June 7, 2006 at 8:50 am

    #68530

    I imported an access table a test database, and saved the job as a package. Now I would like to use that package to import into my production database which has a different name. Basically I need to change the database it imports into for MyDBTest to MyDBProd. Is there a way to do that? I see the connection in there, and I've changed which table it is pointing too, but all my Create Table tasks are still pointing to [MyDBTest].[dbo].[MyTable1]. Help.

  • June 8, 2006 at 7:05 am

    #642508

    You can chenge the Create Table tasks to pointing [YourDBProd].[dbo].[MyTable1], and in the Connection properties

    change the MyDBTest to MyDBProd

  • June 8, 2006 at 4:54 pm

    #642680

    Hi Sean,

     

    You can also use the 'Dynamic Properties' task to change data sources, initial catalogs, connection strings etc. This way, if the new database has the same structure, you will not need to change the other tasks at all.

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

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