Excellent Jane!

Can I steal it?

Glad to hear you finaly got it Jenny. Take the rest of the week off.

Thanks, Steve. That did the trick.

(And thank you again, Jacob.)

Now I really feel dumb. I open the page at:

http://www.sqlservercentral.com/articles/Miscellaneous/2996/

and see:

...

One of the most useful methods exposed by the XML data type is the Value() method. Here, I am presenting...

Not yet a solution, but a plan:

Your (pduplessis) BCP suggestion was a very good one; BCP will create and reference format files (either .txt or .xml) which would help in...

Thanks Jacob. That would make life easier, but when I try it I just get:

Articles with tags Miscellaneous, 2996, axp1, axp2.txt

Search for any content tagged Miscellaneous & 2996...

Just don't do it! As usual, Jeff is right. (And it is one of the worst ideas MS ever came up with.)

I think not. But in a script task you could probably define a read-write variable that get's set to whatever your input flat file source needs. The example syntax...

In my case (looping through Excel files) it is hidden away under Excel Connection Manager\Properties\Expressions (They start out hidden, you need to click the + to see them.) In my...

Just a guess, you may have neglected to set the expression in your input data set connection to pick up the file name from a variable.

Pduplessis - The duck just dropped down (or don't you go back that far)!

I suspect BCP with a Format file is exactly what I need & was missing.

THANKS!!

But the problem is not (yet) multiple sources and multiple destinations. Take the simple case of one input file and one output destination. When the input file (fixed field...

You are right Sergie, and I'm convinced that I need to create a simple sample that demonstrates the problem. (But that is going to take a while.)

I got some more...

Thanks for the suggestion, ulile.

I may be suffering from "If your only tool is a hammer..." blinders, because I saw the problem as "How do I get SSIS to..."...

I'm learning a lot from this. Thanks!

Not to look a gift horse in the mouth (or publicly reveal my ignorance)...is the raw source code available somewhere? Having to delete the...