dbTalk Databases Forums  

Execute Process Task - Parameter Length

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


Discuss Execute Process Task - Parameter Length in the microsoft.public.sqlserver.dts forum.



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

Default Execute Process Task - Parameter Length - 06-30-2003 , 12:20 PM






Is there a limit to the number of characters that can be passed to the
"Parameters" line or "Win32 process" line of an Execute Process Task?

I am using DTS on SQL Server 2000.

Thanks
Robert



Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Execute Process Task - Parameter Length - 07-01-2003 , 01:24 AM






The ProcessCommandLine is specified as String so I would have thought you
will run out of things to say on it before it falls over.

How many chars are you putting on there ?
Is this a visual thing you are having problems with i.e you can't type
anymore into the box?

--


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Robert R" <rrutledge (AT) hbk (DOT) com> wrote

Quote:
Is there a limit to the number of characters that can be passed to the
"Parameters" line or "Win32 process" line of an Execute Process Task?

I am using DTS on SQL Server 2000.

Thanks
Robert





Reply With Quote
  #3  
Old   
Krisztian Pinter
 
Posts: n/a

Default Re: Execute Process Task - Parameter Length - 07-01-2003 , 03:59 AM



255 characters, very annoying. finally, I replaced execute process
task with an own custom dts task doing the same, but not having the
lame limitation. thanks, bill!


"Robert R" <rrutledge (AT) hbk (DOT) com> wrote

Quote:
Is there a limit to the number of characters that can be passed to the
"Parameters" line or "Win32 process" line of an Execute Process Task?

I am using DTS on SQL Server 2000.

Thanks
Robert

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.