DTS Help please

[koukouroukou]

How can i transfer a Excel sheet to sql with DTS from Vb code and also create the nessesary table(if possible). Till now i use sqldmo to create the table but i was not able to create and execute the DTS.

 

[sunaj]

Hi,

I assume that you are using SQL server?
The fastest way to do it is to go into the enterprise manager, create the DTS using the visual tools there and then chose 'save as' from the package menu. Select 'visual basic file and the entreprise manager will create a .bas file that you can use in your vb project. It will also create teh necessary table.
Sunaj
'The gap between theory and practice is not as wide in theory as it is in practice'

 

[koukouroukou]

i want dynamicly to create the DTS if its possible cause the excel i use is allways different.So i want to get the general idea about DTS and vb

 

[sunaj]

And you will get that by studying the code that the enterprise manager creates for you. Start with an as simple example as possible. When you get the hange of it you can always modify/write new VB code to create your DTS. Sunaj
'The gap between theory and practice is not as wide in theory as it is in practice'

 

[koukouroukou]

I am using SQL 7 and it does not have this option

 

[Supercow]

It's been a while since I worked with SQL Server, but the option to create DTS is available since SQL Server 7.0.


Open the manager and select import/export wizard. You can select both source and target servers.

Follow the on screen instructions. It's quite simple.
Hope it helps

SC

 

[koukouroukou]

i know how to use the dts wizard. I want to dynamicly create the package from code . Any Ideas