Glad that you could solve your issue and thanks for posting the solution!

Let's hope they do not work with named instances 😉

I think the most important thing to realize for your requirement is that if those 3 flat files have different structures, you must use 3 different data flows.

If they all...

Nice question, but just one small problem:

"In prefix compression, does the entire prefix stored in the header need to match the data to be used?"

--> requires the answer NO to...

What is the datatype exactly in the destination?

You don't get free money??? :w00t: :hehe:

After all, be lucky you are not freelancing in Belgium,...

My personal preference is to make a package for each file.

That way everything is neatly modulare and seperated (especially the logging).

But as Elliot said: It depends 😀

Normally this isn't an issue with your drivers, but with the protection level of your package.

Can you check which setting it has? (It is a package property).

Are you using a stored procedure?

Another option is to point to the child packages location in the SSIS server folder (if you deployed them to the MSDB database).

If you have the same folder structure set-up...

That is true,...

Greg Charles (5/25/2011)

I've done this by creating a SQL Agent proxy for SSIS package execution and using...

Great question, learned something today.

I've seen it once, but that was a TSQL puzzle on how to write a left outer join as a right outer join (or something like that).

So no, I haven't...

You're not? Didn't you get the memo from Steve Jones? 😛 :hehe: