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

Scenario:I had a scenario where I will get the AD export in CSV format with two columns (samaccountname, GUID) and I had to check if the GUID is null then put the value "0" instead of null value.Solution:1. Load the CSV file into SSIS project2. Make data connection.3. Add the script component.4. Edit the Script and overwrite the following function:public override void Input0_ProcessInputRow(Input0Buffer Row){ if (Row.GUID_Input.Length > 0) { Row.GUID_Output = Row.GUID_Input; }…
View Original Article

Recent Articles from SharePoint Blue

Date Articles Visits
2017-Jun-12 Microsoft Flow - HTTP REST Call 948     
2017-May-25 SharePoint Online Page Load Time with JavaScript 643     
2016-Nov-02 Microsoft Graph vs Office Graph 712     
2016-Oct-26 Office365 Subsite Logo Redirection 767     
2016-Sep-14 PowerShell Script Analyzer 823     
2016-Jun-12 SharePoint DSC 922     
2016-Mar-10 SharePoint Online - JavaScript Injection with PowerShell 1053     
2016-Mar-03 SharePoint - Export/Import Subsite 933     
2016-Feb-10 SharePoint - PowerApps (Mobile Apps) 969     
2015-Dec-04 SharePoint - Responsive Design (Framework) 1259