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); }
internal DataSet GetGridViewData(string strPath) { string dtexecArgs; string dataReaderName; DtsConnection dtsConnection; DtsCommand dtsCommand; DataSet dsPackageData = new DataSet(); IDataReader dtsDataReader; dtexecArgs = string.Format("-f \"{0}\"", strPath); dataReaderName = "DataReaderDest"; dtsConnection = new DtsConnection(); dtsConnection.ConnectionString = dtexecArgs; dtsCommand = new DtsCommand(dtsConnection); dtsCommand.CommandText = dataReaderName; dtsConnection.Open(); dtsDataReader = dtsCommand.ExecuteReader(CommandBehavior.Default); dsPackageData.Load(dtsDataReader, LoadOption.OverwriteChanges, dtsDataReader.GetSchemaTable().TableName); try { if (dtsDataReader != null) { dtsDataReader.Close(); } } catch (Exception e) { MessageBox.Show( string.Format("Exception closing DataReader: {0}{1}", e.InnerException.Message, Environment.NewLine), "Exception closing connection", MessageBoxButtons.OK, MessageBoxIcon.Error ); } return(dsPackageData); }