July 20, 2011 at 2:14 am
[font="Tahoma"]
Hello Friends,
I am new to SSIS. I am trying to create an extract by joining few tables. I just wanto to know if we should convert the column values to either char or varchar before extracting. Will there be any additional work that we have to do in case we are not converting the column values to char or varchar in Source
[/font]
July 20, 2011 at 7:27 am
MuraliKrishnan1980 (7/20/2011)
[font="Tahoma"]I am new to SSIS. I am trying to create an extract by joining few tables. I just wanto to know if we should convert the column values to either char or varchar before extracting. Will there be any additional work that we have to do in case we are not converting the column values to char or varchar in Source
[/font]
What data types are you talking about converting? Numbers? Date/Time?
I can't think of a good reason to CAST these columns unless perhaps you're trying to create a fixed length string record for your output.
July 20, 2011 at 8:05 am
Hello,
I was wondering if converting the column values before extracting would be useful and i got the answer from one of my colleagues. Thanks for your response.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply