Hello,

Im new to VBScript and need to learn how to use it in SQL DTS packages.

Any of you know of some good starting websites?

Thanks.

www.sqldts.com is a very good place to start. Asking on this NG is also
very good. What do you want to do with your VBScript?
I am presuming something with the DTS package.

Allan


"Fab" <fountainhead7 (AT) hotmail (DOT) com> wrote

Yes I want to use it in DTS. But not sure for what yet, as I know nothing
about VBScript and how to use it or what it can do for me.

My issue is that I have an ftp dump of a file that I need to import into
SQL. It waits to find a tigger file before it runs. Someone told me VBScript
is the way to go with this issue of mine. I also need to delete the trigger
file before I import.

I will check out the site!

Thx


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Ok So if you are waiting for a file before running the package then you can
check outside of DTS using VBScript and only fire the package if it is
available.

You can also check within DTS -

How can I check if a file exists?
(http://www.sqldts.com/default.aspx?211)



"Fab" <fountainhead7 (AT) hotmail (DOT) com> wrote