Hi,

I'm getting following error while running SSIS package:

[Execute SQL Task] Error: An error occurred while assigning a value to
variable "variable_name": Multiple-step OLE DB operation generated
errors. Check each OLE DB status value, if available. No work was
done.

My package works fine on my laptop, but it fails on server, so I
belive it may be security issue.

please advise,

cheers,
Lukasz

Hi Lukasz,

Are you getting any indication of what errors are being generated by
the OLE DB operation? This might help to debug the problem.

Good luck!
J

Hi Lukasz,

Are you getting any indication of what errors are being generated by
the OLE DB operation? This might help to debug the problem.

Good luck!
J

Hi Lukasz,

Are you getting any indication of what errors are being generated by
the OLE DB operation? This might help to debug the problem.

Good luck!
J

Hi Lukasz,

Are you getting any indication of what errors are being generated by
the OLE DB operation? This might help to debug the problem.

Good luck!
J

Hi Lukasz,

Are you getting any indication of what errors are being generated by
the OLE DB operation? This might help to debug the problem.

Good luck!
J

Hi Lukasz,

Are you getting any indication of what errors are being generated by
the OLE DB operation? This might help to debug the problem.

Good luck!
J

Hi Lukasz,

Are you getting any indication of what errors are being generated by
the OLE DB operation? This might help to debug the problem.

Good luck!
J

Hi Lukasz,

Are you getting any indication of what errors are being generated by
the OLE DB operation? This might help to debug the problem.

Good luck!
J

On Apr 7, 2:11*pm, jhofm... (AT) googlemail (DOT) com wrote:
Hi J,

I could not find this indication, but fortunatelly I found the
solution. It seems that passing value from sql query to SSIS variable
needed some extra type conversion (binary => varchar) - however on my
laptop (xp pro) conversion was not needed, whereas on server (WS2003)
it was.

best regards,
LG