SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 How can I get BIDS to refresh its ODBC info?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

gbritton
Posting Yak Master

131 Posts

Posted - 11/01/2013 :  09:42:41  Show Profile  Reply with Quote
I created a new user DSN in ODBC Admin. Then I started to create an SSIS project to use it. I ran the import/export wizard to create the links but realized half-way through that I had erred on the DSN definition. So, back to ODBC admin I went. I corrected the error and tried to run the wizard again in BIDS. However, it was unaware of the change I had just made to the DSN definition. I actually had to completely exit BIDS and launch it anew to get to the revised DSN definition.

So, my question is: Is there a way to tell BIDS that it needs to refresh its ODBC info?

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 11/01/2013 :  12:42:47  Show Profile  Reply with Quote
not something you can do from UI directly. Best thing would be to relaunch.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000