December 1, 2014 at 7:43 am
I have a package with two connection managers (ADO and OLE) pointing to a deprecated database. So, I open it up in Visual Studio 2008. For both, I right-click on a connection manager, choose "edit", then set the desired values.
I save the package. Then I try to run: I get errors associated with packages not being found, as all the Execute SQL tasks have random strings for a Connection Manager instead of what they were a minute ago.
However, I look at the properties of both connection managers....Guess what, they are again pointing to the old database!!
Has anyone seen this before? Does anyone have a suggestion how to get VS 2008 to accept a change to a database?
Thanks,
December 1, 2014 at 12:09 pm
Sounds like there are expressions setting the database name. Right-click on the connection manager and select properties. Then expand the Expressions property. This should show you how the Connection Manager properties are being set.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 2, 2014 at 7:01 am
Jack, thanks so much for the reply. It turned out to be from a long-forgotten package configuration.
I am very impressed that you solved it. I thought that this was a Visual Studio 2008 bug! 🙂
Thanks again!!!
December 2, 2014 at 7:39 am
Glad I could. I'm still working in 2008 and I've had the same thing happen to me with some packages written by others.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply