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:
Hi,
What is the difference between AD.NET and OLEDB Connection to Execute for ExecuteSqlTask and Which one is the best one?
Regards,
Syam.
Post a Comment