thank you. I am very new to this so please excuse if any of the questions looks basic.

the query has no parameters.

something like this

create table #product

(

prod_id int

,prod_detail varchar(40) )

INSERT INTO #product (prod_id ,prod_detail )

SELECT 1, 'bicycle'

UNION ALL

SELECT 2, 'car'

UNION ALL

SELECT 3, 'truck'

UNION ALL

SELECT 4, 'van'

select * from #product

drop table #product

I should add one execute sql task then a dataflow task for each server right ?

>I added one execute sql task on control flow tab

>selected ADO.net connection, result set as full result set,

i get error like failed to lock variable. I think I am not setting up the variable right.

if there is a good link for beginner, please post that as well.

thanks