May 17, 2009 at 4:30 am
I want to make a procedure in which data from one table can be automatically stored in a text file daily at a specific time
plz guide.
May 17, 2009 at 4:41 am
Hello,
You could use the Export Wizard to perform the task once and save the procedure as an SSIS Package. There is an option to do this towards then end of the Wizard.
Schedule this SSIS Package to execute at the required interval with the SQL Server Agent.
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
May 17, 2009 at 5:38 am
can u plz explain how to do this...............???
May 17, 2009 at 5:57 am
Hello again,
In SSMS (SQL Server Management Studio) right click on your Database and select “Tasks”, “Export Data…”
You can then run through the screens of the (Import and) Export Wizard to perform a one-off data export. Towards then end of the Wizard you can save the steps as an SSIS Package.
You can execute the SSIS Package at any time to perform the data export repeatedly. As you want this to happen every day at a specific time, you can schedule this with SQL Server Agent.
In SSMS right click on SQLS Server Agent and select “New”, “Job…”.
Under the Steps Tab select “New”, then change the Type to “SQL Server Integrated Service Package” and fill in the details of your saved SSIS Package.
Under the Schedules Tab select “New”, then change the Occurs to “Daily” and then fill in the time you need.
Save the new Job and then you are ready for your testing process.
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
May 17, 2009 at 6:24 am
Thanks a lot!!!
I"ll try to do this.
May 17, 2009 at 6:31 am
one more issue, i hav a query which i want to be executed daily at a scheduled time.i think at that time,export data option willnot work becoz that will export the complete table.plz guide.
May 17, 2009 at 6:51 am
Hello again,
In the Export Wizard there is a screen called “Specify Table Copy or Query”. If you select the “Write a query to specify the data to transfer” you then get an input screen where you can paste in your Query.
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
May 17, 2009 at 9:11 am
Thanks again!!!
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply