Hi

I have 3 execute statements in "Execute SQL Task" which accepts the same
input parameter (i.e package Gloabal variable)

exec InsertTestDTS @Status = ?;
exec InsertTestDTS @Status = ?;
exec InsertTestDTS @Status = ?;

Currently i have to pass in 3 parameters to the above statements in
"Parameter Mapping" dialog.

How do minimize the redundancy while passing the same input parameter in the
above case ?

Regards
Gururaja

I would split this off to 3 * ExecuteSQL tasks. Easier to manage and isolate for problems


--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"System.Xml.XmlDocument" <SystemXmlXmlDocument (AT) discussions (DOT) microsoft.com> wrote