Possibly an alternate approach (that has worked well for me):

Control everything from within one of the Excel Workbooks. Instead of pushing the data from SSIS, define the data in Excel...

I hit the same dilemma converting MS Access tables with boolean columns. Since SQL Server has no boolean data type, my first inclination was to use bit.

But being a...

Yes indeed I did.

And why did no one take the opportunity 4 days ago to say:

"May the 4th be with you"?

(And why in the world did the Spell Check want...

I would guess (based on no knowledge of what you are doing--but I do that all the time:-)) that the earlier suggestion that you take a harder look at normalizing...

I use a poor (simple?) man's solution that runs a sweep of all data base objects nightly, and captures a copy of anything that has been modified in a table.

Works...

Excuse a (probably) dumb question:

Where is MaxConcurrentExecutables, and why does -1 not mean unlimited?

I think I recall failing to get a try/catch block to work (but likely not with a #temp table) because (I thought) the error returned was not at a high...

In the two or three cases where I have modified a query using CTEs to #temp tables, I have seen significant performance improvements. (Not careful study or timings, just ad-hoc...

The optical paper (mylar) tape...

I'm not sure why I started reading this thread. As I did, I kept asking myself "Did I do that?", "Are they talking about me?"

Don't you dare change, you...

If you reach the point where you want to try another approach, I have had excellent luck letting the workbook "pull" the data from the server on demand, using Import...

Quick survey: Nine pages later, has anyone change their mind about anything?

Who made the APL dig? (Steve?) The beauty of APL (and later J) is that it is array based (set based, but in more than SQLs two dimensions limit.) Yes...

SQL does not rely on the format of the underlying data store. I've been impressed by the Jet Engine/ODBC ability to work with flat and CSV files, as well...

SQL does not rely on the format of the underlying data store. I've been impressed by the Jet Engine/ODBC ability to work with flat and CSV files, as well...