![]() Let's take a look at this with a simple demonstration.įor the purpose of this demonstration, let's create two OLE DB Connection Managers, say TestConn1 and TestConn2, both pointing to tempdb database on a local instance of SQL Server. There are various ways to capture the details of a connection manager into a package configuration file and often beginners make mistakes in this step and usually end up capturing individual properties of a connection manager into the configuration file. The most common type of package configuration is the XML Configuration File. Package Configurations are a very important part of SSIS packages and offer various advantages including easier movement of packages across different environments. Capturing SSIS Connection Manager Details in Package Configurations
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |