Scheduling SQL / ASP

Hi,
I've been asked to help with the automation of a nightly flat file
extraction of data from a SQL server (I think it's MS SQL 2000), i.e.
producing a text file containing specific data.
I have read previously in other news groups methods of scheduling ASP
pages/VB
scripts that could accomplish this task.
Is it possible to achieve this solely via the SQL server instead of using
ASP/VB scripts?
Thanks, Dominic
Check out Jobs in the BOL. Each job can have multiple steps and multiple
schedules. Each step can be VBScript or T-SQL or OS command or ...
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Dominic Marsat" <djmarsatAThotmail.com> wrote in message
news:eqXtuuGKEHA.2380@.TK2MSFTNGP09.phx.gbl...
Hi,
I've been asked to help with the automation of a nightly flat file
extraction of data from a SQL server (I think it's MS SQL 2000), i.e.
producing a text file containing specific data.
I have read previously in other news groups methods of scheduling ASP
pages/VB
scripts that could accomplish this task.
Is it possible to achieve this solely via the SQL server instead of using
ASP/VB scripts?
Thanks, Dominic

Scheduling SQL / ASP

Hi,
I've been asked to help with the automation of a nightly flat file
extraction of data from a SQL server (I think it's MS SQL 2000), i.e.
producing a text file containing specific data.
I have read previously in other news groups methods of scheduling ASP
pages/VB
scripts that could accomplish this task.
Is it possible to achieve this solely via the SQL server instead of using
ASP/VB scripts?
Thanks, DominicCheck out Jobs in the BOL. Each job can have multiple steps and multiple
schedules. Each step can be VBScript or T-SQL or OS command or ...
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Dominic Marsat" <djmarsatAThotmail.com> wrote in message
news:eqXtuuGKEHA.2380@.TK2MSFTNGP09.phx.gbl...
Hi,
I've been asked to help with the automation of a nightly flat file
extraction of data from a SQL server (I think it's MS SQL 2000), i.e.
producing a text file containing specific data.
I have read previously in other news groups methods of scheduling ASP
pages/VB
scripts that could accomplish this task.
Is it possible to achieve this solely via the SQL server instead of using
ASP/VB scripts?
Thanks, Dominicsql

Scheduling SQL / ASP

Hi,
I've been asked to help with the automation of a nightly flat file
extraction of data from a SQL server (I think it's MS SQL 2000), i.e.
producing a text file containing specific data.
I have read previously in other news groups methods of scheduling ASP
pages/VB
scripts that could accomplish this task.
Is it possible to achieve this solely via the SQL server instead of using
ASP/VB scripts?
Thanks, DominicCheck out Jobs in the BOL. Each job can have multiple steps and multiple
schedules. Each step can be VBScript or T-SQL or OS command or ...
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Dominic Marsat" <djmarsatAThotmail.com> wrote in message
news:eqXtuuGKEHA.2380@.TK2MSFTNGP09.phx.gbl...
Hi,
I've been asked to help with the automation of a nightly flat file
extraction of data from a SQL server (I think it's MS SQL 2000), i.e.
producing a text file containing specific data.
I have read previously in other news groups methods of scheduling ASP
pages/VB
scripts that could accomplish this task.
Is it possible to achieve this solely via the SQL server instead of using
ASP/VB scripts?
Thanks, Dominic

schedule package

I am trying to create a job to automatically execute a package.The package was created by use of the wizard.It’s very simple…export a view to a flat file.If I run the package as is it generated the file.However when I create a job and try to run the job it errors out with package cannot be found even though the path of the dtsx file is correct.

Shouldn’t I be able to schedule a package which was created by the wizard?Do you have any idea when I’d get a msg that package cannot be found even though the path is correct?

Please let me know your thoughts on this issue…I am at a lost.

Thanks,

Nats

Did you promote the package to the server where SQL Server Agent exists? (I assume you're using SQL Server Agent)|||Yes I am using SQL Server Agent. What do you mean "promote the package to the server"?|||Well, the package has to be on the server where SQL Server Agent is running.

If you developed the package on your desktop and are using SQL Server Agent on another machine, the package has to be moved to that machine.

If you do have it on the same machine, then you have to be sure that SQL Server Agent has access to the folder/file.|||

The package was save to my desktop...once i moved it out to the server it works fine.

Thanks for the the advise.