AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
The connection properties are changed from the Package Connection Manager which can be confusing. Once a connection is created in the Project Connection Manager, it is available to the packages in the project. If the connection to the database needs to be used in multiple packages, use the Project Connection Manager. ![]() These Connection Managers are available to either just the package or any package in a project. The Connection String for a database can be created for an individual package or for a project in Visual Studio. This article is going to dive into an example that parameterizes the Server Name and Initial Catalog (database name) in a connection string for packages in a project. Project parameters have become the go to solution for changing variable values in packages at run time. ![]() Variables were a step in that direction, but with Project deployments to the SSIS Catalog in SQL Server 2012 Microsoft has stepped it up, even more. SQL Server Integration Services (SSIS) has been growing into an enterprise solution over the last three releases.
0 Comments
Read More
Leave a Reply. |