Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Question-Remove NULL

Author  Topic 

ramdas
Posting Yak Master

181 Posts

Posted - 2009-06-18 : 15:23:29
Hi,
Is there a task within the Data Flow Task which would allow to delete column/row with NULL values. In case source data contains nULL values is it possible to delete them using a Task within Data Flow IN SSIS.

Thank you

Ramdas Narayanan
SQL Server DBA

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-06-18 : 16:18:04
DELETE
FROM Table1
WHERE Col1 IS NULL



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page
   

- Advertisement -