protected override void Setup(SetupContext context) { DtsParameter param = context.Package.GetParameter("SourcePath"); object val = param.GetValue(); param.SetValue(Constants.CustomersFileSource); DtsVariable var1 = context.Package.GetVariable("DestinationPath"); var1.SetValue(Constants.CustomersFileDestination); DtsVariable var2 = context.Package.GetVariable("ConvertDestinationPath"); var2.SetValue(Constants.CustomersFileConverted); DtsVariable var3 = context.Package.GetVariable("CopyCustomersPath"); var3.SetValue(Constants.PathToCopyCustomersPackage); DtsVariable var4 = context.Package.GetVariable("LoadCustomersPath"); var4.SetValue(Constants.PathToLoadCustomersPackage); DtsVariable var5 = context.Package.GetVariable("ConnectionString"); var5.SetValue(Constants.SsisDbConnectionString); }
protected override void Setup(SetupContext context) { DtsVariable custSrc = context.Package.GetVariableForPath(@"\[CopyCustomers4].[SourcePath]"); custSrc.SetValue(Constants.CustomersFileSource); DtsVariable custDest = context.Package.GetVariableForPath(@"\[CopyCustomers4].[DestinationPath]"); custDest.SetValue(Constants.CustomersFileDestination); DtsVariable custDestNew = context.Package.GetVariableForPath(@"\[CopyCustomers4].[ConvertDestinationPath]"); custDestNew.SetValue(Constants.CustomersFileConverted); DtsVariable variable = context.Package.GetVariableForPath(@"\[CopyCustomers4]\[DFT Convert customer names].[CustomerCount]"); variable.SetValue(0); DtsConnection newCustomersConnection = context.Package.GetConnection("New Customers Src"); newCustomersConnection.SetConnectionString(Constants.CustomersNewFileSource); DtsConnection productConnection = context.Package.GetConnection("Products Src"); productConnection.SetConnectionString(Constants.ProductsFileSource); }
protected override void Setup(SetupContext context) { DtsVariable variable = context.Package.GetVariableForPath(@"\[LoadCustomers].[CustomerCount]"); variable.SetValue(0); DtsVariable variable2 = context.Package.GetVariableForPath(@"\[LoadCustomers].[CustomersImported]"); variable2.SetValue(true); }
protected override void Setup(SetupContext context) { DtsVariable custDestNew = context.Package.GetVariableForPath(@"\[CopyCustomers2].[ConvertDestinationPath]"); custDestNew.SetValue(Constants.CustomersFileConverted); DtsVariable variable = context.Package.GetVariableForPath(@"\[CopyCustomers2]\[DFT Convert customer names].[CustomerCount]"); variable.SetValue(0); }
protected override void Setup(SetupContext context) { DtsVariable custSrc = context.Package.GetVariableForPath(@"\[CopyCustomers].[SourcePath]"); custSrc.SetValue(Constants.CustomersFileSource); DtsVariable custDest = context.Package.GetVariable(@"DestinationPath"); custDest.SetValue(Constants.CustomersFileDestination); }
protected override void Setup(SetupContext context) { ReplaceConnectionStrings(); var config = context.Package.GetConfiguration("ConnectionStrings"); config.SetConfigurationString(Constants.PathToDtsConfig); DtsVariable variable = context.Package.GetVariableForPath(@"\[CopyCustomersWithConfig]\[DFT Convert customer names].[CustomerCount]"); variable.SetValue(0); }
protected override void Setup(SetupContext context) { DtsVariable variable = context.Package.GetVariableForPath(@"\[LoadCustomers].[CustomerCount]"); variable.SetValue(0); _dummyConstraint = context.Package.GetPrecedingConstraintForPath(@"\[LoadCustomers]\[SCR Dummy].[DummyConstraint]"); _dummyConstraint.SetExecutionResult(DtsExecutionResult.Success); _countConstraint = context.Package.GetPrecedingConstraintForPath(@"\[LoadCustomers]\[SEQC Load]\[SQL Get Count of data in destination].[CountConstraint]"); _countConstraint.SetExecutionResult(DtsExecutionResult.Success); }
protected override void Setup(SetupContext context) { File.Copy(Constants.CustomersFileSource, Constants.CustomersFileDestination); DtsVariable custDest = context.Package.GetVariableForPath(@"\[CopyCustomers].[DestinationPath]"); custDest.SetValue(Constants.CustomersFileDestination); DtsVariable custDestNew = context.Package.GetVariable(@"ConvertDestinationPath"); custDestNew.SetValue(Constants.CustomersFileConverted); }
protected override void Setup(SetupContext context) { File.Copy(Constants.CustomersFileSource, Constants.CustomersFileDestination); context.Package.GetConnection("CustomerDB").SetConnectionString(Constants.SsisDbConnectionString); context.Package.GetConnection("Customers Src").SetConnectionString(Constants.CustomersFileSource); DtsVariable variable = context.Package.GetVariableForPath(@"\[LoadCustomers].[CustomerCount]"); variable.SetValue(0); DtsVariable variable2 = context.Package.GetVariableForPath(@"\[LoadCustomers].[CustomersImported]"); variable2.SetValue(false); }
protected override void Setup(SetupContext context) { DtsVariable custSrc = context.Package.GetVariableForPath(@"\[LoopWithDataFlow].[SourcePath]"); custSrc.SetValue(Constants.CustomersFileSource); DtsVariable custDest = context.Package.GetVariableForPath(@"\[LoopWithDataFlow].[DestinationPath]"); custDest.SetValue(Constants.CustomersFileDestination); DtsVariable custDestNew = context.Package.GetVariable(@"ConvertDestinationPath"); custDestNew.SetValue(Constants.CustomersFileConverted); DtsVariable variable = context.Package.GetVariableForPath(@"\[LoopWithDataFlow]\[FOR]\[DFT Convert customer names].[CustomerCount]"); variable.SetValue(0); }
protected override void Setup(SetupContext context) { context.Package.GetConnection("CustomerDB").SetConnectionString(Constants.SsisDbConnectionString); context.Package.GetConnection("Customers Src").SetConnectionString(Constants.CustomersFileSource); DtsVariable variable = context.Package.GetVariableForPath(@"\[LoadCustomers].[CustomerCount]"); variable.SetValue(0); const string query = @"insert into [dbo].[CustomersStaging] ([Id], [Name]) values (1, 'ACME') ,(2, 'ALL')"; context.DataAccess.OpenConnection(Constants.DbConnectionString); context.DataAccess.ExecuteNonQuery(query); context.DataAccess.CloseConnection(); }
protected override void Setup(SetupContext context) { DtsParameter custSrcParam = context.Package.Project.GetParameter(@"SourcePath"); custSrcParam.SetValue(Constants.CustomersFileSource); DtsParameter custDesParam = context.Package.Project.GetParameter(@"DestinationPath"); custDesParam.SetValue(Constants.CustomersFileDestination); DtsParameter custDesConvertedParam = context.Package.Project.GetParameter(@"ConvertDestinationPath"); custDesConvertedParam.SetValue(Constants.CustomersFileConverted); DtsVariable variable = context.Package.GetVariableForPath(@"\[CopyCustomers]\[DFT Convert customer names].[CustomerCount]"); variable.SetValue(0); }