April 27, 2009 at 7:59 am
[font="Verdana"]Hi All,
I have one already developed SSIS package which loads data from one server to another. It has total 30 tables. Most of has simple Select * From Table like statements to fetch and get the resultset from Source DB and further loads into Destination DB. And some of them has table to table mappings.
Now I have to tune the SSIS package. what I am thinking is to replace these Select commands and apply the table to table mappings assuming that they will perform better.
Can anybody please let me know what will be the best approch here? Do am I on the right way?
Thanks in advance,
Mahesh
[/font]
MH-09-AM-8694
April 28, 2009 at 12:40 am
[font="Verdana"]Hi All,
Atleast can anybody let me know, what things to be consider while optimizing SSIS package? What things to be consider for deploying SSIS package from one server to another server?
Thanks in advance,
Mahesh[/font]
MH-09-AM-8694
May 5, 2009 at 6:30 am
Actually I have found that using a select statement with the columns listed out in the query performs faster then a select all or table to table mapping.
The reason being is the SSIS does not have to perform all the metadata processing behind the scenes. A "select *" and table to table mapping are really one in the same.
Hope this helps.
May 5, 2009 at 6:39 am
[font="Verdana"]Thank you,
Mahesh[/font]
MH-09-AM-8694
May 19, 2009 at 8:31 am
check this site for SSIS performance tunning
http://www.simple-talk.com/sql/sql-server-2005/sql-server-2005-ssis-tuning-the-dataflow-task/
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply