I didn't pick 1 because isn't the table dropped when the instance is shutting down as opposed to restarting (picky I know but...)

Is Winzip opening a window when run via SSIS?

It could be that the Winzip process is waiting for a response (which the scheduler is never going to give).

Add a File system task and use it to rename the file via a variable.

I can fully sympathize as I am in a hospital office which is shared with people doing "medical stuff" so sometimes you REALLY don't want to be able to hear...

Another (very good) example of something that initially appears to be a horrendous problem having an elegant and relatively simple solution.

Must add to briefcase 🙂

It could be an Excel driver limitation as explained here:

http://sqlserversd.wordpress.com/2008/09/14/ssis-excel-values-import-as-nulls/

I've run across it a couple of times with "apparently" good data being NULLed.

On the Expressions page enter the Arguments expression i.e.

"-s" + @[User:par1] + " -e" + @[User:par2] + " -f" + @[User:par3]

Where par1, 2 & 3 are the declared variables

LEN(field)>0

I usually have about two weeks worth of backups on the server, each database in its own folder and separate files, which are baked up nightly to a remote location....

You could also use two For..Loop containers. The outer to loop through each .xls file and the inner to loop through each sheet in a file. The difference...

Not sure if this would work but shouldn't it be set to the TaskFailure event as "technically" it isn't an error?

I have a setup that sends an email from children...

I used to install the files required to run dtsrun on the machines that needed it ( I got the list of files from http://www.sqldts.com/225.aspx). Used the dtsrunui to...

bitbucket has already created the filename dynamically. The type in bold is what the @currentdate becomes when run.

You might try CASTing the datatypes to DT_DBDATE since 2005 does not cast automatically.

I love photography and (according to the wife) spend far too much on it. Unfortunately I only get a real opportunity to indulge when we're on holiday.