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?