Like Us
Plus One
Follow Us
 Author Tahir Naveed  Views 748 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 854     
2017-May-25 SharePoint Online Page Load Time with JavaScript 565     
2016-Nov-02 Microsoft Graph vs Office Graph 637     
2016-Oct-26 Office365 Subsite Logo Redirection 687     
2016-Sep-14 PowerShell Script Analyzer 742     
2016-Jun-12 SharePoint DSC 829     
2016-Mar-10 SharePoint Online - JavaScript Injection with PowerShell 974     
2016-Mar-03 SharePoint - Export/Import Subsite 855     
2016-Feb-10 SharePoint - PowerApps (Mobile Apps) 894     
2015-Dec-04 SharePoint - Responsive Design (Framework) 1173