opening SSIS package for edit

  • Hi, I need to change the login info for one of my ssis package and visual studio is not installed on the DB server.

    So where and how can I edit the package?

    Thanks.

  • I believe you need SQL Server BIDS.

    http://msdn.microsoft.com/en-us/library/ms173767.aspx

    Bob
    -----------------------------------------------------------------------------
    How to post to get the best help[/url]

  • Take a copy of the package from your source control system (which everyone always does :-D) and use BIDS (business intelligence development studio, part of the SQL Server client tools). Then open the package (double click it in the solution explorer) and edit the connection string in the relevant connection object.

    Once done I would strongly recommend you consider moving the connection string (and anything else that might frequently change) to either a SQL Server configuration table (my personal preference) or file, there is plenty of information out there on how to do this. It will allow you to change this information without having to alter the package.

    Is a good place to start.

    MCITP SQL Server 2005/2008 DBA/DBD

  • That's correct. You need the client tools installed on that box, which will give you BIDS, and if you have VS for the correct version you'll be able to work with SSIS packages. SSIS is still version dependent. 2k5 needs VS2k5 and 2k8 needs VS2k8.

    I'm not sure if R2 cares about a version of VS2k8.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply