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 2005 Forums
 SSIS and Import/Export (2005)
 Null Value

Author  Topic 

jscot
Posting Yak Master

106 Posts

Posted - 2010-11-01 : 23:17:37
I have one question:-

I have source (Excel File) and Few Transformation and then OLE DB "DESTINATION", i am transferring more than 60k rows. My question is there is one column in source table filed "S_ID". I want if 'S_ID" is NULL i don't want that value Mean if "S_ID" is NULL don't transfer from Source ---> Destination. I am doing this project through SSIS. ANY ADVICE PLEASE?

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2010-11-02 : 10:29:23
You should use a conditional split in the data flow: http://msdn.microsoft.com/en-us/library/ms137886.aspx

- Lumbago

My blog (yes, I have a blog now! just not that much content yet)
-> www.thefirstsql.com
Go to Top of Page
   

- Advertisement -