Echoing Frederico's comment, you should not be installing SSDT on the server.

As you can see from this link, you'll need Enterprise or Standard Edition to run Integration Services. (Or...

And if it's not that, it will probably be a permissions issue. Does the SQL Agent user have the necessary access to the file system?

It ensures that the FK column in the child table matches...

That's not how SQL Server works. All the FK does is enforce data integrity. You can check for yourself by trying to insert a row in the child table which...

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.