MicrosoftSSIS

Synchronous Fully Asynchronous Sort Partially Asynchronous Union All Aggregation

Data Type SQL Server (SQLOLEDB; SQLNCLI10) SQL Server (SqlClient) Jet Oracle (OracleClient) DB2 (DB2OLEDB) DB2 (IBMDADB2) DT_BOOL bit bit Bit DT_BYTES binary, varbinary, timestamp binary, varbinary, timestamp BigBinary, VarBinary RAW DT_CY smallmoney, money smallmoney, money Currency DT_DATE DT_DBDATE date (Transact-SQL) date (Transact-SQL) date date date DT_DBTIME timestamp time time DT_DBTIME2 time (Transact-SQL) (p) time (Transact-SQL)  (p) DT_DBTIMESTAMP datetime (Transact-SQL) ,  smalldatetime (Transact-SQL) datetime (Transact-SQL) ,  smalldatetime (Transact-SQL) DateTime TIMESTAMP, DATE, INTERVAL TIME, TIMESTAMP, DATE TIME, TIMESTAMP, DATE DT_DBTIMESTAMP2 datetime2 (Transact-SQL) datetime2 (Transact-SQL) timestamp timestamp timestamp DT_DBTIMESTAMPOFFSET datetimeoffset (Transact-SQL) (p) datetimeoffset (Transact-SQL) (p) timestampoffset timestamp, varchar timestamp, varchar DT_DECIMAL DT_FILETIME DT_GUID uniqueidentifier uniqueidentifier GUID DT_...

dts.variables("NameOfVariable").value where as dts is old name of SSIS i.e. data transfromation services. List Of Variables System::ContainerStartTime System::CreationName System::LocaleID System::ParentContainerGUID System::TaskID System::TaskName System::TaskTransactionOption System::CancelEvent User::CountOfRows System::CreationDate System::CreatorComputerName System::CreatorName System::ExecutionInstanceGUID System::FailedConfigurations System::IgnoreConfigurationsOnLoad System::InteractiveMode System::LastModifiedProductVersion System::MachineName System::OfflineMode System::PackageID System::PackageName System::ProductVersion System::ServerExecutionID System::StartTime System::UserName System::VersionBuild System::VersionComments System::VersionGUID System::VersionMajor System::VersionMinor List Of Variables System ContainerStartTime System CreationName System LocaleID System ParentContainer...