Thank you both.  Creating and using the File System Object is something I am already familiar with.

What I am looking for is a way to execute SQL Code against the existing...

rmazzol,

Sorry, I got the ActiveX and ExecuteSQL syntaxes confused in my head.  Plus, I did misunderstand your problem.

1. Yes, you can have more than one "else if" clause in an "if" statement; but you can have only one "else" clause, and an "else if" clause cannot come...

In addition to "select distinct", put an index on the start_date column, if you don't already have one.  That might help it go a little faster.

rmazzol,

You can get the values out of the .ini file and into the global variables using the DTS Dynamic Properties task.

You then assign the global variables to the local VB Script...

This is not really related to your problem, but I have always wondered why, when using a cursor (ugh!), you would want to use two 'fetch' statements?  Why not set...

When you say the index produces rows, are you talking distinct values?

If so, then the index that produces less rows will take longer to find a distinct row, because it has...

That should work.  Just remember that it will change the value of @SecondaryKeyValue in the calling procedure.

smknox,

When you call a stored procedure with an output variable you need to assign the ouptput variable of the called stored procedure to something.

I'm a little confused in your example...

I'm not familiar with the nuts and bolts of how an update is actually accomplished by SQL Server, but you are trying to update a record which has not yet been fully inserted.  That...

 Select

  ja.Name,

  op1.PositionTitle As FirstChoice,

  op2.PositionTitle As SecondChoice

From JobApplicants As ja

Inner Join OpenPositions As op1

  On ( ja.fkFirstChoice = op1.pkPositionID )

Inner Join OpenPositions As op2

  On (...

If Exists()

   Update

Else

   Insert

eamonroche:

This is kind of a roundabout way to do it, but it worked for me.

First, declare a variable table with the columns from the main table that you want in your result...

Rajiv,

For my part, I have an FTP process set up with DTS.  I store values such as remote server name, user name, password, and file names in a SQL table. ...

Jim,

Are you, by chance, looking at your results in Query Analyzer?  And, returning at the results in text format, rather than grid format?

Query Analyzer will show you the column name...