Mapping of parameters not getting saved. -
10-05-2005
, 03:54 PM
I am creating a DTS package in SQL 2000 with SP3. (Same issue in SP4)
This package has one "Execute SQL task". The task calls a stored procedure
which takes parameters. Using parameter mapping, I try to map the global
variables already defined to the parameters for my procedure. No problems
while mapping. When I click OK and come of edit mode, I loose the mapping. Is
there any known issue? workaround / fixes?
Ironically it does not happen on all the SQL servers I use. It is not a
consistent issue.
Thanks for any help. |