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

How would you configure bitbucket if 2 or more developers are working on the same SSIS project? My vision is for developers working on separate packages and then committing...

Yes I am, exactly right.

This is awful!

But it can be decomposed.

1. If ContractNumber is NULL, then PaidLossAmount
2. If PaidLossAmount and CaseReserveAmount are both NULL, then NULL
3. Otherwise (PaidLossAmount + CaseReserveAmount) (with NULLs in either...

So, speaking of formatting tools, I just got a complaint because I formatted the code from the stored procedure that I worked on and that generated too many differences...

You should be able to do it all in a single statement, and therefore won't need an explicit transaction. Something like this.

INSERT EtiquetasKLC.dbo.etiquetas
(
    nome_posto
...

Sounds like you should...

If you have a large volume of data to compare and your chosen solution is very slow, please post back.

The CallEnded time 12:14:30 appears in your desired output example, but does not appear in the source data. Why is that?