Ok, so the question really boils down to big monolithic package or singles with a process over the top to call them?

I hate to do this, but, it depends, at...

Agreed.

CEWII

You are very welcome.

CEWII

For me, SQL-to-SQL connections are ALMOST NEVER by SQL authentication, I don't want to store login information if there is not a really good reason to.

For some things like DB2,...

My usual position is that Windows(trusted) authentication is the default expectation, I usually only allow other kinds if there is some REALLY valid reason for it to not work.. ...

Oops..

Fix this line:

+ CASE WHEN LEN( @EmlDom ) < 4 ...

My first guess is a 32/64-bit problem..

I'm guessing that the OS and SQL are 64-bit and the drivers either didn't say or are 32-bit. If so, you will not...

Far too many companies view people in much the same was as the furniture, you can be replaced on a whim.. Bye Bye... And I have seen this...

This error is often tied to a case where a process that is run as a local user on a workstation tries to connect to a SQL server that is...

Hm, had no problem myself.. Just take the .txt off the end and SSMS will see it..

CEWII

This was unclear so I want to explain some things.

The local login trying to run the query from the originating...

Do you have more than one place where the connection string is stored? Could that user have insufficient rights to master?

CEWII

Although more complex you could add script component that takes encrypted versions in the files and sets the connection string to their unencrypted counterparts.

CEWII

I'd probably add a data conversion component to the data-flow to get the types sorted out.

CEWII

Dude,

Everyone wants to make more money and getting a job in technology certainly can help. But to be blunt, near as I can see you aren't qualified, by...