Hello Everyone, I m Still not cleared with package configurations. How can i use this package configurations. I m askin this question again as i m not cleared. I have followed many links and used them also but still not cleared how to use package configurations. I have created package configuration in that i have used XML file where i have put my connection String Now i want tht my package should use all the connection string from that XML file only. I have asked this question before also .not got satisfactory reply that's why i am asking this question again. Please help me out or provide some solution or suggestion or links .

Hello Ajay, You need to help us to help you. You need to tell us what exactly is your issue. Are you not able to set up te configuration. Which task is failing and what is the eror that you are getting.My Blog | Ask Me | Test your SSIS skills

Read all the following links carefully: http://msdn.microsoft.com/en-us/library/cc895212.aspx http://msdn.microsoft.com/en-us/library/ms141682.aspx http://msdn.microsoft.com/en-us/library/ms141132.aspx http://msdn.microsoft.com/en-us/library/ms167153.aspx http://msdn.microsoft.com/en-us/library/ms140213.aspx These links are all MSDN pages that explain the concepts of package configurations. I can't explain it myself better than those tutorials/howto's/documentation...MCTS, MCITP - Please mark posts as answered where appropriate.

You need a separete Configuration to you SQL Server which holds the Table SSIS_Configuration. This configuration has to be the first one in your configurations list. It can be a XML-File or an Environment variable with the Connectionstring to the SQL Server.

Ya i Have seen all these links plase see my above example i have used now suppose i change my connection string in database table suppose i converted my Source string to destination and destination to source vice versa so in my above package source will become destination and destination will become source this what i want but its not happening. My package is taking hard coded value which i have set during making package in OLEDB Source and OLEDB Destination. Please provide me some examples or links or suggestions .

Ajay did you check this -> Right click on the control flow -> Package Configuration -> Package Configuration organizer do you see the Enable Package Configurations selectd??My Blog | Ask Me | Test your SSIS skills

Hello Ajay, You need to help us to help you. You need to tell us what exactly is your issue. Are you not able to set up te configuration. Which task is failing and what is the eror that you are getting. Have a look at this and it should clear your doubts. for further queries provide the above inputs. My Blog | Ask Me | Test your SSIS skills

Hello everyone 1)I have created one SSIS package Demo which consist of 500 tables or 500 data flows in that data flows i have used(OLEDB Source,OLEDB Destination) there are two different connection string name 1)Source 2) Destination which is used by (OLEDB Source,OLEDB Destination) 2)Now i have Used package configuration in this package. i have used configuration type:SQL Server n i have created table name :SSIS_Configuration in that table i have defined two connection string name 1)Source 2)Destination which is different from above two string defined in 1 step 3)now problem is commin that i want that my package should read connection from SQL Table SSIS_Configuration not from step 1 4)But when i m running my package all the time it is reading from step 1 pls suggest me some solution or provide me some link for this i want tht my package should read connection string on run time (Dynamically) from SQL Table SSIS_Configuration I want to see the real use of SSIS package configuration.which not given in any of examples. The examples which are given for package configuration just tells that how to configure connection string for packages Its not given over there that how to use these Package Configuration. I am finding solution for this problem from month but not yet resolved Please Provide some solution or example or link so that i can understand it quickly

ya Package Configuration organizer the Enable Package Configurations is selectd. Last time when i have asked same question i got same replies. I have to resolve this problem bcoz its too important as i have to change my server at deployment time . i dont wana go in each and every DATAfLOW TO CHANGE CONNECTION STRING BCOZ THERE ARE 500 DATAFLOWS ARE there please provide some link where this type of example is been used .

ya Package Configuration organizer do you see the Enable Package Configurations is selectd. please provide some link where this type of example is been used . Ajay, Please give folowing information. 1. SELECT * from {your ssis configurations table } your configuration filter name used in package configuration 2. your source and destination connection strings [ a. NAME of the variables that you have created to be used in connectionmanagers b. ARe the connection managers Property : -> Expression -> ConnectionString : SET and if yes then what is the value of the expression you have set ] for both the connection managers 3.DO YOU have any other package configurations set up for that data flow.??? if yes then WHAT IS THE ORDER ? 4. HOW / WHAT IS THE SQL SERVER configuration settings yuo have specified ? DIRECT / environment / etc ... Hope that helps ... Kunal

could you provide screenshots of what you did actually and where you have problem?http://www.rad.pasfu.com My Submitted sessions at sqlbits.com

please provide some link where this type of example is been used . I provided you 5 links. Some of them link to tutorials and how-to's. Please do the effort to read them thoroughly.MCTS, MCITP - Please mark posts as answered where appropriate.

Thanks Koen, For providing links. Please understand my problem . In Creating Package Configuration i m not finding any problem at all. I m able to create package configuration in xml and also in SQL server.In package configuration i am storing connection string. but when i am running the package i want my package to read connection string from my Package configuration which i have made Its not doing so instead of this its taking a connection which i have given in OLEDB Source and in OLEDB Destination. Hope now u understand my problem.

that is the reason why I asked some screenshots, maybe you did something wrong.http://www.rad.pasfu.com My Submitted sessions at sqlbits.com

This is because the package doesn't find it's configuration. From the beginning: 1. create a XML Configuration file to store the connection String to the database which holds your SSIS_Configuration table 2. place this configuration on the first place 3. place the configuration based on your SSIS_Configuration table on the second place This should work, I do it all the time

When you run the package, do you receive any errors/warnings? There should at least be some configuration warnings.MCTS, MCITP - Please mark posts as answered where appropriate.

Thanks a lot Christa Ur solution worked.