My SSIS package is not reading the values in from the Package Configuration SQL Table.
What is the error?Arthur My Blog
January 31st, 2011 1:12pm

What is the error?Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
January 31st, 2011 1:12pm

There is no error... I have a variable which is populated with an email address. When I change the email address in th package configuration table it does not change in the package.Mr Shaw
January 31st, 2011 1:17pm

There is no error... I have a variable which is populated with an email address. When I change the email address in th package configuration table it does not change in the package.Mr Shaw
Free Windows Admin Tool Kit Click here and download it now
January 31st, 2011 1:17pm

On the send mail task I have Delay Validation to FALSE... Should this be TRUE?Mr Shaw
January 31st, 2011 1:18pm

On the send mail task I have Delay Validation to FALSE... Should this be TRUE?Mr Shaw
Free Windows Admin Tool Kit Click here and download it now
January 31st, 2011 1:18pm

This could be related to how the config settings are designed to be applied. If this is SQL Server 2008 then the design time settings may get re-applied. Do you need more help on this?Arthur My Blog
January 31st, 2011 1:19pm

This could be related to how the config settings are designed to be applied. If this is SQL Server 2008 then the design time settings may get re-applied. Do you need more help on this?Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
January 31st, 2011 1:19pm

This could be related to how the config settings are designed to be applied. If this is SQL Server 2008 then the design time settings may get re-applied. Do you need more help on this? Arthur My Blog I am not sure what you mean by this... I just used the wizard and selected the Value option when choosing what should be in the package config table.Mr Shaw
January 31st, 2011 1:21pm

This could be related to how the config settings are designed to be applied. If this is SQL Server 2008 then the design time settings may get re-applied. Do you need more help on this? Arthur My Blog I am not sure what you mean by this... I just used the wizard and selected the Value option when choosing what should be in the package config table.Mr Shaw
Free Windows Admin Tool Kit Click here and download it now
January 31st, 2011 1:21pm

Do you have this value also set BIDS (design time)? Do you run the package now outside BIDS? The way the config settings are applied follows this logic: http://dougbert.com/blogs/dougbert/archive/2009/04/07/understand-how-ssis-package-configurations-are-applied.aspxArthur My Blog
January 31st, 2011 1:25pm

My SSIS package is not reading the values in from the Package Configuration SQL Table. Is there a setting which I need to change or reason why it might not be working? Mr Shaw
Free Windows Admin Tool Kit Click here and download it now
January 31st, 2011 2:39pm

Hello, please go through this document and see if you are missing anything while you configured configuration. http://www.mssqltips.com/tip.asp?tip=1405 ThanksAamir
January 31st, 2011 2:41pm

maybe package connected to another database and another configuration table? did you checked the configuration connection?http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
January 31st, 2011 2:41pm

maybe package connected to another database and another configuration table? did you checked the configuration connection?http://www.rad.pasfu.com
January 31st, 2011 2:41pm

I just placed the package configuration database on a different server and I am still getting the error. Mr Shaw
Free Windows Admin Tool Kit Click here and download it now
January 31st, 2011 2:54pm

I just placed the package configuration database on a different server and I am still getting the error. Mr Shaw
January 31st, 2011 2:54pm

I think it might be the way in which I have deployed the package to the server. What I have deployed the package to the server by using BIDS...File > Save Copy of PackageName.DTSX As... I found the using the manifest file it would deploy all my packages in the project...I only need to deploy one out of five.Mr Shaw
Free Windows Admin Tool Kit Click here and download it now
February 1st, 2011 4:52am

Sorry for my slow understanding!!! Yes... My Design-Time values are being used in Run-Time.. The config-table values are not beign loaded in to variables.Mr Shaw
February 1st, 2011 6:01am

Given you are on SQL Server 2008 I advocate you either supply the correct production values in design mode before you deploy or clear out the variables used to test the package and set them using the /SET switch when running the package.Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
February 1st, 2011 10:59am

I deploy the Package with values in the variable text boxes in BIDS. I always do this, in the run-time the values get overwriten with the values from the config table. U geuss you are going to tell me this is wrong. I did try deploying with no values in the variable text boxes but I got the same results. I don't understand how the doing the same thing in one package can work but in another it does not.Mr Shaw
February 1st, 2011 11:17am

