Job: Export to File: no headers/trailers

Hi,
I tryed to Export a query to a Fiel with a Job.
What I found in my file was this:
"
Job 'ExportToSiclid' : Step 1, 'ExportFile' : Began Executing 2004-06-22
13:16:07
tdprNFoy tdprNCCD CallDate TEL Choice
tdprNSocFin Agent
-- -- -- -- -- --
-- --
4240001034 9100 2004-06-22-13.13.48.71700 0478385115 Informatie 110
Van den Hel, Heidi
4276454891 9100 2004-06-22-13.13.57.23300 0 FIDI 104
Tanghe, Wendy
(2 rows(s) affected)
"
What I actually expected and wanted was this:
"
42400010349100 2004-06-22-13.13.48.717000478385115 Informatie110
Van den Hel, Heidi
42764548919100 2004-06-22-13.13.57.233000 FIDI 104
Tanghe, Wendy
"
So without the header, without the trailer, without the names of the
columns, and without a space between the columns.
Is this possible or not, and if so: how?
Thanks a lot in advance,
PieterHi
This looks like you are starting a command prompt and running osql/isql? You
may want to look at adding SET NOCOUNT ON to the SQL and using the -h flag
to osql/isql. Alternatively try the
DTS Export wizard or BCP utility. Mor information on all of these can be
found in Books Online.
John
"DraguVaso" <pietercoucke@.hotmail.com> wrote in message
news:OqhPeoEWEHA.208@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I tryed to Export a query to a Fiel with a Job.
> What I found in my file was this:
> "
> Job 'ExportToSiclid' : Step 1, 'ExportFile' : Began Executing 2004-06-22
> 13:16:07
> tdprNFoy tdprNCCD CallDate TEL Choice
> tdprNSocFin Agent
> -- -- -- -- -- -
--
> -- --
> 4240001034 9100 2004-06-22-13.13.48.71700 0478385115 Informatie
110
> Van den Hel, Heidi
> 4276454891 9100 2004-06-22-13.13.57.23300 0 FIDI
104
> Tanghe, Wendy
> (2 rows(s) affected)
> "
> What I actually expected and wanted was this:
> "
> 42400010349100 2004-06-22-13.13.48.717000478385115 Informatie110
> Van den Hel, Heidi
> 42764548919100 2004-06-22-13.13.57.233000 FIDI 104
> Tanghe, Wendy
> "
> So without the header, without the trailer, without the names of the
> columns, and without a space between the columns.
> Is this possible or not, and if so: how?
> Thanks a lot in advance,
> Pieter
>|||Thanks,
And how do you put a DTS or BCP in a job so it is executed every day
automaticly?
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:uvJvr2EWEHA.556@.tk2msftngp13.phx.gbl...
> Hi
> This looks like you are starting a command prompt and running osql/isql?
You
> may want to look at adding SET NOCOUNT ON to the SQL and using the -h flag
> to osql/isql. Alternatively try the
> DTS Export wizard or BCP utility. Mor information on all of these can be
> found in Books Online.
> John
> "DraguVaso" <pietercoucke@.hotmail.com> wrote in message
> news:OqhPeoEWEHA.208@.TK2MSFTNGP10.phx.gbl...
> > Hi,
> >
> > I tryed to Export a query to a Fiel with a Job.
> >
> > What I found in my file was this:
> >
> > "
> > Job 'ExportToSiclid' : Step 1, 'ExportFile' : Began Executing 2004-06-22
> > 13:16:07
> >
> > tdprNFoy tdprNCCD CallDate TEL Choice
> > tdprNSocFin Agent
> -- -- -- -- -- -
> --
> > -- --
> > 4240001034 9100 2004-06-22-13.13.48.71700 0478385115 Informatie
> 110
> > Van den Hel, Heidi
> > 4276454891 9100 2004-06-22-13.13.57.23300 0 FIDI
> 104
> > Tanghe, Wendy
> >
> > (2 rows(s) affected)
> > "
> >
> > What I actually expected and wanted was this:
> > "
> > 42400010349100 2004-06-22-13.13.48.717000478385115 Informatie110
> > Van den Hel, Heidi
> > 42764548919100 2004-06-22-13.13.57.233000 FIDI 104
> > Tanghe, Wendy
> > "
> >
> > So without the header, without the trailer, without the names of the
> > columns, and without a space between the columns.
> >
> > Is this possible or not, and if so: how?
> >
> > Thanks a lot in advance,
> >
> > Pieter
> >
> >
>|||Hi
If you run the DTS export wizard that will give you the option to schedule
the DTS job. This can also be changed in the created job. If you are already
running osql from your batch job, you can change the command to run BCP
instead.
John
"DraguVaso" <pietercoucke@.hotmail.com> wrote in message
news:eygYb4FWEHA.1048@.tk2msftngp13.phx.gbl...
> Thanks,
> And how do you put a DTS or BCP in a job so it is executed every day
> automaticly?
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:uvJvr2EWEHA.556@.tk2msftngp13.phx.gbl...
> > Hi
> >
> > This looks like you are starting a command prompt and running osql/isql?
> You
> > may want to look at adding SET NOCOUNT ON to the SQL and using the -h
flag
> > to osql/isql. Alternatively try the
> > DTS Export wizard or BCP utility. Mor information on all of these can be
> > found in Books Online.
> >
> > John
> >
> > "DraguVaso" <pietercoucke@.hotmail.com> wrote in message
> > news:OqhPeoEWEHA.208@.TK2MSFTNGP10.phx.gbl...
> > > Hi,
> > >
> > > I tryed to Export a query to a Fiel with a Job.
> > >
> > > What I found in my file was this:
> > >
> > > "
> > > Job 'ExportToSiclid' : Step 1, 'ExportFile' : Began Executing
2004-06-22
> > > 13:16:07
> > >
> > > tdprNFoy tdprNCCD CallDate TEL Choice
> > > tdprNSocFin Agent
> >
> -- -- -- -- -- -
> > --
> > > -- --
> > > 4240001034 9100 2004-06-22-13.13.48.71700 0478385115
Informatie
> > 110
> > > Van den Hel, Heidi
> > > 4276454891 9100 2004-06-22-13.13.57.23300 0 FIDI
> > 104
> > > Tanghe, Wendy
> > >
> > > (2 rows(s) affected)
> > > "
> > >
> > > What I actually expected and wanted was this:
> > > "
> > > 42400010349100 2004-06-22-13.13.48.717000478385115
Informatie110
> > > Van den Hel, Heidi
> > > 42764548919100 2004-06-22-13.13.57.233000 FIDI
104
> > > Tanghe, Wendy
> > > "
> > >
> > > So without the header, without the trailer, without the names of the
> > > columns, and without a space between the columns.
> > >
> > > Is this possible or not, and if so: how?
> > >
> > > Thanks a lot in advance,
> > >
> > > Pieter
> > >
> > >
> >
> >
>|||Thanks!!
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:OCSgETGWEHA.2908@.TK2MSFTNGP10.phx.gbl...
> Hi
> If you run the DTS export wizard that will give you the option to schedule
> the DTS job. This can also be changed in the created job. If you are
already
> running osql from your batch job, you can change the command to run BCP
> instead.
> John
> "DraguVaso" <pietercoucke@.hotmail.com> wrote in message
> news:eygYb4FWEHA.1048@.tk2msftngp13.phx.gbl...
> > Thanks,
> >
> > And how do you put a DTS or BCP in a job so it is executed every day
> > automaticly?
> >
> > "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> > news:uvJvr2EWEHA.556@.tk2msftngp13.phx.gbl...
> > > Hi
> > >
> > > This looks like you are starting a command prompt and running
osql/isql?
> > You
> > > may want to look at adding SET NOCOUNT ON to the SQL and using the -h
> flag
> > > to osql/isql. Alternatively try the
> > > DTS Export wizard or BCP utility. Mor information on all of these can
be
> > > found in Books Online.
> > >
> > > John
> > >
> > > "DraguVaso" <pietercoucke@.hotmail.com> wrote in message
> > > news:OqhPeoEWEHA.208@.TK2MSFTNGP10.phx.gbl...
> > > > Hi,
> > > >
> > > > I tryed to Export a query to a Fiel with a Job.
> > > >
> > > > What I found in my file was this:
> > > >
> > > > "
> > > > Job 'ExportToSiclid' : Step 1, 'ExportFile' : Began Executing
> 2004-06-22
> > > > 13:16:07
> > > >
> > > > tdprNFoy tdprNCCD CallDate TEL Choice
> > > > tdprNSocFin Agent
> > >
> >
> -- -- -- -- -- -
> > > --
> > > > -- --
> > > > 4240001034 9100 2004-06-22-13.13.48.71700 0478385115
> Informatie
> > > 110
> > > > Van den Hel, Heidi
> > > > 4276454891 9100 2004-06-22-13.13.57.23300 0 FIDI
> > > 104
> > > > Tanghe, Wendy
> > > >
> > > > (2 rows(s) affected)
> > > > "
> > > >
> > > > What I actually expected and wanted was this:
> > > > "
> > > > 42400010349100 2004-06-22-13.13.48.717000478385115
> Informatie110
> > > > Van den Hel, Heidi
> > > > 42764548919100 2004-06-22-13.13.57.233000 FIDI
> 104
> > > > Tanghe, Wendy
> > > > "
> > > >
> > > > So without the header, without the trailer, without the names of the
> > > > columns, and without a space between the columns.
> > > >
> > > > Is this possible or not, and if so: how?
> > > >
> > > > Thanks a lot in advance,
> > > >
> > > > Pieter
> > > >
> > > >
> > >
> > >
> >
> >
>

