Swapnil Nandane

Swapnil Nandane

  • 1.7k
  • 121
  • 7.6k

SSIS package performance

Feb 1 2018 1:25 PM
Hello Friends
 
I have one SSIS (.dtsx) package with genrates CSV file after execution, inside package i'm using OLE DB Source for connection to fetch data from MSSQL database with the help of stored procedure.
 
Now i have two server
 
When i executing package on server1 it executes and genrates CSV within second
 
But
When i executing same package on server2 it taking 5 to 10 minutes.
 
Can you guys please help me ?
 
Note:
- I have MS SQL server 2012 
- I have same database on both server(replica of each other).
- Using same package with same configuration on both side(replica of each other). 

Answers (2)