"SQL Learner" <sqllearner@hotmail.com> wrote in message
news:1173824604.603427.264750@n76g2000hsh.googlegroups.com:

> On Mar 13, 5:11 pm, "Allan Mitchell" <a...@no-spam.sqldts.com> wrote:
> > Ok I think you jumped a few steps.
> >
> > Did you actually create the table in the SQL Server database that will
> > hold the configuration info. You need to do that before "Indirect"ly
> > pointing a configuration somewhere.
> >
> > --
> >
> > Allan Mitchellhttp://wiki.sqlis.com|http://www.sqlis.com|http://www.sqldts.com|http://www.konesans.com
> >
> > "SQL Learner" <sqllear...@hotmail.com> wrote in message
> >
> > news:1173821944.453527.188820@o5g2000hsb.googlegroups.com:
> >
> >
> >
> > > Using SSIS, I want to store my configuration in a database table.
> > > I opened Package Configuration Wizard, and selected
> > > Configuration Type: SQL Server,
> > > Configuration location is stored in an environment variable.
> >
> > > Next I created an environment variable SSIS1_CONFIG
> >
> > > For integrated security, server MyServer, database ConfigDB, schema
> > > dbo, and table SSIS1_Config, what should be the value in that
> > > environment variable?
> >
> > > TIA- Hide quoted text -
> >
> > - Show quoted text -
>
>
> Allan,
>
> yes I created the following:
>
> CREATE TABLE [dbo].[SSIS1_Config]
> (
> ConfigurationFilter NVARCHAR(255) NOT NULL,
> ConfiguredValue NVARCHAR(255) NULL,
> PackagePath NVARCHAR(255) NOT NULL,
> ConfiguredValueType NVARCHAR(20) NOT NULL
> )