Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 How can I get BIDS to refresh its ODBC info?

Author  Topic 

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2013-11-01 : 09:42:41
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

52326 Posts

Posted - 2013-11-01 : 12:42:47
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
   

- Advertisement -