Passing Parameters through EVMODIFY and SSIS SQL Command

[Former Member]

Hi all,

I am trying to pass the parameters using EVMODIFY dynamic script and SSIS SQL Command(OLE DB Source task). I did coding, the dynamic script and configured SQL Command task in SSIS to pass parameters to Oracle database.When i ran the package from data manager following is the error that i got.

Error Message:

ErrorCode = -1071636471

Source = xxxxxxxx

SubComponent= OLE DB Source 1 [196]

Description = SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occured. Error code: 0X80040E10.

IDOflnterfaceWithError= {8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}

ErrorCode = -1073450982

Source = xxxxxxxx

SubComponent= DTS.Pipeline

Description = component "OLE DB Source 1" (196) failed the pre-executed phase and returned error code 0xC0202009.

IDOflnterfaceWithError= {8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}

I appreciate, if any body let me know what is the issue here and solution.

Regards,

Sreekanth.

[Former Member]

What does your MODIFYSCRIPT look like?

[Former Member]

Hi Sara,

I resolved my issue.

Thanks for the reply.

Regards,

Sreekanth.