Is there a static number of columns in the Excel spreadsheet or is this for dynamic transformations?

Your variable @intCompanyID is declared as INT - you can't mix this with VARCHAR when concatenating arguments.

Change WHERE intCompanyId = ' + @intCompanyID to

Just reading books... Maybe I should get out more!

I don't know TBH. As I said I've never used SAS just read a book or two .

I'll see if I can find out.

I think it's something like:

dimport  "filename.csv" targetDataset

As far as I am aware, the csv file needs to be tab delimited though.

Theres an article on creating a SAS program to read a csv file here:

http://www.ts.vcu.edu/faq/stats/sasexcel.html

Once set up you might be able to execute that using the SAS command line. If...

Jaybee,

I'm afraid you'll have to give us more information than that buddy. Is this a transformation task? From what to what? What does the lookup involve?

The more info you give,...

In the good old UK, it's knocking-off time. Hope this works for you.

You should be able to do this with a set based query rather than use any loop/cursor. Can you post the DDL of the table and some sample data?

Okay, still hovering somewhere around the original script.... This stored procedure takes a database name and output file name (for locating errors) and creates a scheduled Sql Server Agent Job. Each step...

"which removes the automation portion of it."

I'm missing something here... If the EXEC is moved in to the cursor, it will execute each...

"All is fair in love and war... "

Sadly this is neither; just, as mentioned, shameless.

You could move the EXEC in to the cursor and change the first line starting SET @sqlCommand = @sqlCommand + 'PRINT.... to SET @sqlCommand ='PRINT...

Would this not...

Do you have these scripts already saved as .sql or .whatever files in a directory?

* Added *

If you have, you could use the procedure below utilising a function that reads files. This...

A small change to the script will allow you to run each recompile separately. You can also check what's actually going to run with the PRINT command before using the...