Ha! I'll have to second that one. Not just in forums, but this one runs rampant...

DATEDIFF only accepts values of type datetime. You need to convert your numeric value to datetime using the CONVERT function. Give it a shot and post additional questions...

It would help greatly if you could post a sample of the queries that cause the performance problem as well as the table DDL including index information.

Ah, thanks for the clarification. I just wanted to make sure that you weren't just using the Script Component because it was there. You never know what someone's...

I would suggest a similar approach to Dave's last post. If your Descriptions table has some sort of identifier column that allows you to group Descriptions into types, I...

It looks to me like they've created a universal 'Descriptions' table that gets linked to every other table in the system. Would this be an accurate statement?

If you are inserting the parent table first, then the child, you'll need to lookup the parent ID as part of the child insert. I see that you are...

Some of that will also depend on what else the function is doing. Is it just a simple lookup or is it performing calculations? I would recommend looking...

Some of that will also depend on what else the function is doing. Is it just a simple lookup or is it performing calculations? I would recommend looking...

Ah, yes. I see earlier in the thread that you said that the table names were the only differences. This will work much better than creating data flows...

Or, create a standard error trapping method so you can always capture an error created in a nested TRY/CATCH block.

MH, if you are doing this via SSIS, you'll want to use a lookup transformation in your Employee data flow. You'll use the Department name to lookup the DepartmentID....

Hey, I'm from Nebraska......I Shuck too.

GSquared (7/6/2009)

---

arthykannan (7/6/2009)

---

You guys shuck. every time we have to go and register or it says we have to go and click the freaking link. and the email doesnt...

It looks like your xml/xsd did not show up. You may want to use the Preview option before posting.