ssis

Question

ssis

asranantha

SSCarpal Tunnel

Points: 4246
More actions
May 6, 2012 at 10:43 pm

#273583

Hi friends i have smll doubt in ssis
when ever comes source data that data contains some null values how to avoid that null values whil loading destination table.which expression to write in ssis
sourece data comes like id,name
1,ad
2,k
null,dd
5,fe
6,null
null,ed
44,do
null,dd

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

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

sunnyepgc Mr or Mrs. 500 Points: 546 More actions · Answer 1

If your source is Table you can write Sql query to filter the null records using oledb source query.If it is a flat file or excel source then you can use conditional split transformation to filter null records..

Smash125 Hall of Fame Points: 3562 More actions · Answer 2

There are lot of ways to do it.Please explore by your self or Google it:-)

Charmer SSChampion Points: 14903 More actions · Answer 3

you can use Conditional split transformation...

Thanks,
Charmer

asranantha SSCarpal Tunnel Points: 4246 More actions · Answer 4

The query failed to parse. Syntax error, permission violation, or other nonspecific error

Charmer SSChampion Points: 14903 More actions · Answer 5

asranantha (5/9/2012)
The query failed to parse. Syntax error, permission violation, or other nonspecific error

Brief the error...i mean post the exact error as like as it looks...

where do you get the error? in which transformation?

Thanks,
Charmer