I'm wondering if the connection is getting dropped and reconnected. Have you tried SQL Profiler to see exactly what is going on with SQL and that app?

I don't think you can do it the way you have it, the DB engine has no way of knowing what row in the base table to update, you could...

I think the previous poster was exactly on the right track, however, I had some additional thoughts, is the value '2/2687' or the product of what appears to be a...

I also found this:

SQL Server 2005 BOL (Nov 2008)

ms-help://MS.VSCC.v80/MS.VSIPCC.v80/MS.SQLSVR.v9.en/extran9/html/e66349f3-b1b8-4763-89b7-7803541a4d62.htm

The Excel source extracts data from worksheets or ranges in Microsoft Excel workbooks.

Note:

On a 64-bit computer, you must run packages...

I'm a little fuzzy on what you are trying to accomplish. Let me see if I understand..

You have an SSIS package that outputs data to an Excel Spreadsheet with...

You can also set the package or that item to DelayValidation = "True", what it means is that the variable doesn't need to have a valid command until the moment...

Remote Desktop and SQL Agent are the only "good" ways to do it, you could use DTEXEC through xp_cmdshell, or for build a sproc that does it for them so...

It should be completely fine. What you lose is some of the better memory management and some performance because 64bit SSIS performs better than 32bit (in general) based on...

The Excel provider is really the Excel Jet provider, and there is ONLY a 32 bit provider for it. I ran into this as well. When you run...

I agree, there are lots of ways to handle this, package configurations is the place to start. You can do it with:

1. Registry entry.

2. dtsConfig files.

3. A table

4. Environmet...