Question Include a file in my VB.net scripts & ASP.Net

[Starlet_GT]

Hi,
I need to include a file in all my scripts which contains a connection string. I am using different VB.net scripts specially in SSIS packages and few ASP sites. actually I have too many scripts now I want to centralize the connection strings so that if I migrate SQL server then I should change details on one place.

Thanks in advance

 

[jmcilhinney]

Firstly, you have no scripts. VB.NET is not a scripting language so there are no scripts.

As for the question, generally you would add your connection string to the config file and the application will then retrieve it from there. There are numerous IDE tools that will do that automatically, e.g. the Data Source wizard. You can also use the Settings page of the project properties to add a connection string to the config file. It's a while since I used SSIS but I think that you may have to add it manually there.