I have 2 Execute SQL tasks - No data flow task.
On Execute SQL task 1
I have query to pull firstname, lastname from contact table
select firstname, lastname FROM [AdventureWorks].[Person].[Contact]
On Execute SQL task 2
I want to insert those values to newly created table using parameters.
( i have 2 variables declared at package level as firstname, lastname)
insert into cnt(firstname,lastname) values (?,?)
1. Is it possible to pass values multiple times (or values) using variables.
2. What parameter Direction type & Result Set I need to use in Exec SQL task 1 and 2.
View Complete Post