It seems the package was actually failing after the varying number of rows, but it was showing that it had succeeded. The source was providing strings like '"25000"' ...

Answers should be definitive. This one is NOT. Never should have made it to QotD.

Is this what you had in mind? I think it's going to work. Thanks.

To answer Phil's question (and to hear myself think), on Fail, we'll just go right...

I'm with you right up until "precedence constraints with expressions to eliminate files...".

What would the expression be? Run through all the files until a C%.txt file fails...

I'm in the field, but I'm not sure how to express 2 separate clauses that both must be met. Further, my VB script skills are worthless. Can someone...

sorry Lynn. "UNION ALL" would have the desired effect in that example, but it seems too contrived to be elegant much less efficient.

Destination table has 150 columns.

There is a...

I've tried every permutation of every suggestion given to me and it just won't work. If someone's got a .dtsx they could send me that imports all .xls files...

sorry... I didn't answer your question...

I'm not currently setting the ExcelFilePath, rather, I'm setting the ConnectionString object. I've tried both though with the same deflating results.

Yeah, the DelayValidation is set to true for ALL of the data flow, ForEach looper, and the Excel Connection Manager.

I found a similar post here that I've been working off:...

Thanks Mukti, but I tried both suggestions (DelayValidation = True, and setting the ExcelFilePath property to my variable), but got the following message (basically the same one, but abridged):

Error at...

More precisely...

How can I programmatically change the "Directory" attribute of the ForEach Loop container based on user input?

THANKS!

I should mention... the reason I thought to use the package configuration approach is because the directory that it's going to source from will change (based on user input), and...

Fellas, that Common Table Expression worked like a charm. I'm now avoiding gobs of tempdb space, avoiding referencing tables multiple times, avoiding the date arithmetic error, and returning resultsets...

Here are the UPDATE and DELETE statements that get parsed together. I generated them just now and ran them successfully in Management Studio.

UPDATE a2db_rawhistory.dbo.tx_oilfield ...

RBarry, you in DE? I lived in Hockessin/Newark/Greenville growing up. Went to Univ. of DE.

Here's the definition of the underlying sproc:

----------------------------------

CREATE PROC [dbo].[usp_RTRH] (

@rawdb VARCHAR(128),

@rtrhdb VARCHAR(128),

@tname VARCHAR(128))

AS

SET NOCOUNT...