Job/Sheduled DTS/...: Rename a File

Hi,
I need to import a file with a Sheduled DTS, and after I have imported it I
shoudl rename the File. Is there any way to do this with a DTS or Job?
Thanks a lot,
PieterDragu,
have a look at this link. It has examples of different uses of the
filesystemobject which you'll need to call in VBScript:
http://www.sqldts.com/default.aspx?292
HTH,
Paul Ibison|||Pieter,
Execute a batch file either using DTS or sql job.
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"DraguVaso" <pietercoucke@.hotmail.com> wrote in message
news:#ntqwtPWEHA.1760@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I need to import a file with a Sheduled DTS, and after I have imported it
I
> shoudl rename the File. Is there any way to do this with a DTS or Job?
> Thanks a lot,
> Pieter
>|||Great! Thanks! How do I execute such a script in my Job?
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:eJj$21PWEHA.4056@.TK2MSFTNGP11.phx.gbl...
> Dragu,
> have a look at this link. It has examples of different uses of the
> filesystemobject which you'll need to call in VBScript:
> http://www.sqldts.com/default.aspx?292
> HTH,
> Paul Ibison
>|||Dragu,
these scripts can be copied and pasted into an activeX script task.
Regards,
Paul Ibison|||Thanks! :-)
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:O88QAeQWEHA.1356@.TK2MSFTNGP09.phx.gbl...
> Dragu,
> these scripts can be copied and pasted into an activeX script task.
> Regards,
> Paul Ibison
>

