Ah, well I cannot encrypt the package or put a password on the package.  I simply need the DB connections to keep the passwords and use the ones in the dtsconfig...

ah-HA! the flat file connection manager eh?

that worked thank you Jamie. I would never have found that yet another hidden column thing.  Wish there was a quick easier way to...

ah-HA! Thank you so much, those options escaped me before.  much appreciated!

And on my larger issue:

Debugging the type conflicts with the OLE DB Destination is tough, it only gives a very basic error that an OLE DB step failed. I...

Oh good grief.  This was a harder day than expected.  Seems, bottom line, those errors are meaningless all they tell you is "there was an error and the box is gonna...

I'm just begining too I *think* it goes like this.  Be sure you are in task panel and not clicked into any tasks and add a variable, it should be...

Well you're doing better than I am, I can't even get my package to run.  Still have hope though but it's a tough.

I got that with a SQL Task, in the result set tab I set the Result name to the column "ID" (which is what's called in the SQL statement) and the...

Thank you guys!

No code to post I was using the EM to restore a DB backup.

My latest guess is the 2005 backups are just totally incompatible with 2000.  I tried setting the compatibility...

That's an elephant?!?!?  Really?  Did you need special duotone glasses to see it?

Oh man, I've never gotten this modern art stuff.

Ah-HA! Thank you.

What language am I thinking in again.... ?  Now more than ever.

much appreciated!

DTS is gone. So I'm curious what are you doing, writing your ETLs as C#/VB assemblies, doing it all in TSLQ?  What's your new methodology?

thanks!

Can you post the SQL statements you are using?

The only mentions of that parameter seem to be related to replication issues.

good luck.

I appreciate your neutrality Jamie, thanks so much for the additional info!

!Fantastico!  Thanks guys.