• Phil Parkin (7/6/2009)


    You probably need to use a Script task to assign the text and access the contents of the variable - otherwise you'll just get the literal text in there.

    Hi Phil,

    I tried to create the script task and now i am getting the error

    An OLE DB

    error has occurred. Error code: 0x80040E0C.

    An OLE Database record is available. Source: "Microsoft OLE DB Provider for

    Oracle" Hresult: 0x80040E0C

    Description: "Command text was not set for the command object.".

    please help me

    Regards

    Senthil