dbTalk Databases Forums  

How to create DTS package through VBscript...

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss How to create DTS package through VBscript... in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
D.Zagi
 
Posts: n/a

Default How to create DTS package through VBscript... - 12-13-2005 , 09:28 AM






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..



Reply With Quote
  #2  
Old   
Darren Green
 
Posts: n/a

Default Re: How to create DTS package through VBscript... - 12-13-2005 , 11:07 AM






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

Quote:
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..





Reply With Quote
  #3  
Old   
D.Zagi
 
Posts: n/a

Default Re: How to create DTS package through VBscript... - 12-13-2005 , 12:42 PM



Thanks a big lot Darren , I also found your article about activating a
package from ASP, that is exactly what I am looking for, cause I need to or
actually my idea is to make an ASP application or better to say simple asp
website from which I could initialize DTS service to make a DTS package and
save it,then through FTP send it to other location...
That is a project for my major degree so nothing comercial in stake....
Thanks again...

"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote

Quote:
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..







Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.