January 31, 2012 at 12:39 pm
Hi,
I have a Visual Studio package that pulls data from an Access table and imports it into my SQL server. The database that the Access table resides in has changed locations. How do I point the source query to this new location in Visual Studio? Thanks
January 31, 2012 at 12:57 pm
Hmm,
Hopefully you have an App.Config file in your project and inside there you should see (in the XML) :
<configuration>
...
<connectionStrings>
<add name="SomeDB" ...>
</connectionStrings>
...
</configuration>
There should be a path in there.
This question should probably be moved over to one of the programming forums though...
January 31, 2012 at 1:43 pm
guerillaunit (1/31/2012)
Hi,I have a Visual Studio package that pulls data from an Access table and imports it into my SQL server. The database that the Access table resides in has changed locations. How do I point the source query to this new location in Visual Studio? Thanks
Are you using SSIS, or some other tool? If SSIS, you need to change the connection manager (usually located at the bottom).
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply