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.
| Author |
Topic |
|
siumui
Yak Posting Veteran
54 Posts |
 Posted - 2013-12-19 : 11:25:47
|
| Hello everyone,I'm very new to develop and test SSIS package.I have created an SSIS package and tested it out. I hardcoded the server name in my SSIS package. But our code standardization is to use configuration files to store server information and not hardcode them in our SSIS package. 1. I don't know what format is configuration file.2. How to create a configuration file?3. Where to save the configuration file?4. How can I reference the configuration file which store the server information in my SSIS package?Please help. Your help is greatly appreciated!Thank you very much!!! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-12-19 : 11:59:03
|
| 1. configuration file can be xml based or registry or environment variable2. configuration file can be created from within the SSIS package3. if xml file is used you can save in file system, if in sql table it will be as records4. once you create configuration in package, it will take the values at runtime from file------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
siumui
Yak Posting Veteran
54 Posts |
Posted - 2013-12-19 : 12:19:38
|
quote:
Originally posted by visakh16
1. configuration file can be xml based or registry or environment variable2. configuration file can be created from within the SSIS package3. if xml file is used you can save in file system, if in sql table it will be as records4. once you create configuration in package, it will take the values at runtime from file------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs
Thank you visakh16.I created a configuration file through the Package Configuration Wizard. Although I have no idea what to select when it asks to check the property to export to the configuration file. I saved the configure file and I opened it, I have no clue how/where to type in the server name in the configuration file. I'm very lost. Please help. Thank you. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-12-19 : 12:35:09
|
| you need to select properties you want to store in config file. It would be mostly connection strings used by connection managers, variable values etc. It will get saved in fileWhen you want to change it edit file and change the values within propertyvalue node. Then on running package it will run with changed value------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
siumui
Yak Posting Veteran
54 Posts |
Posted - 2013-12-19 : 14:34:50
|
quote:
Originally posted by visakh16
you need to select properties you want to store in config file. It would be mostly connection strings used by connection managers, variable values etc. It will get saved in fileWhen you want to change it edit file and change the values within propertyvalue node. Then on running package it will run with changed value------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs
That clears up a lot visakh16! Thank you so much.On the Control Flow tab, I selected the configurateion file in Connection Managers already.But I'm stuck on Data Flow tab. On the Data Flow tab, I pull records from a SharePoint site and insert it into a table on our server. For the OLE DB Destination --> Connection Manager, I tried to add the new connection (not selecting from a list server name that I used to type it out) so I can select the configuration file I just created but i don't know how maybe that why it doesn't work:(. I saw "Named ConnectionString" and I can browse for file which I did and selected the configuration file I had created and when I tested the connection, it pop up a dialog indicating "Test connection failed because of an error in initializing provider. The ConnectionString property has not been initialized.".Please help. |
|
|
|
|
|
|
|
|
Configuration file to store server info