I did some testing on my laptop and got it to work with the driver from here:

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=23734

In summary, I couldn't load the 32 bit 2010 version of the drivers because...

Are the connections being overwritten in the Job Step - Data Sources tab?

Also, fyi, there's an execution option in Job step to configure 32 bit execution for use with the...

ndenton (8/3/2011)

---

I've gotten as far as getting it to open the spreadsheet and running the query to get the max date but I can't for the life of me...

This should be what you need: http://agilebi.com/jwelch/2007/05/05/handling-multiple-errors-in-ssis/

The basic principle is instead of sending a message on each OnError event, store the messages during the event and send them together afterwards...

One typically faces locking issues.

I would suggest serialising the packages.

Even if your packages are running serially they can still have problems if you are using transactions. Locks are not...

Basically you need to find where your gacutil.exe is located and execute it with the /i switch and the assembly file like so:

gacutil.exe /i "C:AssemblyLocation\assembly.dll"

here's a link with a specific...

SELECT LEN('How long is this?')

This would return 17.

That help?

I've made another change, this time to View#1 (a standard restricted self join to eliminate 'duplicates').

Prior to this change it was possible to have what are effectively duplicate records on...

In a further test on production,

changing the Join in View#3 from a LEFT OUTER JOIN to an INNER JOIN results in 14983 rows returning in 3 seconds.

In addition the execution...

In other news, applying steps 1 and 2 above to the development database results in 64,000 rows returned after 9 seconds. It also creates a couple of statistics against each...

I've just tried the following on production:

1. Drop all indexes and statistics on SSIS_ExecutionLog and SSIS_ExecutionLog_History tables.

2. Execute view [vw_F_ExecutionLogMerge]: returned 22000 rows in 5 minutes 50 seconds. Execution...

Thanks for the replies,

Both databases are on the same instance which is on a single virtual server hosted by a 3rd party, so I can't be 100% sure that both...

http://social.msdn.microsoft.com/Forums/en/transactsql/thread/bfdc32d3-3d36-4d63-8d87-6ee972fd8130

I was just reading this the other day.

It will either help or muddy the waters 😉

The only thing to be aware of is that SSIS wipes any sensitive information (i.e. passwords for connections) when you open the package if you don't decrypt it correctly.

Since the...

Basically, you change the row disposition on your oledb destination to send error rows to an error output rather than fail and divert that path to a flat file component.

->...