As a guess, could it be permission related?  I am wondering if you are running it with a restricted account and you need a full sysadmin to see all of...

Something I'd like to add to what Jeff said - where do you want to handle this?  Should this be handled at the INSERT level or at the SELECT level?

Also,...

A quick google of this, it looks like CONTEXT_INFO is not a property that is available at connection time.  So you would need to SET that after connecting.  This could...

Glad I could help.  I am actually a bit surprised that SSL connections would be faster than non-SSL.  I am actually not sure why that would be as SSL adds...

Quick google of that error, it sounds like there is more to the error message.  Is the full error message:

Msg 8921, Level 16, State 1, Line 1 Check terminated. A...

I see a few optimizations that can probably take place.

First, that WHERE 1=1 isn't needed as it isn't doing anything.  Not sure it is a performance improvement by removing it,...

One way to do it that I think should work would be to do a self join.  So something like:

SELECT
[t1].[empID]
, [t1].[empl_rcd]
, [t1].[jobcode]   AS [jobcode1]
, [t1].[joblevel]...

For me, with my android device, I like that I can turn off targeted marketing.  I forget where the setting is, but google allows you to disable it.  Turning it...

I can think of only 1 case where a BEGIN doesn't have an END - BEGIN TRANSACTION.  That requires a COMMIT or a ROLLBACK.   Otherwise I agree with Jeff here...

Few things I would try, but the first would be to connect to the server using the FQDN rather than the friendly name.

I would also make sure your connection string...

If the password to the SSIS service account is known to you, I would log in as that account and do a test run of the powershell as the SSIS...

Do you have access to the folder where backups are happening on the live system?  If so, restore the live database onto your test box and run some tests that...

@loaderror - I don't think that you need to have the server name match the SQL instance name as then you wouldn't be able to have multiple named instances on...

My first step - check the logs.

My second step - adjust the powershell script to write to a debug file so you can see where it is getting stuck.  That...

As far as I know, this is a manual process.  If you NEED to change the table but don't want to change all of the objects using that table, you...