|
Posted by francois.bourdages on 11/20/06 16:53
Create a batch file that will use OSQL or ISQL, and run all script you
want.
something like :
SET SERVERNAME=XYZ
SET DBNAME=ABC
SET USERNAME=ABC
SET PSW=ABC
ISQLW -U%USERNAME% -P%PSW% -S%SERVERNAME% -d%DBNAME%
-ic:\temp\script1.SQL -oLOGFILE.LOG -FA -n
TYPE LOGFILE.LOG >> FULLLOG.LOG
ISQLW -U%USERNAME% -P%PSW% -S%SERVERNAME% -d%DBNAME%
-ic:\temp\script3.SQL -oLOGFILE.LOG -FA -n
TYPE LOGFILE.LOG >> FULLLOG.LOG
Eng.Rana@gmail.com wrote:
> Thanx Benedikt :),
> plz note i'm using SQL server 2000
>
> any other ideas??
>
>
> Benedikt Ries wrote:
> > Have you considered using the Script-Task in the SSIS-package? AFAIK you
> > can access all functions there and write your Script in VB.NET code.
> >
> >
> > --
> > Benedikt Ries
> > ------------------------------------------------------------------------
> > Benedikt Ries's Profile: http://www.dbtalk.net/m1098
> > View this thread: http://www.dbtalk.net/t345220
Navigation:
[Reply to this message]
|