![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
hey people, greetings to everyone.. I am new to SQL and I would like to know, is it possible, and if, how? to initialize DTS package with visual basic script? If you can help me with some information about that I would be very thankfull.. |
#3
| |||
| |||
|
|
You can load a package like this- Dim oPkg Set oPkg = CreateObject("DTS.Package") oPkg.loadFromSQLServer... Execute a package from a package (http://www.sqldts.com/default.aspx?215) To create a new package, start using the New methods on the various collections. Do a Save As VB to get some VB code, then convert it to VBS, should be faster than starting from scratch. -- Darren Green http://www.sqldts.com http://www.sqlis.com "D.Zagi" <dragutin.zagorec (AT) vz (DOT) htnet.hr> wrote in message news:eukDhn$$FHA.2812 (AT) TK2MSFTNGP09 (DOT) phx.gbl... hey people, greetings to everyone.. I am new to SQL and I would like to know, is it possible, and if, how? to initialize DTS package with visual basic script? If you can help me with some information about that I would be very thankfull.. |
![]() |
| Thread Tools | |
| Display Modes | |
| |