Amir Ayub


Hi,

Could you please help me to find easiest way to schedule daily auto data extraction time in SQL Server Express 2005 Edition (I need to put time to load data every day).

Thanks

Amir





Re: Auto Data Extraction through ODBC

Andrea Montanari


hi Amir,

please excuse my poor english, but can you please rephrase your question

thank you and regards







Re: Auto Data Extraction through ODBC

Arnie Rowland

For SQL Express, you would most likely need to do the following:

1. Create a script file using bcp to unload the data.

2. Use SQLCmd.exe to run the script file

3. Use Windows Scheduler to execute SQLCmd.exe on a time schedule.

Look up using [ bcp ] in books Online

Look up using SQLCmd.exe in Books Online.

Look up using Windows Scheduler in Windows Help.







Re: Auto Data Extraction through ODBC

Amir Ayub

Hi,

Thanks for your reply, I have gone through BCP link http://msdn2.microsoft.com/en-us/library/ms162802.aspx, I am wondering if you can provide a link of Sample "Sample Script of BCP to import" it would be great help for me.

Thanks

Amir






Re: Auto Data Extraction through ODBC

Arnie Rowland

Perhaps this will help you.

http://msdn2.microsoft.com/en-us/library/aa173839(SQL.80).aspx






Re: Auto Data Extraction through ODBC

Amir Ayub

Thanks for info.

It might be a silly question for you but I am using first time and I have no idea could you please define below alsoSmile

a) Should I creat Batch file OR Text File for BCP

b) How should I run and test






Re: Auto Data Extraction through ODBC

Arnie Rowland

I normally consider a 'batch file' as an input source, and a 'text file' as an output source.

Look up bcp in Books Online, Topic: bcp Utility.

There are a couple of examples that will execute in your query window.