MSBI (SSIS/SSRS/SSAS) Online Training

Tuesday, February 24, 2009

SSIS-ExecuteSqlTask with ADO.NET Connection

Hi,
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

Thanks.

1 comment:

Ravindra said...

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

Regards,
Syam.