SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Configuration file to store server info
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

siumui
Yak Posting Veteran

54 Posts

Posted - 12/19/2013 :  11:25:47  Show Profile  Reply with Quote
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

India
52317 Posts

Posted - 12/19/2013 :  11:59:03  Show Profile  Reply with Quote
1. configuration file can be xml based or registry or environment variable
2. configuration file can be created from within the SSIS package
3. if xml file is used you can save in file system, if in sql table it will be as records
4. once you create configuration in package, it will take the values at runtime from file

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

siumui
Yak Posting Veteran

54 Posts

Posted - 12/19/2013 :  12:19:38  Show Profile  Reply with Quote
quote:
Originally posted by visakh16

1. configuration file can be xml based or registry or environment variable
2. configuration file can be created from within the SSIS package
3. if xml file is used you can save in file system, if in sql table it will be as records
4. once you create configuration in package, it will take the values at runtime from file

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://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.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 12/19/2013 :  12:35:09  Show Profile  Reply with Quote
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 file
When 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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

siumui
Yak Posting Veteran

54 Posts

Posted - 12/19/2013 :  14:34:50  Show Profile  Reply with Quote
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 file
When 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 MVP
http://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.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000