I deploy the Package with values in the variable text boxes in BIDS. I always do this, in the run-time the values get overwriten with the values from the config table. U geuss you are going to tell me this is wrong. I did try deploying with no values in the variable text boxes but I got the same results. I don't understand how the doing the same thing in one package can work but in another it does not.Mr Shaw
Free Windows Admin Tool Kit Click here and download it now
February 1st, 2011 11:17am

How are you telling the package which configuration table to use? Are you using indirect configuraitons? Can you turn on profiler to see when the database is being read? I have a feeling that it is pointing to an alternate database / table. Also, note that configurations are case sensitive.Please mark answered posts. Thanks for your time.
February 1st, 2011 11:26am

How are you telling the package which configuration table to use? Are you using indirect configuraitons? Can you turn on profiler to see when the database is being read? I have a feeling that it is pointing to an alternate database / table. Also, note that configurations are case sensitive.Please mark answered posts. Thanks for your time.
Free Windows Admin Tool Kit Click here and download it now
February 1st, 2011 11:26am

I have run the profile, but I am not sure what I am looking out for. I have re-created the package from scratch and now everything works in BIDS... for example I can changed the email address value in the config table and everything works as expected. However when I put the package on the server it sends to the last email address which was used in BIDS. It is as if the production enviroment is ignoring the config table even though it is on the same server. Mr Shaw
February 1st, 2011 1:26pm

I have run the profile, but I am not sure what I am looking out for. I have re-created the package from scratch and now everything works in BIDS... for example I can changed the email address value in the config table and everything works as expected. However when I put the package on the server it sends to the last email address which was used in BIDS. It is as if the production enviroment is ignoring the config table even though it is on the same server. Mr Shaw
Free Windows Admin Tool Kit Click here and download it now
February 1st, 2011 1:26pm

This is because in SQL Server 2008 the design-time settings get reapplied at the run time as the last step. Put into conf the prod settings then deploy.Arthur My Blog
February 1st, 2011 1:38pm

This is because in SQL Server 2008 the design-time settings get reapplied at the run time as the last step. Put into conf the prod settings then deploy.Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
February 1st, 2011 1:38pm

I have run the profile, but I am not sure what I am looking out for. I have re-created the package from scratch and now everything works in BIDS... for example I can changed the email address value in the config table and everything works as expected. However when I put the package on the server it sends to the last email address which was used in BIDS. It is as if the production enviroment is ignoring the config table even though it is on the same server. Mr Shaw You would be looking to see when the configuration table is accessed. How are you telling the engine where to look for the configuration table? Are you using an indirect configuration to set the connection string to point to the database that houses the configuration table? Are you pointing to it directly? If so, would the connection string be usable from that server? Are you running the package under the same security context? etc... You might try using the search function on the forums as there have been several threads on subjects similar to this one. Also, the following articles might help you understand the concepts behind configurations and how they interact with various settings. B.O.L. Configurations Entry Indirect Configurations Rock! SSIS Configurations, Expressions and ConstraintsPlease mark answered posts. Thanks for your time.
February 1st, 2011 1:41pm

I have run the profile, but I am not sure what I am looking out for. I have re-created the package from scratch and now everything works in BIDS... for example I can changed the email address value in the config table and everything works as expected. However when I put the package on the server it sends to the last email address which was used in BIDS. It is as if the production enviroment is ignoring the config table even though it is on the same server. Mr Shaw You would be looking to see when the configuration table is accessed. How are you telling the engine where to look for the configuration table? Are you using an indirect configuration to set the connection string to point to the database that houses the configuration table? Are you pointing to it directly? If so, would the connection string be usable from that server? Are you running the package under the same security context? etc... You might try using the search function on the forums as there have been several threads on subjects similar to this one. Also, the following articles might help you understand the concepts behind configurations and how they interact with various settings. B.O.L. Configurations Entry Indirect Configurations Rock! SSIS Configurations, Expressions and ConstraintsPlease mark answered posts. Thanks for your time.
Free Windows Admin Tool Kit Click here and download it now
February 1st, 2011 1:41pm

I just used the wizard in BIDS to create the config table.. I am not sure what is meant by indirect configuration? The same connection manager used to access the config table is the same for the data source tables. It is strange that in design-time everything works fine, but when I deploy it the package uses the last variable values used in BIDS?Mr Shaw
February 1st, 2011 6:43pm

I started again and created a new package.. Everything seems to be work now.. Thanks for everybodys help.. As usual I learn a lot.Mr Shaw
Free Windows Admin Tool Kit Click here and download it now
February 2nd, 2011 10:09am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics