April 22, 2013 at 2:35 am
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
April 23, 2013 at 9:34 pm
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
April 24, 2013 at 12:58 am
Hi there
My column is currently set up as varchar but will change it to the required field if need be.
Kind regards
Fred:-)
April 24, 2013 at 9:43 am
frdrckmitchell7 (4/24/2013)
Hi thereMy 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
April 24, 2013 at 10:50 pm
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.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply