July 22, 2009 at 10:20 am
My SSIS pkg LOADS all rows from an Excel sheet into a table. I need to modify Pkg to "exclude" all Excel rows where ProductID is null.
Should I be using the Conditional Split task?
If so, on the Conditional Split Transformation Editor, EXACTLY what should I enter into the "Condition" column? (my Excel column is called ProductID)
thx in advance.
July 23, 2009 at 8:33 am
Yes, the Conditional Split is what should be using.
Try ISNULL(ProductID) == FALSE to select the rows you want.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 21, 2009 at 2:23 am
Hi all
im also eperiencing the same proble.i have designed the SSIS Package and i want to filter tha rows where there's are NULLS.I Have tried using Conditional split but i cant get the right formula to use in conditiona split .please Advice.
TIA
September 22, 2009 at 6:16 am
Hi
After having a lot of problems with SSIS and Excel I decided to skip SSIS in this
case. I save the Excelfile as a TAB separated textfile and use bulkinsert to a
stagering table (with all data in the file). Then you can use SQL to split/get the data
you want.
/Gosta
September 22, 2009 at 7:08 am
imasemil (9/21/2009)
Hi allim also eperiencing the same proble.i have designed the SSIS Package and i want to filter tha rows where there's are NULLS.I Have tried using Conditional split but i cant get the right formula to use in conditiona split .please Advice.
TIA
imasemil,
You may be looking at cells with spaces instead of nulls. Try filtering out rows where the length of the trimmed value is 0.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply