-
Create a DTS from VB
I've posted this new thread to see if anyone knows how to dynamically create a SQL Server 7 DTS package using VB.
RSINGH has assisted me thus far, and I know how to execute a DTS from the VB, but now I want to create one as well.
I'm told it can be done using SQL DMO.
Anyone got any tips/ideas for doing this?
:cool:
-
I have another idea for you. In Enterprise manager you can save a DTS package as a visual basic file. If you do this, it will create a .bas file which will demonstrate the structure of how to create one yourself and provide you with a template which you can then modify to suit your own needs.
Now the only problem is that there is a lot of code! I did this for a basic file transfer and import package and it is huge.