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).