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.

Not an IF/THEN, but an if and only if:

SELECT OriginalDatabaseId = iif(InstructorInt = -1,-1,p.PeopleId)

Note also that stateAbbrveation appears to have been abbreviated 🙂

People might be able to help, if you can ask the question properly & post DDL, INSERT statements and desired results. I have no idea what you are asking for...

Good to see.

But what about making a copy of an existing database in Dev, for...

If this is within a stored proc in the database, please consider removing the EtiquetasKLC. prefix from the table names. This is a bad practice, unless you are...

No offence, but this task would seem to be beyond your current level of SSIS capability. There is quite a gulf between what you know and what...