Hi Folks,
Today I faced a strange issue.
In the DFT task there is a text file as input file, derived colun and output oledb destination.
When I am adding a new add to new column , I am not getting the datatype. After much research the workaround for this was create a new field for this new column in the data conversion task before the derived column and then make use of this column.
The reason for this failure is that the text file does not contain proper input data field. Enjoy coding ...
Today I faced a strange issue.
In the DFT task there is a text file as input file, derived colun and output oledb destination.
When I am adding a new add to new column , I am not getting the datatype. After much research the workaround for this was create a new field for this new column in the data conversion task before the derived column and then make use of this column.
The reason for this failure is that the text file does not contain proper input data field. Enjoy coding ...
No comments:
Post a Comment