October 18, 2013 at 3:58 am
Hi,
Here's the situation...
I have 3 queries that populate 3 tables taking from one server and putting information on another. I currently use the import wizard 3 times. The reason for doing it like this is because I cannot get a linked server due to IT restrictions at work. Is it possible to import multiple tables in one go? So I would combine all 3 queries to run one after the other to create 3 separte tables. I have read something about SSIS but again I do not have access to this.
Many thanks
October 18, 2013 at 4:45 am
You would do this with SSIS. Behind the scenes, the import wizard uses SSIS. In the last step you can choose to immediately run the package or to save it. If you could save and edit the packages, you could put all the logic in one package and schedule it with SQL Server Agent.
Try to gain access to SSIS.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 18, 2013 at 5:48 am
Hi,
Thanks for your reply. I thought this might be the only solution.
Cheers
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply