sql server - Script Component - ODBC exception password incorrect - package validation -
i'm trying insert rows filemaker using script component. followed article creating odbc destination script component
when edit script here set connection string:
public override void acquireconnections(object transaction) { string connectionstring; //connectionstring = this.connections.fmconnection.connectionstring; odbcconn = new odbcconnection("uid=someuid;dsn=fm;pwd=somepassword"); odbcconn.open(); }
i connection string this.connections object , set new odbcconnection object. not work keep getting exception. tried setting connection string manually can see above. still exception.
in other parts of package use connection manager filemaker , works. not in script component.
the exceptions i'm getting is:
error @ mypackagename: [filemaker] password incorrect
what wrong?
Comments
Post a Comment