P
Prathiba
Hi,
I have written DTS Transformation code for transforming
records from xl sheet to sql server. (since we have to do
some validations before transforming I have written the
code instead of using the default 'Import data'). When I
give the xl sheet as the source and if I see in Preview
some values present in the xl sheet doesnot appear. For
example. In a column if I have some set of 8 rows as blank
and in the same column after the 8th row if i have some
value in the xl sheet then that is not shown in the source
preview. But If I just embed a single quote(') before the
value in the xl sheet it is displayed in the source
preview. Another problem i faced is in a column if some
set of rows have pure chararacters(ex:werwer) and some set
of rows have numbers, then in the source preview i am able
to see the values which are pure numbers and the remaining
rows in the same column that has pure characters are
displayed blank. Again If I just embed with a ' it is
getting displayed.
What is the reason for it and can you provide a fix other
than giving a ' in the data file?
I have written DTS Transformation code for transforming
records from xl sheet to sql server. (since we have to do
some validations before transforming I have written the
code instead of using the default 'Import data'). When I
give the xl sheet as the source and if I see in Preview
some values present in the xl sheet doesnot appear. For
example. In a column if I have some set of 8 rows as blank
and in the same column after the 8th row if i have some
value in the xl sheet then that is not shown in the source
preview. But If I just embed a single quote(') before the
value in the xl sheet it is displayed in the source
preview. Another problem i faced is in a column if some
set of rows have pure chararacters(ex:werwer) and some set
of rows have numbers, then in the source preview i am able
to see the values which are pure numbers and the remaining
rows in the same column that has pure characters are
displayed blank. Again If I just embed with a ' it is
getting displayed.
What is the reason for it and can you provide a fix other
than giving a ' in the data file?