DTEXEC override Teradata Connection

I am executing SSIS packages that override the Connection string by submitting new connection parms from batch execution of the package using dtexec.
This works for Oracle connections but now we need to implement Teradata Connections and I can not find an example of the override sample.

My command line for Oracle is:
dtexec /FILE "e:\XXXSSIS\XXX_Data_Import_v2\XXXImport_v2.dtsx" /CONNECTION DestinationConnectionOLEDB;""Data Source=INSTANCE\dev1;Initial Catalog=TARGETDB;Provider=SQLNCLI10.1;Integrated Security=SSPI;Auto Translate=false;"" /CONNECTION OracleADO.net.XXXXB11P;""Data Source="(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST= XX0101-VIP.SourceData.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=XXXXB11P)))";User ID=SERVICE1;Persist Security Info=True;Unicode=True;PASSWORD=xcxcxcxc;"" /DECRYPT password /CHECKPOINTING OFF /REPORTING EWCDI

Where can I find samples for the Teradata connection overide?

0 answers