Can you provide sample DDL, INSERT scripts and desired results, please?

If this is a script component source, and you are reading from a file, then there is not yet any concept of tables.

All that you can do here is add...

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, 6 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...