Here are some common ones.  You can copy and paste this to the top of your active X script:

'---- DataTypeEnum Values ----

Const adBoolean = 11

Const adChar = 129

Const adCurrency =...

I don't think the mention of Notepad was "silly" at all.  It sounded to me as if Outlook was forbidden simply because it is a client application, but there are...

Here's a sample of how we do this:

 sFileName="FileName-" & Right("0" & DatePart("m", Date), 2) & _

  Right("0" & DatePart("d", Date), 2) & _

  Right(DatePart("yyyy",  Date), 2) & ".txt"

  DTSGlobalVariables("FileName").Value=sFileName

 DTSGlobalVariables("FilePathName").Value="<<FilePath>>" & sFileName

You can use...

Neither of the preceeding comments addresses the security issue.  I can see the point made by one of the comments that some kind of scaled down version be available, but...

This is a superb explanation of the subject.  I completely agree, and I like the logic used  that makes it more than just an opinion.  In the rarest of occassions,...

I don't know what version you're using, but the DTS package process in SQL2000 is far ahead of SQL7.  Global variables are fairly straightfoward, and we have transferred all of...

Did some reading over the weekend, and found a way you could do this.  I'm not sure exactly what way you're trying to get the output parameters, but if it's...

I found the same thing

You'll need to have the constants declared if you use the code as it appears.  Here are the ones that appear in the code:

'---- DataTypeEnum Values ----

Const adChar = 129

Const...

If there's a way to do it using the SQL Task, I can't figure it out this quickly.  I see the output parameters tab, but it doesn't seem to p/u...

sorry, but I should have also asked you what version of SQL Server you are using.

Are you doing this an an ActiveX Script or an SQL task?

You're welcome.

Are you running the package under a domain account?  If you are crossing server boundaries you can't run the package under the local admin account.

Properly cased and indented code is much easier to read.  Most of my colleagues would agree, as we had this discussion when one of the programmers used lower case.

Making code...