Package Configuration Wizard:-SQL Configurations Configuration Filter Not Working

May 23, 2006

Hi --I was wondering if this is a bug when I add new data in my table SSIS Confiurations and give wizard a new Configuration filter the package configuration wizard can not see the new values --the old values from the previous configuration are still showing---is there any known workaround or forced refresh I can do

thanks in advance Dave

Background:

SQL Package Configurations are most important because they provide the possibility of a central configuration store for your entire enterprise!!!!!!!! and is in my mind the only way to go

http://sqljunkies.com/WebLog/knight_reign/archive/2005/01/24/6843.aspx



Wizard results:

Name:
ETL

Type:
SQL Server

Connection name:
ETLConfiguration

Any existing configuration information for selected configuration filter will be overwritten with new configuration settings.

Configuration table name:
[dbo].[SSIS Configurations]

Configuration filter:
PT_CUST_ABR

Target Property:
Package.Variables[User::gsPreLoad].Properties[Value]
Package.Variables[User::gsPostLoad].Properties[Value]
Package.Variables[User::gsLoad].Properties[Value]
Package.Variables[User::gsFlatFilename].Properties[Value]
Package.Variables[User::gsFileName].Properties[Value]
Package.Variables[User::gsCDOMailTo].Properties[Value]
Package.Variables[User::gsCDOMailSubject].Properties[Value]
Package.Variables[User::giRecordCount].Properties[Value]
Package.Variables[User::giFileSize].Properties[Value]
Package.Variables[User::giBatchID].Properties[Value]
Package.Variables[User::gdFileDateCreated].Properties[Value]
Package.Connections[MyDatabase].Properties[ServerName]
Package.Connections[MyDatabase].Properties[InitialCatalog]





