August 13, 2007 at 6:05 am
Hi pals,
I am using a Data flow task in my SSIS package.
In source OLEDB connection i have chosen OLE DB PROVIDER For SQL SERVER.
similarly i have chosen the OLE DB for Sql Server as Destination connection.
Now i connected the workflow arrow from source to target connection.
In source connection i am using a SQL command as source, in which one of the column
i.e district_code which has the datatype as varchar(20) but the actual data is of length 4 characters.
And when i am mapping from source connection to the target connection, the target column datatype is char(4),
and it showing a warning icon in the destination connection.To eliminate the warning i tried to extract only the 4 characted substring
from sourceqry, even then still warning msg still exists.
Then, i double clicked the worklow arrow, selected "Metadata" page and checked the column's i.e
district code datatype and length it still remains as 14 and i found that could be the reason for
the warning message.Eventhough the substring function is used in the source query, still the length remains same
as 14 and since target table can hold only 1st 4 characters, i am still getting warning icon on the destination connection.
How to deal with such kind of problems.
Any suggestions on this will be appreciated.
Thanks in Advance,
franky
August 13, 2007 at 9:00 am
Right click your OleDb Source Select advanced editor. Got to tab Input and output Propeties, You will see external column and output column Any difference in these two coulumn sizes could result in truncation, Do the same for the destination just note you cannot change the external as it is set in the output from the source.
August 13, 2007 at 11:44 pm
Thank you Mike.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply