dbTalk Databases Forums  

Modifying sp_add_dtspackage

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


Discuss Modifying sp_add_dtspackage in the microsoft.public.sqlserver.dts forum.



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

Default Modifying sp_add_dtspackage - 02-13-2004 , 11:41 AM






I want to try modifying sp_add_dtspackage, as suggested by Darren Green
at

http://www.sqldts.com/main.asp?nav=1,6,212,0

..but logged on as 'sa' - I can't edit it. Any ideas?

Lewis Veale
lewisdotvealeatpdms.com
www.pdms.com

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Reply With Quote
  #2  
Old   
Darren Green
 
Posts: n/a

Default Re: Modifying sp_add_dtspackage - 02-13-2004 , 01:21 PM






In message <eErDOil8DHA.3880 (AT) tk2msftngp13 (DOT) phx.gbl>, Lewis
<lewisdotvealeatpdms.com@?.?.invalid> writes
Quote:
I want to try modifying sp_add_dtspackage, as suggested by Darren Green
at

http://www.sqldts.com/main.asp?nav=1,6,212,0

.but logged on as 'sa' - I can't edit it. Any ideas?

What is the error?

Using QA I script the proc, make the changes, then run the new create
(with drop). Works fine.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org



Reply With Quote
  #3  
Old   
Lewis
 
Posts: n/a

Default Re: Modifying sp_add_dtspackage - 02-16-2004 , 03:24 AM



Ahh - I see. I was just opening it in Enterprise Manager - there is no
error, I just can't edit - the background is grey instead of white.

I can do it in QA as you describe, thanks!

Lewis Veale
lewisdotvealeatpdms.com
www.pdms.com

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

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.