Job/Sheduled DTS/...: Rename a File

Hi,
I need to import a file with a Sheduled DTS, and after I have imported it I
shoudl rename the File. Is there any way to do this with a DTS or Job?
Thanks a lot,
PieterDragu,
have a look at this link. It has examples of different uses of the
filesystemobject which you'll need to call in vbscript :
http://www.sqldts.com/default.aspx?292
HTH,
Paul Ibison|||Pieter,
Execute a batch file either using DTS or sql job.
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"DraguVaso" <pietercoucke@.hotmail.com> wrote in message
news:#ntqwtPWEHA.1760@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I need to import a file with a Sheduled DTS, and after I have imported it
I
> shoudl rename the File. Is there any way to do this with a DTS or Job?
> Thanks a lot,
> Pieter
>|||Great! Thanks! How do I execute such a script in my Job?
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:eJj$21PWEHA.4056@.TK2MSFTNGP11.phx.gbl...
> Dragu,
> have a look at this link. It has examples of different uses of the
> filesystemobject which you'll need to call in vbscript :
> http://www.sqldts.com/default.aspx?292
> HTH,
> Paul Ibison
>|||Dragu,
these scripts can be copied and pasted into an activeX script task.
Regards,
Paul Ibison|||Thanks! :-)
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:O88QAeQWEHA.1356@.TK2MSFTNGP09.phx.gbl...
> Dragu,
> these scripts can be copied and pasted into an activeX script task.
> Regards,
> Paul Ibison
>sql

Job/Sheduled DTS/...: Rename a File

Hi,
I need to import a file with a Sheduled DTS, and after I have imported it I
shoudl rename the File. Is there any way to do this with a DTS or Job?
Thanks a lot,
Pieter
Dragu,
have a look at this link. It has examples of different uses of the
filesystemobject which you'll need to call in vbscript:
http://www.sqldts.com/default.aspx?292
HTH,
Paul Ibison
|||Pieter,
Execute a batch file either using DTS or sql job.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"DraguVaso" <pietercoucke@.hotmail.com> wrote in message
news:#ntqwtPWEHA.1760@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I need to import a file with a Sheduled DTS, and after I have imported it
I
> shoudl rename the File. Is there any way to do this with a DTS or Job?
> Thanks a lot,
> Pieter
>
|||Great! Thanks! How do I execute such a script in my Job?
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:eJj$21PWEHA.4056@.TK2MSFTNGP11.phx.gbl...
> Dragu,
> have a look at this link. It has examples of different uses of the
> filesystemobject which you'll need to call in vbscript:
> http://www.sqldts.com/default.aspx?292
> HTH,
> Paul Ibison
>
|||Dragu,
these scripts can be copied and pasted into an activeX script task.
Regards,
Paul Ibison
|||Thanks! :-)
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:O88QAeQWEHA.1356@.TK2MSFTNGP09.phx.gbl...
> Dragu,
> these scripts can be copied and pasted into an activeX script task.
> Regards,
> Paul Ibison
>

Job with stored proc succeeds with sqlstate 01000

