sql server dts: Dynamic DTS from Access to Sql2000 and viceversa VB6 -- sql server dts

Dynamic DTS from Access to Sql2000 and viceversa VB6

Arejan
1/9/2007 1:55:30 PM

sql server dts: how to create a Dynamic DTS pack to export all tables of a SQL2k
database(including system dbs if required)
into .mdb file

when a new table is created an existing dts packeage will not export
the new table.
so LoadFromSQLServer can be used only if a previous package created
??

how to create a dts dynamically from vb6. and execute it

Re: Dynamic DTS from Access to Sql2000 and viceversa VB6

Allan Mitchell
1/9/2007 10:06:37 PM

This is no light undertaking. It is not possible without writing some
code either. Some of the things you could do are

Loop through the tables on the source
Compare to tables in Access
If table does not exist create it
If table does exist but different structure change it
You will now need to build the Data Pump task dynamically from scratch
for every table in the source.

Like I said this is not perhaps as easy as you may think

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.