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
edit delete
are you sure?
asked Mark Finch

0 answers

Post an answer but please log in first

Post Answer
  1. Please log in to post answer

Similar Questions

Tagsfor this question

Forumall questions