April 3, 2006 at 3:50 pm
I need to export a whole legacy data base (text files) to SQL.
DTS wizard worked fine to discover the parameters we had to use to perform a proper exportation.
Now we have around 1000 files to export, all the same dialog.
How do we automate the process?
April 4, 2006 at 6:39 am
You can export your package as VB code. Perhaps you can then add a 'wrapper' function to that code to create all the packages needed, possibly working from a table of file names.
------------
Buy the ticket, take the ride. -- Hunter S. Thompson
April 4, 2006 at 8:50 am
Thank you for your help. But I am a newby. Can you give me more details of how to do that?
April 5, 2006 at 6:24 am
The VB code is rather involved so you'll want someone with some experience there to make the modifications. What the code actually does is use the DTS API to create the package programmatically. The GUI you are familiar with does the same thing, you just don't see it all.
You can create the VB code by doing a Save As with you package and choose Visual Basic File for the location.
------------
Buy the ticket, take the ride. -- Hunter S. Thompson
April 5, 2006 at 11:26 am
Many thanks. WIll do.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply