Upload Data from excel to sql server thru DTS

  • Thread starter Thread starter Prathiba
  • Start date Start date
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?
 
Have you set the data types in your column mappings?
I have a feeling it looks in the first 15 rows or
something to decide the data type. You should be able to
override that within your transformation though.

cheers
Simon
 
Back
Top