 | |
An error occurred while assigning a value to variable
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: An error occurred while assigning a value to variable -
04-07-2008
, 10:17 AM
|
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 |
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
#12
| |||
| |||
|
|
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 |
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
#13
| |||
| |||
|
|
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 |
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
#14
| |||
| |||
|
|
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 |
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
#15
| |||
| |||
|
|
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 |
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
#16
| |||
| |||
|
|
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 |
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
#17
| |||
| |||
|
|
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 |
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
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.