USE [ETLConfiguration]
GO
/****** Object: Table [dbo].[SSIS Configurations] Script Date: 05/23/2006 13:34:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SSIS Configurations](
[ConfigurationFilter] [nvarchar](255) COLLATE Latin1_General_CI_AS NOT NULL,
[ConfiguredValue] [nvarchar](255) COLLATE Latin1_General_CI_AS NULL,
[PackagePath] [nvarchar](255) COLLATE Latin1_General_CI_AS NOT NULL,
[ConfiguredValueType] [nvarchar](20) COLLATE Latin1_General_CI_AS NOT NULL
) ON [PRIMARY]

View 3 Replies


ADVERTISEMENT

SSIS Package Configuration Filter

Jul 24, 2006

We have more than 100 packages which referenced many of the same data sources. In
ideal situation, we would like to create three master filters based on the dev, test, and prod servers and all packages can just reference the same filters. However since one package normally only use a subset of master connections defined in the configuration files, if only those subset of connections are set up in the package, when the
package is first open in BIDS, lots of errors will pop up saying that it could not find the connections defined in the configuration files. Even though this will not cost runtime error, it is still very annoying. Does anyone have better ideas on how to handle this?

View 9 Replies View Related

Package Configuration Wizard Error

Apr 11, 2008

Hi. I've created a number of packages in SSIS which just make temp tables out of views. I did them with the "Optimize for many tables" and "Run in transaction" boxes checked.

Now I'm trying to port them over to another database on another server. I'm first going through the Package Configuration Wizard. When I try to finish the wizard I get a error with the following message:

quote:===================================

Could not complete wizard actions. (Microsoft Visual Studio)

===================================

Could not generate the configuration file. (Microsoft.DataTransformationServices.Wizards)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.DataTransformationServices.Wizards.ConfigurationWizardPages.ConfigurationWizardSR&EvtID=CouldNotGenerateConfigurationFile&LinkId=20476

------------------------------
Program Location:

at Microsoft.DataTransformationServices.Wizards.ConfigurationWizardForm.GenerateXmlConfigurationFile(DesignTimeConfiguration designTimeConfiguration)
at Microsoft.DataTransformationServices.Wizards.ConfigurationWizardForm.OnFinish(CancelEventArgs e)

===================================

Failure exporting configuration file.
(ENRLMNT_UniqueRecords_temp)

------------------------------
Program Location:

at Microsoft.SqlServer.Dts.Runtime.Package.ExportConfigurationFile(String str)
at Microsoft.DataTransformationServices.Wizards.ConfigurationWizardForm.GenerateXmlConfigurationFile(DesignTimeConfiguration designTimeConfiguration)


I don't know how to resolve it. Anyone?

One way to deal with this particular issue would be just to recreate the SSIS package on the other server. The issue with this is I want to be positive which view I'm making a copy of and I'm not currently. Since the Import/Export has the transaction setting checked, I can't seem to determine what the source was. Help?

View 2 Replies View Related

Package Configuration Wizard Error

Aug 9, 2006

I am attempting to create an XML Configuration file and I am recieving the following error once I click finish in the wizard:

Could not complete wizard actions.

Additional Information:
Could not generate the configuration file. (Microsoft.Data.TransformationServices.Wizard)

Technical Details:
===================================

Could not complete wizard actions. (Microsoft Visual Studio)

===================================

Could not generate the configuration file. (Microsoft.DataTransformationServices.Wizards)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.DataTransformationServices.Wizards.ConfigurationWizardPages.ConfigurationWizardSR&EvtID=CouldNotGenerateConfigurationFile&LinkId=20476

------------------------------
Program Location:

at Microsoft.DataTransformationServices.Wizards.ConfigurationWizardForm.GenerateXmlConfigurationFile(DesignTimeConfiguration designTimeConfiguration)
at Microsoft.DataTransformationServices.Wizards.ConfigurationWizardForm.OnFinish(CancelEventArgs e)

===================================

Failure exporting configuration file.
(eFreedomAS)

------------------------------
Program Location:

at Microsoft.SqlServer.Dts.Runtime.Package.ExportConfigurationFile(String str)
at Microsoft.DataTransformationServices.Wizards.ConfigurationWizardForm.GenerateXmlConfigurationFile(DesignTimeConfiguration designTimeConfiguration)


Name:
eFreedomAS2

Type:
Configuration File

New configuration file will be created.

File name:
C:abc.xml

Properties:
Package.Variables[User::SourcePath].Properties[Value]
Package.Variables[User::SourcePath].Properties[Name]
Package.Variables[User::Packages].Properties[Value]
Package.Variables[User::Packages].Properties[Name]
Package.Variables[User::PackageDefNumber].Properties[Value]
Package.Variables[User::PackageDefNumber].Properties[Name]
Package.Variables[User::Directory].Properties[Value]
Package.Variables[User::Directory].Properties[Name]
Package.Variables[User::DestinationPath].Properties[Value]
Package.Variables[User::DestinationPath].Properties[Name]
Package.Connections[ViewHelpTopicDef].Properties[Name]
Package.Connections[ViewHelpTopicDef].Properties[ConnectionString]
Package.Connections[ViewDef].Properties[Name]
Package.Connections[ViewDef].Properties[ConnectionString]
Package.Connections[ValidationTestDef].Properties[Name]
Package.Connections[ValidationTestDef].Properties[ConnectionString]
Package.Connections[ValidationRulePackageDef].Properties[Name]
Package.Connections[ValidationRulePackageDef].Properties[ConnectionString]
Package.Connections[ValidationRuleFileDef].Properties[Name]
Package.Connections[ValidationRuleFileDef].Properties[ConnectionString]
Package.Connections[ValidationRuleDef].Properties[Name]
Package.Connections[ValidationRuleDef].Properties[ConnectionString]
Package.Connections[ValidationMessageFileDef].Properties[Name]
Package.Connections[ValidationMessageFileDef].Properties[ConnectionString]
Package.Connections[ValidationMessageDef].Properties[Name]
Package.Connections[ValidationMessageDef].Properties[ConnectionString]
Package.Connections[ValidationIdentifierDependency].Properties[Name]
Package.Connections[ValidationIdentifierDependency].Properties[ConnectionString]
Package.Connections[ValidationCalcGraphEdge].Properties[Name]
Package.Connections[ValidationCalcGraphEdge].Properties[ConnectionString]
Package.Connections[UserGroupFeatureDef].Properties[Name]
Package.Connections[UserGroupFeatureDef].Properties[ConnectionString]
Package.Connections[UserGroupFeature].Properties[Name]
Package.Connections[UserGroupFeature].Properties[ConnectionString]
Package.Connections[UserGroupDef].Properties[Name]
Package.Connections[UserGroupDef].Properties[ConnectionString]
Package.Connections[UserGroup].Properties[Name]
Package.Connections[UserGroup].Properties[ConnectionString]
Package.Connections[TableDef].Properties[Name]
Package.Connections[TableDef].Properties[ConnectionString]
Package.Connections[Source].Properties[UserName]
Package.Connections[Source].Properties[ServerName]
Package.Connections[Source].Properties[Password]
Package.Connections[Source].Properties[Name]
Package.Connections[Source].Properties[InitialCatalog]
Package.Connections[Source].Properties[ConnectionString]
Package.Connections[SelectListItemDef].Properties[Name]
Package.Connections[SelectListItemDef].Properties[ConnectionString]
Package.Connections[SelectListDef].Properties[Name]
Package.Connections[SelectListDef].Properties[ConnectionString]
Package.Connections[ScriptAssemblyDef].Properties[Name]
Package.Connections[ScriptAssemblyDef].Properties[ConnectionString]
Package.Connections[PrintedPageFormulaScriptDef].Properties[Name]
Package.Connections[PrintedPageFormulaScriptDef].Properties[ConnectionString]
Package.Connections[PageDef].Properties[Name]
Package.Connections[PageDef].Properties[ConnectionString]
Package.Connections[PageCalcPathSubPath].Properties[Name]
Package.Connections[PageCalcPathSubPath].Properties[ConnectionString]
Package.Connections[PageCalcPath].Properties[Name]
Package.Connections[PageCalcPath].Properties[ConnectionString]
Package.Connections[PackageLinkDef].Properties[Name]
Package.Connections[PackageLinkDef].Properties[ConnectionString]
Package.Connections[PackageImportTypeDef].Properties[Name]
Package.Connections[PackageImportTypeDef].Properties[ConnectionString]
Package.Connections[PackageIdentifierGroupDef].Properties[Name]
Package.Connections[PackageIdentifierGroupDef].Properties[ConnectionString]
Package.Connections[PackageIdentifierDef].Properties[Name]
Package.Connections[PackageIdentifierDef].Properties[ConnectionString]
Package.Connections[PackageExportTypeDef].Properties[Name]
Package.Connections[PackageExportTypeDef].Properties[ConnectionString]
Package.Connections[PackageDef].Properties[Name]
Package.Connections[PackageDef].Properties[ConnectionString]
Package.Connections[PackageDataItemTextDef].Properties[Name]
Package.Connections[PackageDataItemTextDef].Properties[ConnectionString]
Package.Connections[OnlinePagePrintedPageDef].Properties[Name]
Package.Connections[OnlinePagePrintedPageDef].Properties[ConnectionString]
Package.Connections[OnlinePageDefDependency].Properties[Name]
Package.Connections[OnlinePageDefDependency].Properties[ConnectionString]
Package.Connections[OnlinePageDef].Properties[Name]
Package.Connections[OnlinePageDef].Properties[ConnectionString]
Package.Connections[MaterialityToleranceDef].Properties[Name]
Package.Connections[MaterialityToleranceDef].Properties[ConnectionString]
Package.Connections[LineDef].Properties[Name]
Package.Connections[LineDef].Properties[ConnectionString]
Package.Connections[ImportTypeDef].Properties[Name]
Package.Connections[ImportTypeDef].Properties[ConnectionString]
Package.Connections[ImportDef].Properties[Name]
Package.Connections[ImportDef].Properties[ConnectionString]
Package.Connections[IdentifierStateDef].Properties[Name]
Package.Connections[IdentifierStateDef].Properties[ConnectionString]
Package.Connections[IdentifierRelatedDef].Properties[Name]
Package.Connections[IdentifierRelatedDef].Properties[ConnectionString]
Package.Connections[IdentifierPrintReferenceDef].Properties[Name]
Package.Connections[IdentifierPrintReferenceDef].Properties[ConnectionString]
Package.Connections[IdentifierGroupUserGroupFeatureDef].Properties[Name]
Package.Connections[IdentifierGroupUserGroupFeatureDef].Properties[ConnectionString]
Package.Connections[IdentifierGroupUserGroupFeature].Properties[Name]
Package.Connections[IdentifierGroupUserGroupFeature].Properties[ConnectionString]
Package.Connections[IdentifierGroupIdentifierDef].Properties[Name]
Package.Connections[IdentifierGroupIdentifierDef].Properties[ConnectionString]
Package.Connections[IdentifierGroupIdentifier].Properties[Name]
Package.Connections[IdentifierGroupIdentifier].Properties[ConnectionString]
Package.Connections[IdentifierGroupDef].Properties[Name]
Package.Connections[IdentifierGroupDef].Properties[ConnectionString]
Package.Connections[IdentifierGroup].Properties[Name]
Package.Connections[IdentifierGroup].Properties[ConnectionString]
Package.Connections[IdentifierDef].Properties[Name]
Package.Connections[IdentifierDef].Properties[ConnectionString]
Package.Connections[IdentifierDataItemTextDef].Properties[Name]
Package.Connections[IdentifierDataItemTextDef].Properties[ConnectionString]
Package.Connections[FormulaScriptDef].Properties[Name]
Package.Connections[FormulaScriptDef].Properties[ConnectionString]
Package.Connections[FormulaDef].Properties[Name]
Package.Connections[FormulaDef].Properties[ConnectionString]
Package.Connections[FeatureGroupFeatureDef].Properties[Name]
Package.Connections[FeatureGroupFeatureDef].Properties[ConnectionString]
Package.Connections[FeatureGroupDef].Properties[Name]
Package.Connections[FeatureGroupDef].Properties[ConnectionString]
Package.Connections[FeatureDef].Properties[Name]
Package.Connections[FeatureDef].Properties[ConnectionString]
Package.Connections[ExportTypeRelatedDef].Properties[Name]
Package.Connections[ExportTypeRelatedDef].Properties[ConnectionString]
Package.Connections[ExportTypeFormulaScriptDef].Properties[Name]
Package.Connections[ExportTypeFormulaScriptDef].Properties[ConnectionString]
Package.Connections[ExportTypeExportDef].Properties[Name]
Package.Connections[ExportTypeExportDef].Properties[ConnectionString]
Package.Connections[ExportTypeDef].Properties[Name]
Package.Connections[ExportTypeDef].Properties[ConnectionString]
Package.Connections[ExportTypeBlobTypeDef].Properties[Name]
Package.Connections[ExportTypeBlobTypeDef].Properties[ConnectionString]
Package.Connections[ExportFormulaScriptDef].Properties[Name]
Package.Connections[ExportFormulaScriptDef].Properties[ConnectionString]
Package.Connections[ExportDef].Properties[Name]
Package.Connections[ExportDef].Properties[ConnectionString]
Package.Connections[ColumnHeaderDef].Properties[Name]
Package.Connections[ColumnHeaderDef].Properties[ConnectionString]
Package.Connections[ColumnDef].Properties[Name]
Package.Connections[ColumnDef].Properties[ConnectionString]
Package.Connections[CellTypeFileTypeDef].Properties[Name]
Package.Connections[CellTypeFileTypeDef].Properties[ConnectionString]
Package.Connections[CellTypeDef].Properties[Name]
Package.Connections[CellTypeDef].Properties[ConnectionString]
Package.Connections[CellRangeDef].Properties[Name]
Package.Connections[CellRangeDef].Properties[ConnectionString]
Package.Connections[CellRangeCellDef].Properties[Name]
Package.Connections[CellRangeCellDef].Properties[ConnectionString]
Package.Connections[CellOverrideDef].Properties[Name]
Package.Connections[CellOverrideDef].Properties[ConnectionString]
Package.Connections[CellDef].Properties[Name]
Package.Connections[CellDef].Properties[ConnectionString]
Package.Connections[CategoryDef].Properties[Name]
Package.Connections[CategoryDef].Properties[ConnectionString]
Package.Connections[CalcPathSubPath].Properties[Name]
Package.Connections[CalcPathSubPath].Properties[ConnectionString]
Package.Connections[CalcPath].Properties[Name]
Package.Connections[CalcPath].Properties[ConnectionString]
Package.Connections[CalcGraphEdge].Properties[Name]
Package.Connections[CalcGraphEdge].Properties[ConnectionString]
Package.Connections[AreaDef].Properties[Name]
Package.Connections[AreaDef].Properties[ConnectionString]

View 4 Replies View Related

Configuration For Configuration Package? Is This Possible?

Mar 6, 2006

Hi Guys,

Here's the current scenario:

I am creating a windows application to manage my ssis packages.

My SSIS packages use package configurations, and by default connect to the "SSIS Configurations" table in sql server.

However, I want it to connect to a view instead of this table, so i create a view "vwSSIS_Configurations" and point the package configuration to use the view in sql server.

The application SHOULD be capable of altering the package configuration's configuration and switch its connection between the default "ssis configurations" table, and the view.

Is this possible? I cannot think of a way which I can have my application switch the package configuration's connection.

Thanks,
kervy

View 3 Replies View Related

SQL Error In Configuration Wizard

Aug 15, 2006

I am having trouble installing and start SQl server on my machine. Currently, I am running Windows XP on my computer with service Pack 2. Not sure why but every time I try to execute the configuration instance , the start services portion does not execute and I get an error 0 message. Please help!!

View 4 Replies View Related

TableAdapter Configuration Wizard Error

Jan 31, 2007

Hi,I always use the following sql statement to check whether an email address exists in a database. With my latest project I tried to do this within the TableAdapter Configuration Wizard and it gave me an error:  IF NOT EXISTS (SELECT Email FROM tblEmailList WHERE Email=@Email) BEGIN INSERT INTO tblEmailList (Email, DateRegistered) VALUES (@Email, @DateReg) SELECT 1 AS RESULT END ELSE BEGIN SELECT 0 AS RESULT END first it gave an error saying I must declare the variables @Email and @DateReg then when I removed the part of insert and just wanted to check the email address existence it gave me this error:The Compound statement SQL construct or statement is not supportedAny idea anyone? 

View 5 Replies View Related

Installation Wizard && XML Configuration File Location

Jan 15, 2008

Hi,

I am using SQL Server configuration indirectly with the connection to it configured in an XML configuration file with the location of the XML file and the connections all being different between development and production. I deploy to the file system using the SSIS Deployment Manifest/Package Installation Wizard.

It seems that sometimes the path to the XML config file is updated in the deployed packages and sometimes it is not.


When the path is updated, all connection strings (as displayed in the Connection Managers section of the Execute Package Utility) are displaying the new values as well.


When it is not, it looks for the XML file in the development location and since it cannot find it all configurations still point to the development connections.


Does anyone know of any conditions when the location of the XML config does not get updated and when it doesn't?

Thanks,
Sven

View 6 Replies View Related

Sharepoint Server 2007 Products And Technologies Configuration Wizard

Nov 22, 2007



Hi,
I tried to install sharepoint server 2007 as a standalone in my computer. When i run the sharepoint products and technologies configuration wizard, i get the following error,

Failed to create sample data.

An exception of type System.Data.Sqlclient.SqlException was thrown. Additional Exception information:
Cannot open database "SharedServices2_DB_28aa01d8************************" requested by the login. The login failed.
Login failed for user "domainAdministrator"

Please advice me to solve this issue.

Thanks,
Magesh S

View 18 Replies View Related

SQL 2005 Express Setup Issue (The SQL Server System Configuration Checker Cannot Be Executed Due To WMI Configuration )

Sep 22, 2007

I am getting following error when trying to install SQL express 2005 on XPSP2.


TITLE: Microsoft SQL Server 2005 Setup
------------------------------

The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine SIGMA-805539A79 Error:2147944122 (0x800706ba).

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=70342


I tied re-installing WMI using http://blogs.msdn.com/jpapiez/archive/2004/12/09/279041.aspx link but could not get it working.


Do i need IIS installed? Its not installed on this box...

please suggest something... i am stuck...

Thanks,

View 3 Replies View Related

SQL Configuration Manager And SQL Server Surface Area Configuration Tools

May 2, 2007

I have just finished installing SQL 2005 Ent Edition on Win 2000 Adv Server, SQL2005 SP2, and SP2 Hotfix KB934458. After the installation, I could see and configure all services via SQL Configuration Manager and SQL Server Surface Area Configuration tools. This worked for a couple of days and now both configuration tools no longer detect SQL2005 components. SQL Server Surface Area Configuration issued an error that said "No SQL Server 2005 components were found on specified computer. Either no components are installed, or you are not an administrator on this computer. (SQLAC)". SQL Configuration Manager did not list any installed services. I don€™t know what caused this. Anyone has any idea? Please help! Below is the Installation Report which shows installed components.

===================================



The following components are installed on this server

DEV

Analysis Services

[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]

Database Engine

[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]

Reporting Services

[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]

QA

Analysis Services

[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]

Database Engine

[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]

Common components

Integration Services

[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]

Notification Services

[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]

Workstation Components

[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]

===================================

View 1 Replies View Related

Help Sending A Variable From A C# Program To A SQL Query Using The Configuration Wizard In Visual Studio 2008

Apr 29, 2008

I am trying to send a variable selected by the user and have all of the results that match that selection show in a datagridview. I tried using this query but it gives me not result.
//code
SELECT wasteDate, wasteFeed, wasteLbs
FROM tbWaste
WHERE (wasteDate = 'date1')
//code
date1 is being set by a datetimepicker
I am getting no results when I run the program
I have tried out every different combination of ways of coding it i can think of
if anyone can help it would be greatly appriciated.

View 1 Replies View Related

Configuration Manager - Which Configuration Type To Chose ?

Jan 14, 2006

It seems to me, that the best way is to have one Environment Varible containing the name of the SQL Server, so that you can look up the configuration in the SSIS Configuration Table when you run the package.

Is this the preferable way of doing it ? I would like to hear some positive/negative comment of why chosing a configuration type instead of another.

It seems to me that putting all of the configuration in the Environment variable is harder work but most secure (server breakdown vs table corruption/database error...)

Let's have some comments

View 3 Replies View Related

Passing The Xml Configuration File To The Package As An Input Parameter While Executing The Package

Feb 2, 2007

Hi,

I am planning to develop a single package that will download files from ftp server, move the files to internal file server and upload it in the database. But I want to run this package for multiple ftp file providers. For each provider the ftp server might be different and the transformation to upload the files into a database table might be different.

So can I create a single package and then multiple configuration files (xml), which will contain the details fo the ftp file providers and then pass the xml file as a parameter while executing the package. The reason being that the timings of fetching the files is different for each ftp file provider and hence cannot be combined into one.

Is this possible?

Thanks for your help.

$wapnil

View 6 Replies View Related

Report With SSIS Package Having Indirect Package Configuration Setup

Sep 10, 2007

Deployed Report having SSIS package as source do not work when Indirect Package configuration is used in ETL package. It seems ETL package when called/executed from Report manager does not recognize environment variable to pick up the dtsconfig file.

The Report works when Direct package configuration is used to same dtsconfig file.

What could be the reason? Any solution for this? This will cause our build/deployment to QA and Prod very difficult.

View 1 Replies View Related

Configure A Child Package To Use The Configuration File Of A Parent Package?

Sep 14, 2006

Hi guys,

Here's the deal. I have a child package, (say, pack01.dtsx), which uses a dtsconfig file for its connection string, which can be called from other packages, but which also can be called by itself.

However I also have another package (say, pack02.dtsx) which uses the same dtsconfig file for its connection string. It calls on pack01.dtsx.

When I use DTEXECUI and run pack01.dtsx, specifying the proper .dtsconfig file, it goes well. But when I try and run pack02.dtsx, an error occurs saying pack01.dtsx connection cannot be established.

How do I pass the connectionstring being used by pack02 to pack01, without having to remove the configuration file setting of pack01? Can a Parent Package configuration and a configuration file try and map to the same property?

Hope someone could help. Thanks.

View 7 Replies View Related

How It Is Working Using SQL Server Configuration Type To Store Connection Strings

Dec 12, 2007

Hello,
I am wondering how it is going to work using SQL Server configuration type to store connection string in the SQL Server table. How does SSIS know what database to connect to if its connection string is store in the database? Thanks

View 5 Replies View Related

Configuration Package

Aug 8, 2007

I have created a package configuration to read the connectionstring for the oledb connection manager.

Saved the file as Environment.dtsConfig in the same directory as the other packages.

Do the packages refer to the configuration file automatically?

Does it make a difference if I use the dtexec to start the ssis packages since there is now a configuration file?



Thanks

View 4 Replies View Related

Package Configuration Please Help

Mar 29, 2007



I would like to set package configuration.But dont know how to.

What i want to achieve is that i want to change connections based on test ,development and production environment of the same package...



How can i do that without me changing the connections manually to each task based on environment..

using package configuration i dont know how to...Please let me know.

View 17 Replies View Related

Package Configuration

Apr 5, 2006

Hello,

I'm developing some packages in SSIS and I need to implement a configuration file to load the server's connections and other parameters, so I can use this same connection for all packages.

Have anyone a step by step to perform this configuration ?

I exported a Connection Manager to a .dtsConfig file, but I don't know how to use this config file.

Any help is welcome !

Thanks,

Guber

View 1 Replies View Related

Package Configuration

Oct 3, 2006

Here is the scenario we are
trying to use; (it a bit long winded please bare with me)



There are 2 Packages Parent
and Child. Both have 2 Connection Managers (€śConfiguration€? & €śData Connection€?).
The €śData Connection€? has an invalid connection set to start with this is so
that we can deploy this to multiple places and use a SQL table to hold the
configuration.




At runtime €śConfiguration€? is
set to a valid SQL2005 database connection via the command line or in BI but €śData
Connection€? is left invalid.




The Package Configuration point
to an SQL server using €śConfiguration€? this has the connection string for the €śData
Connection€? Connection Manager (a valid connection string). The package errors
with can not acquire connection.




The first task is to put the
Connection string of the Connection manager €śConfiguration€? in to a variable.
Then the child package is called.




The Child package has the same
2 connections €śConfiguration€? & €śData Connection€? both are Invalid at this
time.




1) We use the Package
Configuration to populate a variable from the parent package which holds the €śConfiguration€?
connection string.

2) We use a Package
Configuration to populate then Configuration€? connection from the parent
package which holds the €śConfiguration€? connection.

3) We use a Package
Configuration to populate the €śData Connection€? Connection Manager using the €śConfiguration€?
connection. Which should be Set via step 2 here.




The First task on the child
package has a bit of script to check all the connection manager return a valid
connection to make sure database are up and running before connection. This
fails at the moment return in an error.




We want to use the same code
in multiple environments and as such don€™t want to make code changes that are really
only environment changes.

IE connection string to
servers. I can€™t seem to see anything saying we are doping anything wrong but if
the connections are all set to a valid connection before running this seems to
work. When invalid connection are used this seems to fall over.

View 1 Replies View Related

Package Configuration

Aug 8, 2007

I have created a package configuration to read the connectionstring for the oledb connection manager.
Saved the file as Environment.dtsConfig in the same directory as the other packages.
Do the packages refer to the configuration file automatically?
Does it make a difference if I use the dtexec to start the ssis packages since there is now a configuration file?

Thanks

View 1 Replies View Related

Package Configuration

Aug 10, 2007



Does it matter if the configuration is by xml,sql server,parent package variable,environment variable etc.

I use xml configuration which i kind of feel easy as i can change the connection directly by typing.Not used with others much..

Is there any security issue here .
Please let me know

View 5 Replies View Related

Package Configuration With XML

Sep 14, 2006

Hi,

i am haveing package which is devloped in BIDS and i am executing the package from DotNet (Windows Application C#).during development my package is pointed to Server1,Database1.when we move the package to another test environment for a different server and database (Server2,Database2). we are giving the connection string details in dtsConfig file .but  Package is not takeing the new connection string instead its takeing the old connection string (design time connection) and throwing error.what could be the problem

Invoking Code (C#)

--------------------

            btn_SaExecute.Enabled = false;
            string pkgLocation;
            Package pkg;
            Microsoft.SqlServer.Dts.Runtime.Application app;
            DTSExecResult pkgResults;

            pkgLocation = "D:JeganSSIS PrjsInvokeTestInvokeTestData1.dtsx";   

            app = new Microsoft.SqlServer.Dts.Runtime.Application();

            pkg = app.LoadPackage(pkgLocation, null);
            pkg.EnableConfigurations = true;
            pkgResults = pkg.Execute();


Data.dtsConfig

----------------------

<?xml version="1.0"?><DTSConfiguration><DTSConfigurationHeading>
 <DTSConfigurationFileInfo GeneratedBy="PSLSDCJegan.thangadurai" GeneratedFromPackageName="Data1" GeneratedFromPackageID="{30ACE86F-D0D3-4575-AD46-2E9C2F34D46B}" GeneratedDate="9/14/2006 12:54:01 PM"/>
</DTSConfigurationHeading>
 <Configuration ConfiguredType="Property" Path="Package.Connections[XXXX.YYYY].Properties[ConnectionString]" ValueType="String">
 <ConfiguredValue>Data Source=XXX;User ID=XXX;Password=XXX;Provider=MSDAORA.1;Persist Security Info=True;
 </ConfiguredValue>
 </Configuration>
</DTSConfiguration>

Thanks

Jegan

View 1 Replies View Related

SQL Configuration Package - C# App

Sep 1, 2006

Hi all,

Hopefully a simple question. In my c# application i can call ImportConfigurationFile(<str>) to import an xml configuration file. How do i go about importing configuration settings from a SQL configuration package? I have created this but see no way to load it. I'd prefer to use the config file created in the SQL database.

Any help would be most appreciated.

Many thanks,

Grant

View 1 Replies View Related

Package Configuration

Oct 17, 2006

Hi all of us,

I'm looking any .dtsconfig file as sample for my first package configuration. I've got ssis packages which might be updated on development and then moved to production. First of all, I'd like dynamically change the connections but I don't know exactly how to do that. I'm taking a look on the wizard but when I choose a Sql Server request me a table.

Any sample or link for that would be welcomed!

TIA

View 2 Replies View Related

Package Configuration - XML

Aug 25, 2006

Type:
 Configuration File

New configuration file will be created.

File name:
 C:Test.dtsconfig

Properties:
 Package.Connections[Flat File Connection Manager].Properties[ConnectionString]


 

------------------------------------

 

So lets say, I modify the connectionstring for the Flat File connection manager by editing the xml file. Next time, I run the package, it does not grab the new value. Am I misunderstanding the concept  of Package Configuration?

View 3 Replies View Related

Package Configuration

Mar 14, 2007

Hi All,

I have couple of properties in my package Configuration

(1) Lets me know the Folder path - where I have file processing

(2) Connection String

When working in the Development machine, I am able to play around these values and test the application. I have tried both XML Configuration and SQL Server Configuration

But during deployment in the Test Server, the values in the Configuration are not getting reflected automatically and takes the values assigned during deployment

I tried importing the XML file and it works. But the values are not persistant.After running the package, the value gets resetted to the old value. Every time I run my package, I am reassingning my package variables.

Be it XML Configuration File or SQL Server, I would like to have the variables pulled out from the Configuration I am setting during the deployment. the values should be persistant and should refer the updated values.

Any help will be highly appreciated...thanks





View 10 Replies View Related

Package Configuration Are Ignored

Dec 7, 2006

hi everyone

I am putting my connection string in package configuration file, which i create through package configuration option.

But connection is not picking up value where as other varibles are picking up values from same file.

Is there is any other setting that we have to set for connection string.

Thanks and regards

Rahul Kumar

View 3 Replies View Related

SSIS Package Configuration

Apr 12, 2007

Hi, I'm facing a problem that I'm trying to solve. I report it in the following hoping somone can help me!



the context:

- I have a solution containing almost 20 packages
- I have a main package containing the sequences (Sequence Container) calling all others packages (Execute Package Task)
- every package has the connections to its own DBsource ; so the package X has the its own connections to DBsourceA and DBsourceB, the package Y has the its own connections to DBsourceB, DBsourceC, DBsourceD and the destination DB is unique for all the packages.



My problem is:
I have the necessity to define in the best way a config (one for all the dtsx, possibly) that allow me to manage easily the switch from the developing env to the deployment env, basically for the DB connections.



Which is the best way to do this and can anyone tell me the steps to follow?

View 8 Replies View Related

Package Configuration Not Used After Deployment?

Mar 6, 2006

I've been searching for an answer to my question quite some time now and I've not been able to figure it out yet.

Situation:
- I've created a SSIS package containing a bulk insert task.
- I've added a package configuration containing the appropriate connection manager (i.e. dev, beta or live)
- CreateDeploymentUtility = true
- I've copied the deployment folder to our beta server and I started the manifest file to install the package to the sql 2005 server, after that I specified the config file location and changed the value so the approriate connection manager is used.
- When I execute the package from the sql server the package doesn't read the value from the xml config file, it uses the connection which was originally specified in the package, whereas when I run the package from my BIDS it is reading the value from the xml config file?

I can't seem to figure out why this is happening? am I missing something here?

Thnx.

View 1 Replies View Related

SSIS Package Configuration.

Jan 3, 2007

I'm facing a little problem concerning package configuration that is using a SQL table.

I have 4 exactly the same Db's on the same SQL server, each with another name of course (Dbipa, DbIpB, DbIpC & DbIpD).

My developers created 4 exactly the same SSIS packages with 4 exactly the same jobs, each for his own DB only the connection settings are different.

Now I was trying to manage this with only one SSIS package by using an SSIS Package configuration table in each DB.

I thought it would be possible to start the package with the following parameter


/SET Package.Connections[SQL].InitialCatalog;DBIPA OR

/SET Package.Connections[SQL].InitialCatalog;DBIPB OR

/SET Package.Connections[SQL].InitialCatalog;DBIPC OR

/SET Package.Connections[SQL].InitialCatalog;DBIPD
But this doesn't work because before he changes the initial catalog in the connection named SQL, he already did the loading of the SSIS_Configuration table. So he point always to the same config table.
Is there a way to change the connection before the package configuration is being executed.
Ludo Bernaerts

View 1 Replies View Related

SSIS Package XML Configuration

Nov 9, 2006

1) We are doing data migration from SQL Server 2000 OLTP design to SQL Server 2005 OLAP design.

2) We have used SSIS packages and data flow tasks in which we mentioned connection strings for source and target containers.

3) We have a master execute package which contains series of execute packages in relational order.

4) When we execute this master package, we should be able to dynamically specify different source and connection strings for all packages.

5) In master execute package, we generate an XML configuration file using SSIS -> Package Configurations... using Connection Managers -> Particular connection

6) Now, we change connection string to point to another database after adding this new OLE DB connection in Connection Manager of each and every package.

7) When we save, build and execute master package it is still executing migration packages against the old database. Please let me know what I am missing.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved