|
Posted by klimenkor@gmail.com on 04/09/07 18:17
On Apr 9, 7:27 am, "Designing Solutions WD"
<michael.grass...@gmail.com> wrote:
> Hello,
>
> I have some questions on my options available.
>
> I have to export some tables to csv files to enable another department
> to process the files. What I need is a way to do this in ms sql
> though a stored proc with quoted identifiers and column names as
> heads. I cannot figure out how to do this.
>
> Can anybody give me some options that would be the best options.
>
> I am using ms sql 2000.
>
> Thank you for your time.
The easiest solution that came to my head is to execute DTS package in
command shell. In DTS package you can define whatever format you want.
Create it. Debug it. Play with it. Then just add xp_cmdshell
'dtsrun.exe -S<server> -N<dts-package> -E -M<dts-password>' to your
procedure.
- Roman
Navigation:
[Reply to this message]
|