dbTalk Databases Forums  

Mapping of parameters not getting saved.

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Mapping of parameters not getting saved. in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Rahul
 
Posts: n/a

Default 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.


Reply With Quote
  #2  
Old   
Rahul
 
Posts: n/a

Default RE: Mapping of parameters not getting saved. - 10-19-2005 , 01:51 PM






Well guys, I found a fix myself. Re-installing SQL Client tools did the trick.
Don't know if this was a problem only for me. But since it was identical on
more than one server, I am guessing not.
Rahul


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.