Friday, March 30, 2012

Scripting

I'm used to using Unix to do scripting. It's a pretty powerful scripting
language with some looping, conditions, text editing/modification, etc. Does
DOS have all that built in as well? Is that you guys use to script? If so,
does it have looping, conditions, etc somewhat like Unix?CLM,
Try VBScript. SQL Server has the capability to used ActiveX scripts in DTS
packages and jobs.
For more information on VBScript see:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnanchor/html/scriptinga.asp
HTH
Jerry
"CLM" <CLM@.discussions.microsoft.com> wrote in message
news:0CCA63F8-34C0-40DE-A772-10A218F5F58A@.microsoft.com...
> I'm used to using Unix to do scripting. It's a pretty powerful scripting
> language with some looping, conditions, text editing/modification, etc.
> Does
> DOS have all that built in as well? Is that you guys use to script? If
> so,
> does it have looping, conditions, etc somewhat like Unix?|||One last question: can you execute it from the command line though?
"Jerry Spivey" wrote:
> CLM,
> Try VBScript. SQL Server has the capability to used ActiveX scripts in DTS
> packages and jobs.
> For more information on VBScript see:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnanchor/html/scriptinga.asp
> HTH
> Jerry
> "CLM" <CLM@.discussions.microsoft.com> wrote in message
> news:0CCA63F8-34C0-40DE-A772-10A218F5F58A@.microsoft.com...
> > I'm used to using Unix to do scripting. It's a pretty powerful scripting
> > language with some looping, conditions, text editing/modification, etc.
> > Does
> > DOS have all that built in as well? Is that you guys use to script? If
> > so,
> > does it have looping, conditions, etc somewhat like Unix?
>
>|||Yes use WScript or CScript (can be wrapped in .bat file as well).
HTH
Jerry
"CLM" <CLM@.discussions.microsoft.com> wrote in message
news:5653274C-128F-4D53-A024-14EC4434E831@.microsoft.com...
> One last question: can you execute it from the command line though?
> "Jerry Spivey" wrote:
>> CLM,
>> Try VBScript. SQL Server has the capability to used ActiveX scripts in
>> DTS
>> packages and jobs.
>> For more information on VBScript see:
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnanchor/html/scriptinga.asp
>> HTH
>> Jerry
>> "CLM" <CLM@.discussions.microsoft.com> wrote in message
>> news:0CCA63F8-34C0-40DE-A772-10A218F5F58A@.microsoft.com...
>> > I'm used to using Unix to do scripting. It's a pretty powerful
>> > scripting
>> > language with some looping, conditions, text editing/modification, etc.
>> > Does
>> > DOS have all that built in as well? Is that you guys use to script?
>> > If
>> > so,
>> > does it have looping, conditions, etc somewhat like Unix?
>>|||Thx. That ought to keep me busy. :)
"Jerry Spivey" wrote:
> Yes use WScript or CScript (can be wrapped in .bat file as well).
> HTH
> Jerry
> "CLM" <CLM@.discussions.microsoft.com> wrote in message
> news:5653274C-128F-4D53-A024-14EC4434E831@.microsoft.com...
> > One last question: can you execute it from the command line though?
> >
> > "Jerry Spivey" wrote:
> >
> >> CLM,
> >>
> >> Try VBScript. SQL Server has the capability to used ActiveX scripts in
> >> DTS
> >> packages and jobs.
> >>
> >> For more information on VBScript see:
> >>
> >> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnanchor/html/scriptinga.asp
> >>
> >> HTH
> >>
> >> Jerry
> >> "CLM" <CLM@.discussions.microsoft.com> wrote in message
> >> news:0CCA63F8-34C0-40DE-A772-10A218F5F58A@.microsoft.com...
> >> > I'm used to using Unix to do scripting. It's a pretty powerful
> >> > scripting
> >> > language with some looping, conditions, text editing/modification, etc.
> >> > Does
> >> > DOS have all that built in as well? Is that you guys use to script?
> >> > If
> >> > so,
> >> > does it have looping, conditions, etc somewhat like Unix?
> >>
> >>
> >>
>
>|||You can use the CSCRIPT from command line to execute ActiveX Script / if you
are using DTS packages , you could use DTSWIZ
"CLM" wrote:
> One last question: can you execute it from the command line though?
> "Jerry Spivey" wrote:
> > CLM,
> >
> > Try VBScript. SQL Server has the capability to used ActiveX scripts in DTS
> > packages and jobs.
> >
> > For more information on VBScript see:
> >
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnanchor/html/scriptinga.asp
> >
> > HTH
> >
> > Jerry
> > "CLM" <CLM@.discussions.microsoft.com> wrote in message
> > news:0CCA63F8-34C0-40DE-A772-10A218F5F58A@.microsoft.com...
> > > I'm used to using Unix to do scripting. It's a pretty powerful scripting
> > > language with some looping, conditions, text editing/modification, etc.
> > > Does
> > > DOS have all that built in as well? Is that you guys use to script? If
> > > so,
> > > does it have looping, conditions, etc somewhat like Unix?
> >
> >
> >sql

No comments:

Post a Comment