Does each of the text files have the same schema, but just differ by name?

Do you know in advance how many records will be written? If so, maybe a For loop could do it.

But 1,000 lines is nothing. How many rows (approximately) are you...

Assuming that all of the XML files are of the same format, a Foreach container is the way to go.

As an overview, you'll need to configure the Foreach container to...

Or if your flat file already contains a PK, you could multicast to all the tables and then run UPDATE queries at the end to set the FKs, using the...

There may be another way.

In your source data, are the records linked by keys? Ie, is there already a candidate PK on your source header record? If there is, you...

So are you using a Foreach loop to process all files in a folder? If not, how are you doing it?

Are you running it all on your local PC? Looking...

What is your resultset property set to?

What sort of task? Custom code, or a standard component?

If your source data is numeric, it can remain numeric all the way through the data pipeline without any need for transformations.

You should check the meta data for your source...

You could use CAST to set the datatype at source:

declare @distribution_id char(10), @num_dist_id int

set @distribution_id = '1'

set @num_dist_id = cast(@distribution_id as int)

select @distribution_id char10, @num_dist_id numeric

Are the multiple destinations independent of each other?

Running in parallel might be a better option if they are ...

Oh that is a much tidier idea, try that first! Nice one.

Try reading this thread and you'll get an idea of the complexities involved:

http://www.sqlservercentral.com/Forums/Topic531295-148-2.aspx#bm734565

I won't be able to help any further though - I haven't tried it (don't really want Excel...

Perhaps one of these is a named range rather than a worksheet?

And the results from Activity Monitor are ... ?

Maybe tempdb is getting locked and that is blocking the update...

If all else fails, why not just run the UPDATE first and...