Like Us
Plus One
Follow Us
Search
 Author Tahir Naveed  Views 762 View Original Article

Scenario:I was importing a CSV file with two columns (GPID, MemberOf) in a SSIS package when I found that GPID column might have null values and I don't need the entire row in my output if the GPID is null.Solution:One solution is to handle it via Script but why write code when Conditional Split is available.Conditional Split has function ISNULL([Column Name]) which takes Column name to check if its null or not and returns the output if condition meets.
View Original Article

Recent Articles from SharePoint Blue

Date Articles Visits
2017-Jun-12 Microsoft Flow - HTTP REST Call 1022     
2017-May-25 SharePoint Online Page Load Time with JavaScript 703     
2016-Nov-02 Microsoft Graph vs Office Graph 776     
2016-Oct-26 Office365 Subsite Logo Redirection 835     
2016-Sep-14 PowerShell Script Analyzer 885     
2016-Jun-12 SharePoint DSC 988     
2016-Mar-10 SharePoint Online - JavaScript Injection with PowerShell 1113     
2016-Mar-03 SharePoint - Export/Import Subsite 992     
2016-Feb-10 SharePoint - PowerApps (Mobile Apps) 1021     
2015-Dec-04 SharePoint - Responsive Design (Framework) 1330