I resolved this issue this morning.  It was really the simplest most painfully obvious solution too.  We simply created a second data source and used the domain credentials in question...

I resolved this with the following.  The restore-sqldatabase requires variables for the relocate files.  I was previously adding the variable contents directly to the array. By creating a variable, then...

I did see that post.  The second answer worked for me only if created and passed them manually. I still could not dynamically create those objects and pass them.

Yeah so......you have to specify a database in the connection string. Did not know. This is working.

These are virtual machines, esx 5.1.  Both on windows 2012 R2. 

On the disk front, two vmdks, one for OS, one for everything else. Thick eager porovisioned. Average...

Eirikur, I have tried both estimators.  I've got nothing here.  I will run it to completion the first opportunity I have.

Sure.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/34e5596a-4d02-4499-8a4e-8dad9fa27528/ssis-2008-r2-script-task-fails-when-run-as-job?forum=sqlintegrationservices

http://www.sqlservercentral.com/Forums/Topic886366-148-2.aspx

http://clausoncode.dk/wp/?p=180

Unfortunately no, in the case of failure its

Source: Import Data From Excel Description: Exception has been thrown by the target of an invocation....

Yessir, both result in the same

Can you give example data for m.customer_order_no?

What error messages are you getting? Are you unable to get the database into Emergency Mode,Single User mode?

The very last paragraph of the Randall article you linked states:

Note: it’s...

I edited my original post. If the log files exist, you can try to set each database offline and online again.

Also, start taking backups and check your production environment...

Do the log files exist? edit: Is the log drive back online and accessible by the operating system? If so, are the log files there? If the...

I agree, a calendar table is the way to go. You could code holidays into the case statement relatively easily, but you may as well create the calendar table...

This creates a CTE table containing all dates between @ProjectStartDate and @ProjectEndDate datetime variables. The subquery below determines if the day in the CTE are Sunday or Saturday using...