示例#1
0
        public List <IntegrationPackageResult> Execute(IList <ImportBankStmtParamItem> paramObjs)
        {
            Service1Client client = new Service1Client();
            var            result = new List <IntegrationPackageResult>();

            foreach (var paramObj in paramObjs)
            {
                if (paramObj.Enabled)
                {
                    var parameters = new SsisParameter[]
                    {
                        new SsisParameter()
                        {
                            ParameterName = "ChildPackageName", ParameterValue = paramObj.PackageName
                        },
                        new SsisParameter()
                        {
                            ParameterName = "SourceConnectionString", ParameterValue = paramObj.FilePath
                        },
                        new SsisParameter()
                        {
                            ParameterName  = "Account",
                            ParameterValue = paramObj.Account == null? "" : paramObj.Account.Name
                        }
                    };

                    IntegrationPackageResult childResult = client.ExecuteSsisPackage("BankStmtFile.dtsx", parameters);
                    result.Add(childResult);
                }
            }

            return(result);
        }
示例#2
0
        public IntegrationPackageResult Execute(string inputFilePath)
        {
            Service1Client client = new Service1Client();

            var parameters = new SsisParameter[] {
                new SsisParameter()
                {
                    ParameterName = "SourceConnectionString", ParameterValue = inputFilePath ?? ""
                }
            };

            IntegrationPackageResult result = client.ExecuteSsisPackage("WbcForexRate.dtsx", parameters);

            return(result);
        }