I have a stored procedure that I am executing through the sql server
job scheduler, it executes properly but after each line in the log file
there is a sqlstate message.
procedure name p_document_purge [SQLSTATE 01000]
Archiving records [SQLSTATE 01000]
51 rows archived [SQLSTATE 01000]
Purging duplicate records [SQLSTATE 01000]
51 rows purged [SQLSTATE 01000]
Purge completed successfully [SQLSTATE 01000]
Does anyone know what might cause this? The @.@.ERROR during the
procedure is always 0 or it would rollback the entire transaction. Also
If I run the proc from query analyzer I do not get any negative
feedback regarding it. I tried looking in the documentation, but this
is listed as a general error which doesn't really help.
Thanks
BillPrint statements in the stored procedure can result in the
sqlstate message.
-Sue
.
On 23 Feb 2006 06:30:49 -0800, william_dudek@.yahoo.com
wrote:
>I have a stored procedure that I am executing through the sql server
>job scheduler, it executes properly but after each line in the log file
>there is a sqlstate message.
>procedure name p_document_purge [SQLSTATE 01000]
>Archiving records [SQLSTATE 01000]
>51 rows archived [SQLSTATE 01000]
>Purging duplicate records [SQLSTATE 01000]
>51 rows purged [SQLSTATE 01000]
>Purge completed successfully [SQLSTATE 01000]
>Does anyone know what might cause this? The @.@.ERROR during the
>procedure is always 0 or it would rollback the entire transaction. Also
>If I run the proc from query analyzer I do not get any negative
>feedback regarding it. I tried looking in the documentation, but this
>is listed as a general error which doesn't really help.
>Thanks
>Bill

job to read the zip file and insert db

Hi,
I need to grab the zip file on ftp server periodically,
and the zip file contains one text file, then I need to
insert the records into db, Iwould like to automate the
process. How can set it up?
ThanksHi,
Try using pkunzip and BCP IN utilities to perform this.
Thanks
Hari
MCDBA
"Jen" <anonymous@.discussions.microsoft.com> wrote in message
news:0f2101c3b476$4bfeb470$a001280a@.phx.gbl...
> Hi,
> I need to grab the zip file on ftp server periodically,
> and the zip file contains one text file, then I need to
> insert the records into db, Iwould like to automate the
> process. How can set it up?
> Thanks|||Jen,
You can use wzunzip.exe (WinZip command-line) to unzip the file. You can use
ftp -s <filename> to script the ftp (or use something like www.webdrive.com to
make the ftp server look like an NT drive). You can use bcp.exe or bulk insert
or dts to insert the records.
Pull it all together with a few lines of batch file.
> I need to grab the zip file on ftp server periodically,
> and the zip file contains one text file, then I need to
> insert the records into db, Iwould like to automate the
> process. How can set it up?
> Thanks
>
Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
(faqxxx.zip in lib 7)
or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faq

job steps synchronous?

Quick question - if I have several steps in a job are they run one after the other or can there potentially be overlap. In one step I create a file and the subsequent step copies it, so I'm concerned that the first completes before the second begins
TIA
Frank SThey are sequental.
Bojidar Alexandrov|||Frank,
My experience is that it is no overlap.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Frank Spencer" <anonymous@.discussions.microsoft.com> wrote in message
news:C2E0F3EF-331D-49CF-A77E-ECCEF0710F32@.microsoft.com...
> Quick question - if I have several steps in a job are they run one after the other or can there potentially
be overlap. In one step I create a file and the subsequent step copies it, so I'm concerned that the first
completes before the second begins.
> TIA,
> Frank S

job steps synchronous?

Quick question - if I have several steps in a job are they run one after the
other or can there potentially be overlap. In one step I create a file and
the subsequent step copies it, so I'm concerned that the first completes bef
ore the second begins.
TIA,
Frank SThey are sequental.
Bojidar Alexandrov|||Frank,
My experience is that it is no overlap.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Frank Spencer" <anonymous@.discussions.microsoft.com> wrote in message
news:C2E0F3EF-331D-49CF-A77E-ECCEF0710F32@.microsoft.com...
> Quick question - if I have several steps in a job are they run one after the other
or can there potentially
be overlap. In one step I create a file and the subsequent step copies it, s
o I'm concerned that the first
completes before the second begins.
> TIA,
> Frank Ssql

job steps synchronous?

Quick question - if I have several steps in a job are they run one after the other or can there potentially be overlap. In one step I create a file and the subsequent step copies it, so I'm concerned that the first completes before the second begins.
TIA,
Frank S
They are sequental.
Bojidar Alexandrov
|||Frank,
My experience is that it is no overlap.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Frank Spencer" <anonymous@.discussions.microsoft.com> wrote in message
news:C2E0F3EF-331D-49CF-A77E-ECCEF0710F32@.microsoft.com...
> Quick question - if I have several steps in a job are they run one after the other or can there potentially
be overlap. In one step I create a file and the subsequent step copies it, so I'm concerned that the first
completes before the second begins.
> TIA,
> Frank S

Job Step of more than 3200 characters

