Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: JonSchmidt
- Order by date
-
tricky data import. need strategy help.
Actually, I suppose I could import the data to my staging tables in DTS, then call my SP also from my DTS package. Would that be any more efficient than writing a complex ActiveX script?- JonSchmidt
- Post #4
- Forum: Microsoft SQL Server: Data Transformation Services
-
tricky data import. need strategy help.
I forgot to mention that I need to automate this so that it runs once a week. Thats why I was doing it in DTS. Still possible to do with your method? It seems like I can do some inserts using vbscript from my ActiveX script that would take care of it, though Im still not sure how efficient that...- JonSchmidt
- Post #3
- Forum: Microsoft SQL Server: Data Transformation Services
-
tricky data import. need strategy help.
I have to import data (on a weekly basis) from one DB to another. The databases are structered differently. There source DB has about 10 tables and the destination 4. The source DB is structured to be very static with tables and columns specific to certain fields, where as the the destination...- JonSchmidt
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Data Transformation Services
