October 4, 2012 at 3:35 am
I have to use same formula to fill the calculated data in different tables. I want to make this formula configurable so that no need to write formula everytime simply pass the values to the formula and it will return the calculated value.
SSIS packages are used to populate the data in the tables and I can't use SQL User defined function because that is decreasing my SSIS package performance.
Please suggest some good approach.
Help is really appreciable.
October 4, 2012 at 5:31 am
singh.anirudh31 (10/4/2012)
I have to use same formula to fill the calculated data in different tables. I want to make this formula configurable so that no need to write formula everytime simply pass the values to the formula and it will return the calculated value.SSIS packages are used to populate the data in the tables and I can't use SQL User defined function because that is decreasing my SSIS package performance.
Please suggest some good approach.
Help is really appreciable.
I would think it depends? How complex is the code you want to re-use? Does it do data access?
Bear in mind it won't necessarily perform better if you move it to the Package.
A little more information would be nice.
October 4, 2012 at 10:47 pm
Complexity of the calculations is medium, yes it is doing data access. Please suggest by which way I can get the good performance and my purpose will also be solved.
I am using SQL Server 2008 R2. I am thinking to use DDL means I'll create the formula in the .NET and then create a .ddl of that and then will use that .DDL either in SQL or SSIS.
Please help.
July 11, 2013 at 12:23 pm
Hi Anirudh,
Were you able to find a solution to this problem ?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply