I'm working on a little VB(6) program that will accept a dbf/Access database of arbitrary structure, then use ADO to create an SQL table in an existing SQL database. I can use ADO to then send the data to the table, but I think using DTS would be faster.
I have explored the DTS code that gets auto-generated by a package, but it looks overly complicated. Is there some simple way to create a dynamically-generated DTS package programmatically? Will DTS give me a significant performance increase over ADO for tables with 500K - 2M rows?
If anyone has any code samples that would be most appreciated.
I have explored the DTS code that gets auto-generated by a package, but it looks overly complicated. Is there some simple way to create a dynamically-generated DTS package programmatically? Will DTS give me a significant performance increase over ADO for tables with 500K - 2M rows?
If anyone has any code samples that would be most appreciated.