export data with SQL server 2005

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

export data with SQL server 2005

Author

Topic

tombino
Starting Member

26 Posts

Posted - 2007-05-27 : 23:48:42

Hi,

do someone know how can I schedule an "export data" job?
I have to write a script?

I appreciate your help. Thanks

Regards,
Tom

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-05-28 : 00:41:38

You can use the bcp command line util to export data.

see http://msdn2.microsoft.com/en-us/library/ms162802.aspx

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-28 : 12:23:37

Or use data export wizard.

tombino
Starting Member

26 Posts

Posted - 2007-05-29 : 01:25:34

but can i schedule the export data wizard? Is because I have to export data every day, so I want found a way to do it automatic if is possible.

I am trying the bcd command, I dont know what i am doing wrong but the out data is unreadable.
I need to export sql server 2005 tables to microsoft access tables.

Tom

tombino
Starting Member

26 Posts

Posted - 2007-05-29 : 01:49:37

I am trying this line:

bcp tbl_style out db.mdb -w -S (server name) -U (user name) - P (password)

to db.mdb is ureadable. I tryied also db.txt and the result is a mess...

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-05-29 : 01:53:17

you can't BCP to a Access Database.

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-05-29 : 01:58:04

Create an SSIS package and schedule it using SQL Agent.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

tombino
Starting Member

26 Posts

Posted - 2007-05-29 : 02:29:11

Thank you. I will try.
I never tryed to work with SSIS, I hope is easy.

Thanks
Tom