It allows you to create more general purpose flexible SQL statement because the full text of the SQL statements may be unknown at compilation

Rather than 'compilation', I'd suggest...

Nice one! Thanks for posting back.

All the SET FMTONLY stuff is no longer required and can be removed.

Instead of

EXEC proc

Use

EXEC proc WITH RESULT SETS ((col1 datatype1, col2 datatype2, ...));

as the source for your data flow....

It allows you to create more general purpose flexible SQL statement because the full text of the SQL statements may be unknown at compilation

Rather than 'compilation', I'd suggest 'time of...

Your recent posts can be found here. Just clicking on your name takes you to the right place.

As far as I remember, there has never been an FAQ area...

Understood. There are a couple of things you can do to reassure yourself about that, should you decide to try:

1. Set the package protection level to DontSaveSensitive. This forces VS not...

Well done on getting round it.

If you have the time and inclination, feel free to post a package here which would allow me to recreate the issue in my own...

Have you tried using TRY_CAST? I think that was available in 2012 ...

When you say "I want only the first row from the left table," can you expand on exactly what you mean by that?

First of all, for SalesOrderId = 43670, all...

I cannot see the source data ...

I can't think of a way of applying this sort of encryption without changing the structure of the database.

Please tell me what is wrong with the information found by following the hyperlink I provided, and then we can help you further.

Thanks for your help.

I didn't know about the possibility of reading the project file in Notepad++ .  I've now checked it and I can't find gmlFileA in loopB.

I'll keep...

This took me 15 seconds to Google. Please don't post questions which are...

Once all of the projects and packages are set to Don't Save Sensitive and checked in (don't forget to check in the project file as well as the packages), I'd...