Hi,
An ActiveX script has 42318 characters in a vbs file. We are trying to use this .vbs file as a job step. We get this error message:
--
Edit Job Step - 192.168.1.75\TrialJob
--
The specified file ('mailscripts\send_auto_con.vbs'), is 42318 characters in size, which is larger than the available free space in the current Job Step command (3200 characters).
Do you want to continue opening this file but have its contents truncated.
--
Yes No
--
Can we execute the vbs file as such? Can somebody help us with this issue. Thanks in advance.
regards,
MadhuTry executing the vbs file using CScript and a CmdExec job
step instead.
-Sue
On Tue, 18 Nov 2003 03:16:08 -0800, "Madhu"
<anonymous@.discussions.microsoft.com> wrote:
>Hi,
>An ActiveX script has 42318 characters in a vbs file. We are trying to use this .vbs file as a job step. We get this error message:
>--
>Edit Job Step - 192.168.1.75\TrialJob
>--
>The specified file ('mailscripts\send_auto_con.vbs'), is 42318 characters in size, which is larger than the available free space in the current Job Step command (3200 characters).
>Do you want to continue opening this file but have its contents truncated.
>--
>Yes No
>--
>Can we execute the vbs file as such? Can somebody help us with this issue. Thanks in advance.
>regards,
>Madhu|||Hi Sue,
Thanks for the information, could you please elaborate on how we could
achieve this? May be a code snippet or something that would help us.
Thanks in advance,
Madhu
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:9ebkrvool9ie3lq2gtmksanndfsd31u16f@.4ax.com...
> Try executing the vbs file using CScript and a CmdExec job
> step instead.
> -Sue
> On Tue, 18 Nov 2003 03:16:08 -0800, "Madhu"
> <anonymous@.discussions.microsoft.com> wrote:
> >Hi,
> >
> >An ActiveX script has 42318 characters in a vbs file. We are trying to
use this .vbs file as a job step. We get this error message:
> >
> >--
> >Edit Job Step - 192.168.1.75\TrialJob
> >--
> >The specified file ('mailscripts\send_auto_con.vbs'), is 42318 characters
in size, which is larger than the available free space in the current Job
Step command (3200 characters).
> >Do you want to continue opening this file but have its contents
truncated.
> >--
> >Yes No
> >--
> >
> >Can we execute the vbs file as such? Can somebody help us with this
issue. Thanks in advance.
> >
> >regards,
> >
> >Madhu
>|||In a CmdExec step:
CScript.exe /NOLOGO C:\Scripts\YourVBScript.vbs
-Sue
On Tue, 18 Nov 2003 21:09:11 +0530, "Madhu"
<anonymous@.discussions.microsoft.com> wrote:
>Hi Sue,
>Thanks for the information, could you please elaborate on how we could
>achieve this? May be a code snippet or something that would help us.
>Thanks in advance,
>Madhu
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:9ebkrvool9ie3lq2gtmksanndfsd31u16f@.4ax.com...
>> Try executing the vbs file using CScript and a CmdExec job
>> step instead.
>> -Sue
>> On Tue, 18 Nov 2003 03:16:08 -0800, "Madhu"
>> <anonymous@.discussions.microsoft.com> wrote:
>> >Hi,
>> >
>> >An ActiveX script has 42318 characters in a vbs file. We are trying to
>use this .vbs file as a job step. We get this error message:
>> >
>> >--
>> >Edit Job Step - 192.168.1.75\TrialJob
>> >--
>> >The specified file ('mailscripts\send_auto_con.vbs'), is 42318 characters
>in size, which is larger than the available free space in the current Job
>Step command (3200 characters).
>> >Do you want to continue opening this file but have its contents
>truncated.
>> >--
>> >Yes No
>> >--
>> >
>> >Can we execute the vbs file as such? Can somebody help us with this
>issue. Thanks in advance.
>> >
>> >regards,
>> >
>> >Madhu
>|||Thanks Sue,
It worked fine. Thanks for your help.
Regards,
Madhu
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:1efkrv8mqqpch05hnp4arl0gbl3gu00fnf@.4ax.com...
> In a CmdExec step:
> CScript.exe /NOLOGO C:\Scripts\YourVBScript.vbs
> -Sue
> On Tue, 18 Nov 2003 21:09:11 +0530, "Madhu"
> <anonymous@.discussions.microsoft.com> wrote:
> >Hi Sue,
> >
> >Thanks for the information, could you please elaborate on how we could
> >achieve this? May be a code snippet or something that would help us.
> >
> >Thanks in advance,
> >
> >Madhu
> >
> >"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> >news:9ebkrvool9ie3lq2gtmksanndfsd31u16f@.4ax.com...
> >> Try executing the vbs file using CScript and a CmdExec job
> >> step instead.
> >>
> >> -Sue
> >>
> >> On Tue, 18 Nov 2003 03:16:08 -0800, "Madhu"
> >> <anonymous@.discussions.microsoft.com> wrote:
> >>
> >> >Hi,
> >> >
> >> >An ActiveX script has 42318 characters in a vbs file. We are trying to
> >use this .vbs file as a job step. We get this error message:
> >> >
> >> >--
> >> >Edit Job Step - 192.168.1.75\TrialJob
> >> >--
> >> >The specified file ('mailscripts\send_auto_con.vbs'), is 42318
characters
> >in size, which is larger than the available free space in the current Job
> >Step command (3200 characters).
> >> >Do you want to continue opening this file but have its contents
> >truncated.
> >> >--
> >> >Yes No
> >> >--
> >> >
> >> >Can we execute the vbs file as such? Can somebody help us with this
> >issue. Thanks in advance.
> >> >
> >> >regards,
> >> >
> >> >Madhu
> >>
> >
>

