Exporting Job Based on Data -- sql server dts

Jessard
10/28/2004 7:07:02 PM

Hi all,

I'm not very familiar with SQL Server but I have a task I would like to
implement. I am not sure if it is possible but any feedback would be good.
I have a stored procedure which runs a simple query. I want to export the
results of this query to a text/csv file as a job. The frequency of the
files generated will be determined by an sql-condition returning true (eg. if
the count of another query = 1). It can be set to run daily but only on the
condition that this sql query is satisfied (which may occur every month
meaning it will in effect only run once a month). Hope this is clear. So
far I am able to export the stored procedure manually through the "Tools ->
Data Transformation Services -> Export Data" menu in Enterprise Manager.

Thanks,
Jesse

Allan Mitchell
10/29/2004 6:39:13 AM

OK So the export will never change in definition it is simply the amount of
times you want to run it.

You could, and I probably would change the definition of the JobSchedule.
You can either do this through DMO or through the stored procs.

Start here in BOL

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\tsqlref.chm::/ts_sp_adda_6ijp.htm

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know

[quoted text, click to view]

sql server dts : Exporting Job Based on Data