Viewing 10 posts - 1 through 10 (of 10 total)
Hi Koen,
i finally got a solution after 4 hrs. I took the source as emp
took a look up transformation and gave the same emp table as lookup...
April 4, 2012 at 12:56 am
execution 1. initially i am getting all the rows in emp to emp tem.
execution 2: i inserted a new row into emp and executed the package again now only...
April 3, 2012 at 5:24 am
Yes the destination table name is emptem.
I can explain the entire process stepwise.
1.selected a source table emp having empno,ename,mgr,sal,comm.
2.took look up transformation in data flow task and gave emptem...
April 3, 2012 at 4:01 am
Ya there was an implicit conversion taking place.the data types are interchanged in the external output columns.
I modified the entire thing and the execution is done without any errors.
But i...
April 3, 2012 at 3:34 am
i have checked the data types.
empno data type is DT_I4 and ename datatype is DT-STR for the entire data flow.
April 3, 2012 at 3:19 am
I don't have any special characters in data.They are simple names like 'ran','san' and empnos are 1,2,3
How to check the data types in ssis.
i am just checking the ...
April 3, 2012 at 2:52 am
Any idea? i have been debugging for past 1 hr but couldn't get the exact result.
Thanks,
Abhi
April 3, 2012 at 2:23 am
Are both the source and destination SQL Server? -- yes on same sql server
What datatype is used in SSIS? ...
April 3, 2012 at 12:47 am
Ya the datatype in destination is varchar(50) and source is varchar(20). but i changed them and executed the package again it is giving me the errors again.
Error: 0xC0202009 at Data...
April 3, 2012 at 12:28 am
Apart from the above one i have the following errors also
Error: 0xC020901C at Data Flow Task 5, OLE DB Command [177]: There was an error with input column "ename" (193)...
April 3, 2012 at 12:16 am
Viewing 10 posts - 1 through 10 (of 10 total)