Job step command box can hold only 3200 characters

I could not load a batch file into the command box of a job step because it
exceeded the 3200 character limit. How do I increase this limit?
Mucho gracias.
LaEsmeraldaUse another job step.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"LaEsmeralda" <LaEsmeralda@.discussions.microsoft.com> wrote in message
news:B53AE718-D28F-473F-B347-D547D1072A2D@.microsoft.com...
>I could not load a batch file into the command box of a job step because it
> exceeded the 3200 character limit. How do I increase this limit?
> Mucho gracias.
> LaEsmeralda

Job step command box can hold only 3200 characters

I could not load a batch file into the command box of a job step because it
exceeded the 3200 character limit. How do I increase this limit?
Mucho gracias.
LaEsmeraldaUse another job step.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"LaEsmeralda" <LaEsmeralda@.discussions.microsoft.com> wrote in message
news:B53AE718-D28F-473F-B347-D547D1072A2D@.microsoft.com...
>I could not load a batch file into the command box of a job step because it
> exceeded the 3200 character limit. How do I increase this limit?
> Mucho gracias.
> LaEsmeraldasql

Job step command box can hold only 3200 characters

I could not load a batch file into the command box of a job step because it
exceeded the 3200 character limit. How do I increase this limit?
Mucho gracias.
LaEsmeralda
Use another job step.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"LaEsmeralda" <LaEsmeralda@.discussions.microsoft.com> wrote in message
news:B53AE718-D28F-473F-B347-D547D1072A2D@.microsoft.com...
>I could not load a batch file into the command box of a job step because it
> exceeded the 3200 character limit. How do I increase this limit?
> Mucho gracias.
> LaEsmeralda

Job Sequencing ?

I have a job that runs a batch file, tsql step, and then another batch file.
My question is will the agent say the first step is complete and move on
when it starts the batch file or will it know to wait until after the batch
has ran to start the second step?
TIA
--
nivekHi
It waits for the prior step to finish.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"nivek" <eckart_612@.hotmail.com> wrote in message
news:36GdnYIXz77QzN3fRVn-3A@.centurytel.net...
> I have a job that runs a batch file, tsql step, and then another batch
file.
> My question is will the agent say the first step is complete and move on
> when it starts the batch file or will it know to wait until after the
batch
> has ran to start the second step?
> TIA
> --
> nivek
>
>
>

Job Sequencing ?

I have a job that runs a batch file, tsql step, and then another batch file.
My question is will the agent say the first step is complete and move on
when it starts the batch file or will it know to wait until after the batch
has ran to start the second step?
TIA
nivekHi
It waits for the prior step to finish.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"nivek" <eckart_612@.hotmail.com> wrote in message
news:36GdnYIXz77QzN3fRVn-3A@.centurytel.net...
> I have a job that runs a batch file, tsql step, and then another batch
file.
> My question is will the agent say the first step is complete and move on
> when it starts the batch file or will it know to wait until after the
batch
> has ran to start the second step?
> TIA
> --
> nivek
>
>
>

Job Sequencing ?

I have a job that runs a batch file, tsql step, and then another batch file.
My question is will the agent say the first step is complete and move on
when it starts the batch file or will it know to wait until after the batch
has ran to start the second step?
TIA
nivek
Hi
It waits for the prior step to finish.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"nivek" <eckart_612@.hotmail.com> wrote in message
news:36GdnYIXz77QzN3fRVn-3A@.centurytel.net...
> I have a job that runs a batch file, tsql step, and then another batch
file.
> My question is will the agent say the first step is complete and move on
> when it starts the batch file or will it know to wait until after the
batch
> has ran to start the second step?
> TIA
> --
> nivek
>
>
>
sql

Job Schedules Not Schedu;ling

