Teradata Attunity config file for SSIS

[sandeep1188]

I am using the Teradata Attunity driver for SSIS, and it works fine, as long as I put everything in the connector.. However, it doesn't read the config file, do you know if that is possible with this or do I have something specified wrong?? I used SSIS to build the config file.

Sample Config File I am using,

<?xml version="1.0"?><DTSConfiguration><DTSConfiguration Heading><DTSConfigurationFileInfo GeneratedBy="Sandeep" GeneratedFromPackageName="Package1" GeneratedFromPackageID="{AA67A38A-0A1D-47C7-AD95-80FAEE128B6C}" GeneratedDate="10/17/2011 9:37:58 PM"/>
</DTSConfigurationHeading><Configuration ConfiguredType="Property" Path="\Package.Connections[Teradata Connector 2].Properties[ConnectionString]" ValueType="String">
<ConfiguredValue>Data Source=TeradataServer;User ID=Sandeep;Password=Sarah;Persist Security Info=True;</ConfiguredValue></Configuration></DTSConfiguration>

[Gadi.Farhat]

Hi Sandeep,

The Teradata connector works finee with XML configuration file.

Try to specify the "Password" property not as part of the ConnectionString property, in the configuration section.


Regards,

Gadi

[sandeep1188]

Do I also need to specify the Provider in the config , I am new to these connectors , and trying to modify the existing SSIS Package to this , I was using the Provider=TDOLEDB.1 before , do I need something like this also for these connectors.

Any sample XML config file for Attunity will be of great help.

Thanks,

Sandeep

[jcalvert]

Sandeep,
Did you ever get the XML Config file to work with Teradata?
I am having problems with the Password not being kept during DEBUG runs.

Have you got a working sample of the XML config file which you could share?

Many thanks
Jim Calvert