I would like to create a temp table #hs in the execute sql task becuase i dont want create a staging table

in the production database and then use the...

Thanks Jayanth

its working fine....

I installed 2005 sp2 and got it fixed

I am using

Microsoft SQL Server Integration Services Designer

Version 9.00.1399.00

Visual Studio..

Microsoft Visual Studio 2005 Team Edition for Software Testers

i re installed it once

I tried F4 by setting the expression value to true...

but still unable get the expression builder

I dont have that symbol (...) there.

is it because of SQL 2005 or is it missing?

Little bit deept into it

Unable to do it

I will try using that...

And how to rollback the transaction.Does the code i have given works fine?

Begin Transaction Tran7

insert into #t (...)

SELECT ..

FROM #hs t

INNER JOIN table1 on

If @@ERROR <> 0

Begin

Rollback Transaction Tran7

INSERT INTO LogTable Values (7,@@ROWCOUNT,'F',@Startdate,getdate())

End

Else

Begin

Commit transaction Tran7

INSERT INTO...

Hello

what i am planing to do based on your suggestion is to load the data which comes from each SP to a table in the same DB on which...

Thanks

Those should be run parallel because of time constraints.

The stored procedure generates same type of meta data in each database.

It's a database Table