Hi all,

I am new to SQL-Server and Integration Services, so I hope it is a
simple question for you.

Here is what I do...
I have a .csv-file and create a Flat File Source. I want to get the
data into a SQL Server Destination and create a new table with the
proposed SQL-Statement. Now I have an Error with a data type conversion
in the Data Flow Task [4832]... the conversion between DT_I1 and DT_I2
is not supported.

What csn I do to solve this?

Thanks in advance
Daniel

Look to use a Data Conversion transform. Datatypes are not as easily
mangled together in SSIS. A lot of the perf in SSIS is because when you
tell the pipeline something is a give DT then it optimises for that
scenario. You go changing stuff or passing in thuff that is not in keeping
with that definition then it will tell you. DTS used to massage things for
you



--


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com


<danielsanberger (AT) googlemail (DOT) com> wrote