May 27, 2009 at 2:51 pm
Why are you trying to make this dynamic? If you are extracting data from one system and loading it into another (ETL process), you really need to have a fixed set of columns and known data that you are extracting.
Any schema changes need to be accounted for in both systems and the process updated appropriately.
I would also recommend that you build an integration services package (SSIS). It will be much more effective.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 27, 2009 at 3:06 pm
Use the data import wizard to set up a basic package. From there, you can add to it.
there are lots of SSIS articles here on the site (http://www.sqlservercentral.com/Articles/SSIS) as well as sqlis.com
May 27, 2009 at 8:20 pm
I want to create a scheduled program which will run everyday at partocular time, hit some SOURCE database and store the data in DESTINATION database.
- Is it possible using SSIS?
- If yes, can anyone provide the link/documentation to do the same.
Thansk a lot.
- Prash..
May 27, 2009 at 8:25 pm
That is the whole purpose of SSIS - I would recommend using BOL and http://www.sqlis.com to get you started.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 27, 2009 at 9:33 pm
And using dynamic configurations, you can change servers and databases as easily as modifying a configuration file. A good book is from Wrox, Professional SQL Server 200r Integration Services, iirc.
I don't have it handy, but it is the book I first bought when I started working with SSIS.
Viewing 5 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply