July 2, 2014 at 4:36 am
Hi,
I am getting frustrated by a simple issue. I added a new column to a table and then using SSIS to populate data into it.
however, inspite of the fact that the source column has data in it, the destination column is populated with all the NULL values.
It is a simple SSIS package and I have never encountered this issue before.
The package runs successfully without any errors. Also, the preview in OLE DB source shows data in the column.
Could anyone please tell whats causing this issue ?
Thanks.
July 2, 2014 at 4:48 am
Did you map the column in the destination component?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 2, 2014 at 5:01 am
Koen Verbeeck (7/2/2014)
Did you map the column in the destination component?
Yes, the column is mapped in the destination component (screenshot s1). Also, the source column has data in it (screenshot s2).
The column is called OFFICE_TEAM_CD. I am struggling with this for a long time now and it is quite unusual as I have never encountered this issue before.
Thanks.
July 2, 2014 at 6:48 am
What if you put a data viewer between source and destination?
Are you sure you are writing to the correct table?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 2, 2014 at 7:26 am
Some time SSIS acts wiered. For these kind of problems, just deleted the dataflow and recreatea new one. 90% of the time the problem will be solved. If not need to dig more into the XML code of the package.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply