Solved

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

Posted on 2014-02-10
2
876 Views
Last Modified: 2016-02-10
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
Comment
Question by:MIKE
2 Comments
 
LVL 5

Accepted Solution

by:
dannygonzalez09 earned 250 total points
ID: 39847664
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
 
LVL 21

Assisted Solution

by:Jason Yousef, MS
Jason Yousef, MS earned 250 total points
ID: 39847792
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

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Some sers suddenly getting error popup msg 28 86
query execution hang 5 28
How to share SSIS Package? 6 36
SQL Server 2012 - Merge Replication Issue 1 19
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
A couple of weeks ago, my client requested me to implement a SSIS package that allows them to download their files from a FTP server and archives them. Microsoft SSIS is the powerful tool which allows us to proceed multiple files at same time even w…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to shrink a transaction log file down to a reasonable size.

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question