thanks, yeah had to comb through the text file line by line and tab by tab.

now just gotta get the text file to work when converted back an excel...

Well even in SSIS 2008 this is still a problem. We have a single config. file shared among a dozen packages so we can re-point them all at once.

Due...

Moving projects from machine to machine with shared config files is has become an issue for us too.

Currently we move the solution between machines, and back and forth from the...

thank you.

on the table seeding was set to 1 seed, and 1 increment,

then 0 seed, and 1 increment.

Then identity insert is toggled on then off to insert a zero ID...

Great thoughts thanks everyone! You're helping clarify the next choices.

much appreciated!

Interesting, thanks.

Where so you find EngineThreads? I didn't see them in the package properties.

appreciate it.

Great Thanks all!

All good points.

Yes the data volumn is pretty big and it's been getting slow with just SSIS, I appreciate the sanity check on the Aggregate Transformation.

Since this issue, in other packages I've built,

I have found that if in the same package,

there is a truncate task of the same table I am loading

then DTC...

Thanks Michael, good to know.

Are you able to use SQL BIDS 2008 (in VS2008) side by side with SQL BIDS 2005 as well?

I'm really concerned about compatibility with my...

Yes that is exactly my situation... again.

Have a sql task to truncate

then a data flow to populate

put them both in a sequence container with transactions required.

The truncate runs, and the...

I just had to right click on the config file and select exclude from project.

The config files were still present on the hard drive, and the packages were using them.

But...

darn.

Thanks for the quick reply.

Guess we're stuck with the "it'll run forever" WHERE NOT EXISTS clause.

appreciate the help!

Well the Sequence Container uses distributed transactions.

DTC appeared to be the issue for me and switching to SQL transactions with the "keep same connection" option resolved it.

So I'm still...

I started getting this "System.ApplicationException: Could not copy file ... to the deployment utility output directory " error too when I set my project to build the deploy package.

Even though...

Any hint helps, you never know. We'll look at those RCP settings too.

This is a strange one.