locked
Azure Datafactory v2- SSIS deployment issue RRS feed

  • Question

  • Hi -

    I am trying to deploy a SSIS package which access 3 files from azure blob storage.

    I am using couple of script

        public override void Input0_ProcessInputRow(Input0Buffer Row)
        {
            if (Row.zipcode != Category)
            {            row_rank = 1;
                Row.Rowrank = row_rank; //Row_Rank

                Category = Row.zipcode;
            }
            else
            {
                row_rank++;
                Row.Rowrank = row_rank;

            }
        }

    // C# Code
    using System;

    [Microsoft.SqlServer.Dts.Pipeline.SSISScriptComponentEntryPointAttribute]

    public class ScriptMain : UserComponent
    {

        public override void Input0_ProcessInputRow(Input0Buffer Row)
        {


            Output0Buffer.AddRow();
            Output0Buffer.zipcode = Row.zipcode;
            Output0Buffer.stationid = Row.stationid;
            Output0Buffer.city = Row.city;
            double stat_lat = Convert.ToDouble(Row.statlatitude);
            double rad_stat_lat = (Math.PI / 180) * stat_lat;
            double stat_lon = Convert.ToDouble(Row.statlongitude);
            double lat = Convert.ToDouble(Row.latitude);
            double rad_lat = (Math.PI / 180) * lat;
            double lon = Convert.ToDouble(Row.longitude);
            double dLat = (Math.PI / 180) * (stat_lat - lat);
            double dLng = (Math.PI / 180) * (stat_lon - lon);
            double a = Math.Sin(dLat / 2) * Math.Sin(dLat / 2) +
        Math.Cos(rad_stat_lat) * Math.Cos(rad_lat) *
        Math.Sin(dLng / 2) * Math.Sin(dLng / 2);
            double c = 2 * Math.Asin(Math.Min(1, Math.Sqrt(a)));
            double d = 6371 * 2 * Math.Asin(Math.Min(1, Math.Sqrt(a)));
            Output0Buffer.distance =d;
            Output0Buffer.statlatitude = stat_lat;
            Output0Buffer.statlongitude = stat_lon;


        }
    }

    The job ran fine in the GDE. But when i try to deploy to the ADF-V2 SSIS Integration it fails. Please help , is this a limitation of ADF V2 - IR SSIS that custom scripts cant be deployed?

    Monday, December 25, 2017 12:03 AM

All replies

  • Custom scripts are supported, do you have more detail errors so we can see what's going wrong? thanks

    Monday, December 25, 2017 3:25 AM