April 6, 2006 at 2:26 pm
Hi all,
I'm going to be getting involved with the creation and reconfiguration of DTS jobs, however I've noticed that they'll require VB Script, which I'm not familiar with.
Without reading an 1000pp book on learning all uses of VB Script, are there any articles/resources that focus exclusively or distinctly on the most common uses of vb script in databasing?
Thanks,
JB
April 6, 2006 at 5:07 pm
You might scan the scripts on this site for some VB Script items. The ones I've most often used are the FileSystemObject and basic server connections (recordset, connection objects).
Here are a few articles:
http://www.sqlservercentral.com/columnists/hji/usingvbscripttoautomatetasks.asp
http://www.sqlservercentral.com/columnists/bszabo/dtsfilearrival.asp
http://www.sqlservercentral.com/columnists/sjones/pushftp.asp
April 6, 2006 at 6:59 pm
ALso, depends on what the script is for. I have scripts WCTP for paging, CDONT scripts, scripts to work with Excel objects, scripts that self reference the DTS packag for alter items, script for export a crystal reports report ouput to PDF. It just depends on what you need to accomplish. Ask questions as you need here and hopefully you will fin your answers.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply