No because when I run i have a result, too have I result when I click"Preview" directly in SSIS, but when i execute statement i have error like i wrote.
http://files.engineering.com/getfile.aspx?folder=e830526b-e452-44b5-b82e-1ed9d299ff15&file=SQL__RESULT_PREVIEW.jpg
Hello,
When i click "Preview" on OLE DB Source Editor (SQL QUERY) i see result - all data .
I have error only when i Execute task with query from below ( in oracle i don't have this error , i see correct result).
The error is by converting file formats
(INPUT)
TH.LOCATIONCODE->NVARCHAR2...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.