December 16, 2011 at 1:12 am
I have to convert a stored procedure into ssis package.Procedure calculates and do transformation for some 50 columns and inserts in a table.Every column value is calculated by calling a user defined function.So if I have 50 columns there will be 50 functiions.This procedure can be called for a single project or for all the 900 projects.
What is the best approach to convert this procedure in ssis?Should I use directly this user defined functions in the package or can use some other alternative?
What will be the performance impact of converting this procedure to ssis.Currently procedure takes 2-3 hours to complete I have to reduce this processing time also.
I am using Sql Server and SSIS 2008.
December 20, 2011 at 6:01 am
There is no easy answer for that.
It depends on those user defined functions: how complex are they, can they be translated into SSIS or not et cetera. You can call those udf's from inside SSIS, but you won't get any substantial performance benefits.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply