Well, start by comparing the schemas... it should be easy enough to do manually. Then do a row count. If you need deeper analysis then you'll need to...

Did you put a check on 'keep nulls'?

I think I speak for everyone here when I say that the full error message would help. Tell us exactly what we're dealing with and we can help you.

I'm intrigued by this. Tell you what... give me a call and let's discuss this a little further if you like.

817-937-6154

Excellent. Now we're getting somewhere. So what happens when you try to open the package?

Can you open it, or can you just not edit it?

I know you said it's local, but how are you connecting to it? If you're inside the package itself can you get it to run locally? So in...

Start by looking in perfmon at the CPU counters.

If you already know you're having CPU issues, you can look in master.sys.sysprocesses to see which processes are using the...

Yeah dude, that's a tough one. You may be having network issues at that time. Do they do regularly scheduled maint at that time or something? Do...

Yeah, I've been asking MS for package sorting for 3yrs.

And it doesn't look like it was a priority in Katmai either.

Watch my free SQL Server Tutorials at:

http://MidnightDBA.ITBookworm.com

Yep, that looks good to me. You should be fine.

Watch my free SQL Server Tutorials at:

http://MidnightDBA.ITBookworm.com

Try using an oledb source instead. also if you could post the schema of the table, that might help. Are you taking all the cols?

How are you returning the new ID value?

You know, you could be severely fragmented too. That'll eat up a lot of space.

Thanks. Glad I could help.

I've had good luck with simple SPs, but with complicated SPs that had a lot of selects, I don't think it handles that very well.