I can execute the following file to create jobs/ job
steps/ and related job schedules in SQL Analyzer ...
however the job is never scheduled. I can not identify
anything that is incorrect.
The commands process properly... and I can browse the
resulting msdb table entries in sys_jobs, sys_jobsteps,
and sys_jobschedules... however nothing ever gets
scheduled.
Please provide assistance where appropriate.
USE MSDB
EXEC sp_add_job
@.job_name='MailPointDBEmailFTCTPopulation',
@.enabled=1,
@.notify_level_eventlog=3
EXEC sp_add_jobstep
@.job_name='MailPointDBEmailFTCTPopulation',
@.step_name='EmailFTCTPopulation',
@.subsystem='TSQL',
@.command='EXEC sp_fulltext_table Email, ''update_index'''
EXEC sp_add_jobschedule
@.job_name='MailPointDBEmailFTCTPopulation',
@.name='MailPointDBEmailFTCTPopulation',
@.enabled=1,
@.freq_type=4,
@.freq_interval=1,
@.active_start_time=183000
EXEC sp_add_job
@.job_name='MailPointDBDocumentFTCTPopulation',
@.enabled=1,
@.notify_level_eventlog=3
EXEC sp_add_jobstep
@.job_name='MailPointDBDocumentFTCTPopulation',
@.step_name='DocumentFTCTPopulation',
@.subsystem='TSQL',
@.command='EXEC sp_fulltext_table
Document, ''update_index'''
EXEC sp_add_jobschedule
@.job_name='MailPointDBDocumentFTCTPopulation',
@.name='MailPointDBDocumentFTCTPopulation',
@.enabled=1,
@.freq_type=4,
@.freq_interval=1,
@.active_start_time=183000
GOis agent running on your server ?
jobi
"Philip" <plippard@.nc.rr.com> wrote in message
news:154f01c35247$39bb07a0$a001280a@.phx.gbl...
> I can execute the following file to create jobs/ job
> steps/ and related job schedules in SQL Analyzer ...
> however the job is never scheduled. I can not identify
> anything that is incorrect.
> The commands process properly... and I can browse the
> resulting msdb table entries in sys_jobs, sys_jobsteps,
> and sys_jobschedules... however nothing ever gets
> scheduled.
> Please provide assistance where appropriate.
> USE MSDB
> EXEC sp_add_job
> @.job_name='MailPointDBEmailFTCTPopulation',
> @.enabled=1,
> @.notify_level_eventlog=3
> EXEC sp_add_jobstep
> @.job_name='MailPointDBEmailFTCTPopulation',
> @.step_name='EmailFTCTPopulation',
> @.subsystem='TSQL',
> @.command='EXEC sp_fulltext_table Email, ''update_index'''
> EXEC sp_add_jobschedule
> @.job_name='MailPointDBEmailFTCTPopulation',
> @.name='MailPointDBEmailFTCTPopulation',
> @.enabled=1,
> @.freq_type=4,
> @.freq_interval=1,
> @.active_start_time=183000
> EXEC sp_add_job
> @.job_name='MailPointDBDocumentFTCTPopulation',
> @.enabled=1,
> @.notify_level_eventlog=3
> EXEC sp_add_jobstep
> @.job_name='MailPointDBDocumentFTCTPopulation',
> @.step_name='DocumentFTCTPopulation',
> @.subsystem='TSQL',
> @.command='EXEC sp_fulltext_table
> Document, ''update_index'''
> EXEC sp_add_jobschedule
> @.job_name='MailPointDBDocumentFTCTPopulation',
> @.name='MailPointDBDocumentFTCTPopulation',
> @.enabled=1,
> @.freq_type=4,
> @.freq_interval=1,
> @.active_start_time=183000
> GO
>

job schedule, dts

I have made an dts package which takes an *.txt file and imports it into an
table in my database, it get′s the *.txt file from another server on a
mapping o\\server\folder and it works fine but when i schedule the packag to
run every night it fails? i can browse to the file in explorer and i have
used the same account on the sqlserver service and sqlagent service!!
This is the error i get?
Executed as user: oden\admincrm. ...art: Delete from Table
[Salesmaker].[dbo].[salesmakerkund] Step DTSRun OnFinish: Delete from
Table [Salesmaker].[dbo].[salesmakerkund] Step DTSRun OnStart: Copy Data
from ESMKND to [Salesmaker].[dbo].[salesmakerkund] Step DTSRun OnError:
Copy Data from ESMKND to [Salesmaker].[dbo].[salesmakerkund] Step, Error =
-2147467259 (80004005) Error string: Error opening datafile: The syste
m
cannot find the path specified. Error source: Microsoft Data
Transformation Services Flat File Rowset Provider Help file:
DTSFFile.hlp Help context: 0 Error Detail Records: Error: 3
(3); Provider Error: 3 (3) Error string: Error opening datafile: The
system cannot find the path specified. Error source: Microsoft Data
Transformation Services Flat File Rowset Provider Help file:
DTSFFile.hlp Help context: 0 DTSRun OnFinish: Copy Data from
ESMKND to [Salesmaker].[dbo].[s... Process Exit Code 1. The step failed.Hi
Did you map the drive when you were logged in with the SQL Server service
account? Looks like the mapping is for your user and not SQL Service Account
Why don't you jut use an UNC path? It is more portable and works
(\servername\sharename\filename)
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"LeSurfer" <LeSurfer@.discussions.microsoft.com> wrote in message
news:41483A22-45E5-4E81-8367-ABEC1AF17CE3@.microsoft.com...
>I have made an dts package which takes an *.txt file and imports it into an
> table in my database, it gets the *.txt file from another server on a
> mapping o\\server\folder and it works fine but when i schedule the packag
> to
> run every night it fails? i can browse to the file in explorer and i
> have
> used the same account on the sqlserver service and sqlagent service!!
> This is the error i get?
> Executed as user: oden\admincrm. ...art: Delete from Table
> [Salesmaker].[dbo].[salesmakerkund] Step DTSRun OnFinish: Delete from
> Table [Salesmaker].[dbo].[salesmakerkund] Step DTSRun OnStart: Copy
> Data
> from ESMKND to [Salesmaker].[dbo].[salesmakerkund] Step DTSRun OnError:
> Copy Data from ESMKND to [Salesmaker].[dbo].[salesmakerkund] Step, Error =
> -2147467259 (80004005) Error string: Error opening datafile: The
> system
> cannot find the path specified. Error source: Microsoft Data
> Transformation Services Flat File Rowset Provider Help file:
> DTSFFile.hlp Help context: 0 Error Detail Records: Error:
> 3
> (3); Provider Error: 3 (3) Error string: Error opening datafile:
> The
> system cannot find the path specified. Error source: Microsoft
> Data
> Transformation Services Flat File Rowset Provider Help file:
> DTSFFile.hlp Help context: 0 DTSRun OnFinish: Copy Data from
> ESMKND to [Salesmaker].[dbo].[s... Process Exit Code 1. The step failed.
>|||LeSurfer,
Check out:
http://support.microsoft.com/defaul...kb;en-us;269074
HTH
Jerry
"LeSurfer" <LeSurfer@.discussions.microsoft.com> wrote in message
news:41483A22-45E5-4E81-8367-ABEC1AF17CE3@.microsoft.com...
>I have made an dts package which takes an *.txt file and imports it into an
> table in my database, it gets the *.txt file from another server on a
> mapping o\\server\folder and it works fine but when i schedule the packag
> to
> run every night it fails? i can browse to the file in explorer and i
> have
> used the same account on the sqlserver service and sqlagent service!!
> This is the error i get?
> Executed as user: oden\admincrm. ...art: Delete from Table
> [Salesmaker].[dbo].[salesmakerkund] Step DTSRun OnFinish: Delete from
> Table [Salesmaker].[dbo].[salesmakerkund] Step DTSRun OnStart: Copy
> Data
> from ESMKND to [Salesmaker].[dbo].[salesmakerkund] Step DTSRun OnError:
> Copy Data from ESMKND to [Salesmaker].[dbo].[salesmakerkund] Step, Error =
> -2147467259 (80004005) Error string: Error opening datafile: The
> system
> cannot find the path specified. Error source: Microsoft Data
> Transformation Services Flat File Rowset Provider Help file:
> DTSFFile.hlp Help context: 0 Error Detail Records: Error:
> 3
> (3); Provider Error: 3 (3) Error string: Error opening datafile:
> The
> system cannot find the path specified. Error source: Microsoft
> Data
> Transformation Services Flat File Rowset Provider Help file:
> DTSFFile.hlp Help context: 0 DTSRun OnFinish: Copy Data from
> ESMKND to [Salesmaker].[dbo].[s... Process Exit Code 1. The step failed.
>

JOb running SSIS package

I have an issue when a job is scheduled to run a SSIS package. The package (exporte a table to a text file) runs fine from microsoft visual studio but when i create a job and run it, i get the following error:

[298] SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'VOLCANO\Administrator', error code 0x534. [SQLSTATE 42000] (ConnIsLoginSysAdmin)

Can you tell me what operating system you have? Windows 2000, Windows 2003?

Thanks
Ovidiu Burlacu

|||i'm using windows 2003. I found out what was wrong, when I create the job i changed the owner to 'sa' instead and it now works fine. Thanks for your help anyway.
|||when i turn on the computer i get error messages about an open file? everything listed in the menu includes this axel but i canoot open it and I need to fix this error, it is preventing me from installing a camera. any help?

|||

This forum (and the error above) is for SQL Server Integration Services - is your question related to that?

JOb running SSIS package

I have an issue when a job is scheduled to run a SSIS package. The package (exporte a table to a text file) runs fine from microsoft visual studio but when i create a job and run it, i get the following error:

[298] SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'VOLCANO\Administrator', error code 0x534. [SQLSTATE 42000] (ConnIsLoginSysAdmin)

Can you tell me what operating system you have? Windows 2000, Windows 2003?

Thanks
Ovidiu Burlacu

|||i'm using windows 2003. I found out what was wrong, when I create the job i changed the owner to 'sa' instead and it now works fine. Thanks for your help anyway.|||when i turn on the computer i get error messages about an open file? everything listed in the menu includes this axel but i canoot open it and I need to fix this error, it is preventing me from installing a camera. any help?

|||

This forum (and the error above) is for SQL Server Integration Services - is your question related to that?