Viewing 15 posts - 1,336 through 1,350 (of 3,232 total)
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...
July 10, 2009 at 2:35 pm
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.
July 10, 2009 at 2:23 pm
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...
July 10, 2009 at 9:44 am
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...
July 9, 2009 at 9:26 am
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?
July 8, 2009 at 3:38 pm
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...
July 8, 2009 at 3:29 pm
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...
July 8, 2009 at 3:25 pm
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...
July 8, 2009 at 3:25 pm
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...
July 7, 2009 at 11:30 am
Or, create a standard error trapping method so you can always capture an error created in a nested TRY/CATCH block.
July 7, 2009 at 11:23 am
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....
July 6, 2009 at 3:43 pm
Hey, I'm from Nebraska......I Shuck too.
July 6, 2009 at 1:05 pm
GSquared (7/6/2009)
arthykannan (7/6/2009)
July 6, 2009 at 12:54 pm
It looks like your xml/xsd did not show up. You may want to use the Preview option before posting.
July 6, 2009 at 12:33 pm
I think what PEPEPACO_1980 is saying is to use a stored proceudure to parse out your XML instead of an XML data source adapter. Still use SSIS to process...
July 6, 2009 at 12:11 pm
Viewing 15 posts - 1,336 through 1,350 (of 3,232 total)