Click here to Skip to main content
15,354,450 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have a dataflow task which going to pull the records from Server B table and load it in Server A table. I'm using OLEDB source and OLEDB destination transformations. the OLEDB source is sql query that depends on variable (table name will be changed at the runtime in the from clause). the source sql query getting around 500 to 1500 rows.

the package is deployed in Server A,
the package runs very good for a past six months,
now the package and Data Flow task is started and showing progress info, but in the OLEDB source transformation its in ideal not showing progress info also.

but, when the source query run from the SSMS in the server A its finished rendering records in 15 seconds, but the package takes long time more than 30 min and its in ideal not showing progress info.

kindly guide me to fix it, thanks in advance...
Posted
Updated 3-May-16 21:28pm

1 solution

This sounds like the query you use to get data is not performing very well.

If the source is an SQL Server database, probably the best way to find out what takes time is to use SQL Server Profiler[^]. Profile the incoming calls from the source server side and see if the query is the bottleneck.
   
Comments
Member 10108172 14-Oct-15 3:16am
   
Mika thanks for the response, the sql query is just a select statement with date filter and query is executing in ssms within 15 sec, but no response in the ssis package.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900