mixed data columns

Question

mixed data columns

frdrckmitchell7

Ten Centuries

Points: 1351
More actions
April 22, 2013 at 2:35 am

#394644

I currently have a column that have both numeric and characters:
Example: 3
PF
11
PF
PF
3
3
I am trying to pull the data like this into ssis and send it to a sql table.
What I get are NULLS when I do DT_NUMERIC and DT_STR will not pull it in either. Did anyone had this problem and came up with an answer?
Kind regards
Fred

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Calibear Ten Centuries Points: 1377 More actions · Answer 1

What are the settings for the column in the table you are trying to pull this data into?

--------
For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
You can also follow my twitter account to get daily updates: @BLantz2455

frdrckmitchell7 Ten Centuries Points: 1351 More actions · Answer 2

Hi there

My column is currently set up as varchar but will change it to the required field if need be.

Kind regards

Fred:-)

Calibear Ten Centuries Points: 1377 More actions · Answer 3

frdrckmitchell7 (4/24/2013)
Hi there
My column is currently set up as varchar but will change it to the required field if need be.
Kind regards
Fred:-)

Have you changed the data type in the table and if so, from what?

--------
For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
You can also follow my twitter account to get daily updates: @BLantz2455

pietlinden SSC Guru Points: 63541 More actions · Answer 4

Why not split the two types out inside SSIS:

select someData, ISNUMERIC(someData) As NumTest

from test

WHERE ISNUMERIC(someData)=1;

The example is kind of overdone, but the idea is that you can test/filter for whether the column contains numeric data, and route that data inside your dataflow... and just send the non-numeric data into a different one.

mixed data columns

Cookies on SQLServerCentral