December 1, 2008 at 9:07 am
I have access to a remote database, and am setting up a smaller version (fewer tables and rows) of this as a local database on my computer.
However, the remote database is updated continually - and I would like to run updates once a day or so.
I have found that I can use the import/export wizard to get data from the remote database into the local one, but I am having to run this several times as I have multiple tables to update. (Which of course requires going through all the steps, entering source, destination, usernames, passwords, etc...)
Is there a modifiable script that is the equivalent of the import/export wizard? I am running the same thing each day, just changing the dates that are queried...
Any help you can give is greatly appreciated!
December 1, 2008 at 9:25 am
Next time you use the Wizard, when you get to the screen that has options to "execute immediately" and "save SSIS package", choose to save either in SQL Server or in the file system. You can then modify the package by opening it in Business Intelligence Development Studio and resaving it.
To run the package from SQL Server Management Studio, connect to Integration Services on the server, expand Stored Packages, right-click on the package and select "Run Package".
Greg
December 1, 2008 at 10:55 am
If I'm understanding what you suggest correctly, then I still need to repeat this process for each one of the tables I am updating, right?
Is there a way that I only need one file or query and I can just adjust the dates and click "Execute" each morning?
Thanks!
December 1, 2008 at 12:35 pm
You can import multiple tables in the Wizard if you choose "Copy data from one or more tables or views" rather than "Write a query to specify the data to transfer". If you want to use a query for each table, you'll have to create a package.
Greg
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply