Avatar of R_M_Ron
R_M_Ron
 asked on

SQL SERVER 2008 Integration Services Data Transformation

I am trying to import Excel data into a sql table using integration services (this is going to be a daily batch job).  The data types in excel are going to change on a conitnual basis though, so in the sql table I just setup the fields to accept text data and wanted to convert whatever is found in excel to a text format so it will post to the sql table without error.

The issue I am encountering is a type conversion issue that says the conversion between types is not supported (this occurs in cases where the excel data is numeric).

I tried using a data conversion and also tried using a derived column transformation step but received similar error messages.  It seems this should be a lot simpler then this so I am likely missing something obvious here?
Microsoft SQL Server 2008

Avatar of undefined
Last Comment
R_M_Ron

8/22/2022 - Mon
R_M_Ron

ASKER
More specifically the error I am getting is "conversion between types DT_R8 adn DT_TEXT is not supported"  when trying to import (my table is using a text type for the target field).  However I also cannot convert the DT_R8 type into a text value before passing it to the Sql Server Destination.
ASKER CERTIFIED SOLUTION
Anthony Perkins

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
R_M_Ron

ASKER
I changed the table to use char(50) then used data conversion from DT_R8 to DT_STR and now it is working great!  Thank you
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck