TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Swapnil Nandane
NA
121
17.1k
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).
Reply
Answers (
2
)
client sql connect without turnoff firewell
Auto ID generated jumping Values 1000 .. please Urgent