troubleshooting Question

SQL SERVER 2008 Integration Services Data Transformation

Avatar of R_M_Ron
R_M_Ron asked on
Microsoft SQL Server 2008
3 Comments1 Solution429 ViewsLast Modified:
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?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros