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


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.

LVL 17
MIKESoftware Solutions ConsultantAsked:
Who is Participating?
dannygonzalez09Connect With a Mentor Commented:
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
Jason Yousef, MSConnect With a Mentor Sr. BI  DeveloperCommented:
Download BIDS helper, it's a free plugin that has a tool to benchmark the performance...

check this article here
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.

All Courses

From novice to tech pro — start learning today.