Like Us
Plus One
Follow Us
 Author Tahir Naveed  Views 962 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 1267     
2017-May-25 SharePoint Online Page Load Time with JavaScript 936     
2016-Nov-02 Microsoft Graph vs Office Graph 1022     
2016-Oct-26 Office365 Subsite Logo Redirection 1127     
2016-Sep-14 PowerShell Script Analyzer 1130     
2016-Jun-12 SharePoint DSC 1237     
2016-Mar-10 SharePoint Online - JavaScript Injection with PowerShell 1376     
2016-Mar-03 SharePoint - Export/Import Subsite 1232     
2016-Feb-10 SharePoint - PowerApps (Mobile Apps) 1241     
2015-Dec-04 SharePoint - Responsive Design (Framework) 1566