pckg config.

Hi,

I have configure our ssis project that will take the connection string from the database

but when i change the connection string so the pckg will take the data from another server with exact tables name it fails.

what do you think the problem is ?

I think the problem is a mistake in the changed connection string or the preparation of the additional server. Perhaps if you gave us the full error message you get, we can make an informed guess?

Can you also be clear about which connection string has changed, one contained within the configuration store, or the connection that points to the SQL Server holding the configuration table?

|||

Hi,

this is the error i get

Message
Executed as user: FLYING-CARGO\dwhadmin. ...0.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 12:48:14 Error: 2007-07-10 12:48:16.00 Code: 0xC0202009 Source: Load AirPort_City_Codes airport_city_codes [31] Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "Statement(s) could not be prepared.". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "Invalid object name 'export_db_drp.dbo.airport_city_codes'.". End Error Error: 2007-07-10 12:48:16.02 Code: 0xC004706B Source: Load AirPort_City_Codes DTS.Pipeline Description: "component "airport_city_codes" (31)" failed validation and returned validation status "VS_ISBROKEN". End Error Error: 2007-07-10 12:48:16.02 Code: 0xC00470... The package execution fa... The step failed.

what i've changed is the connection string of my erp db.

|||

what i've changed is the connection string of my erp db which store in my configuration table.

10x.

|||10x i've fix it.|||Could you post the resolution?|||

Hi steam5,

Description: "Invalid object name 'export_db_drp.dbo.airport_city_codes'." draws my attention. If you are executing a query, check if that runs successfully on the SSMS Query Editor after connecting to the ServerName you have changed. If succeeded, use the OLEDB source preview to look for top few rows.

Thanks

Subhash Subramanyam

sql

Password in config file

Hi

Config files doesn't seem to work for me :( i want to make a common config file for all of my packages but it is giving me error

Validation error. The AcquireConnection method call to the connection manager failed with error code 0xC0202009

I have placed pasword in my config file too. Following is config file which i m using, server name n password are masked.

<?xml version="1.0"?>
<DTSConfiguration>
<DTSConfigurationHeading>
<DTSConfigurationFileInfo GeneratedBy="SSBKD\955688" GeneratedFromPackageName="DTS_ACPM_MarkIT_Indices_Composites_TRAC_X_Asia_Index" GeneratedFromPackageID="{CB3660A1-5E6C-4D08-A7F5-4D6CE83578E2}" GeneratedDate="2006/10/19 14:05:20"/>
</DTSConfigurationHeading>
<Configuration ConfiguredType="Property" Path="\Package.Connections[ssmgn838.ACPM.acpmuser].Properties[ConnectionString]" ValueType="String">
<ConfiguredValue>server=########;user id=sa;password=******;database=ACPM;
</ConfiguredValue>
</Configuration>
<Configuration ConfiguredType="Property" Path="\Package.Connections[Text File (Source)].Properties[ConnectionString]" ValueType="String">
<ConfiguredValue>C:\acpm\filetoupload\Copy of ACPM_MarkIT_Indices_Constituents_Composites_1_ITRAXX_ASIA.tab
</ConfiguredValue>
</Configuration>
</DTSConfiguration>

If you take the ConnectionString from the configuration file and use it does the AcquiredConnection works?

The failure happens when you using DTExec or from designer?

Thanks,
Ovidiu

|||

problem came in AcquiredConnection

DTexec throws this error

even in designer it doesnt't identify password, i have to give it manually in my connection object.

|||

Can you tell me what type of connection is this? Oledb ADO.net?

Also can you check what is the value for the Package property ProtectionLevel?

Thanks,
Ovidiu