Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Passing Parameters through EVMODIFY and SSIS SQL Command

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
Not what you were looking for? View more on this topic or Ask a question