MSBI (SSIS/SSRS/SSAS) Online Training

Tuesday, February 24, 2009

SSIS-ExecuteSqlTask with ADO.NET Connection

ADO is a Microsoft own driver,so it is a way to connect and fast to execute sql statements than OLEDB.
By using ADO.NET Connection we can set the parameters as described below.

strADOConnectionString is defined like

Data Source=localhost;Initial Catalog=AdventureWorksDW;Integrated Security=True;

General Tab:-

ConnectionType ADO.NET
Connection ADO.NET
SqlSourceType Direct
SQLStatement uspETLLoadPackage
IsQueryStoredProcedure True

ParameterMapping Tab:-

VariableName Direction Data Type ParameterName

System::PackageName Input String @PkgName
System::ContainerStartTime Input DateTime @ExecStartDT
User::intPkgExecKey Output Int32 @intPkgExecKey
User::intDimAuditKey Output Int32 @intdimAuditKey


1 comment:

Ravindra said...

What is the difference between AD.NET and OLEDB Connection to Execute for ExecuteSqlTask and Which one is the best one?