July 5, 2011 at 11:46 am
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.
July 5, 2011 at 12:26 pm
I believe you need SQL Server BIDS.
July 5, 2011 at 12:42 pm
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.
MCITP SQL Server 2005/2008 DBA/DBD
July 5, 2011 at 1:08 pm
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.
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