• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1169
  • Last Modified:

How to TEST run a SSIS Package in my DEVELOPMENT Server?

Experts,

I have a SSIS Package in PRODUCTION that I need to run in my DEVELOPMENT Environment to analyze how long the package takes to run.

How do I simply do a TEST RUN of this SSIS Package??

Do I simply go to my DEV Server, LOGIN to Visual Studio 2010, OPEN the Package and run it within VS2010...??

Please list the steps I need to take in order to RUN this package for testing.

Thanks
0
MIKE
Asked:
MIKE
2 Solutions
 
dannygonzalez09Commented:
copy over the package & config file(if you have any) to your dev environment and change the connection strings in your configuration file or change the connections in your package manually and run it
0
 
Jason Yousef, MSSr. BI  DeveloperCommented:
Download BIDS helper, it's a free plugin that has a tool to benchmark the performance...

check this article here
www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_6615-SSIS-Performance-considerations.html
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now