Thanks Phil, I need to use a Script Component so please can you give any advice on my question as it is stated. I don't mind what type of...

CSV files are not tables. If you are importing from a CSV, you should not need to use a script component source. Instead, use a flat file source.

+1 for everything Steve wrote.

If it works, why change it? There need to be some serious benefits in order to justify this.

• This reply was modified 6 years, 10 months ago by Phil Parkin.

Where others use variations of "foobar" for things they can't think of a name for, I use variations of "noddy". You're not the...

You must work in Toyland.

Excel files are (compressed) XML files.

And the references to Excel.Sheet, ExcelWorkbook and the like are rather compelling. Are you certain about this?

If you are importing an Excel file, why not do it like this?

Your sample SQL assumes a maximum hourly rate of 10,000! Maybe I am in the...

Wow, you refused to format your code, even though I mentioned how to do it! For the benefit of others, here it is again.

USE TMWSUITE;
GO

/****** Object: ...

XML files come in different formats. Is your question about a particular format, or about how to use the XML source, or something else?

... so I can see it has...

Better still, just paste it into a post (using the Insert/edit code...

Valid points.

Not possible. You could try different things which wouldn't cost money such as download an evaluation version of 2016, restore the database there and then script everything out, bcp...

IIF() is 2012 onwards. What is the compatibility level of your database?

The code you posted has no syntax issues that I can see.

You should add in the table alias for InstructorInt, otherwise it looks fine.