Export data without bcp

Exporting data to a csv file is only possible with bcp,
using a shell command inside a query?!
You have to hardcoded connection information,
and it sound so strange, that I could not be true.
Any T-SQL alternatives to export data to csv file?
Thanks
Mitja Semolic
Technically you dont have to 'hard code' the connection information, but
yes, there are connection details that need to be passed into a bcp command.
Have you looked into DTS?
"Mitja Semolic" <mitja.semolic@.ensico.si> wrote in message
news:by6Zg.99$Ib3.91049@.news.siol.net...
> Exporting data to a csv file is only possible with bcp,
> using a shell command inside a query?!
> You have to hardcoded connection information,
> and it sound so strange, that I could not be true.
> Any T-SQL alternatives to export data to csv file?
> Thanks
> Mitja Semolic
>

Export data without bcp

Exporting data to a csv file is only possible with bcp,
using a shell command inside a query?!
You have to hardcoded connection information,
and it sound so strange, that I could not be true.
Any T-SQL alternatives to export data to csv file?
Thanks
Mitja SemolicTechnically you dont have to 'hard code' the connection information, but
yes, there are connection details that need to be passed into a bcp command.
Have you looked into DTS?
"Mitja Semolic" <mitja.semolic@.ensico.si> wrote in message
news:by6Zg.99$Ib3.91049@.news.siol.net...
> Exporting data to a csv file is only possible with bcp,
> using a shell command inside a query?!
> You have to hardcoded connection information,
> and it sound so strange, that I could not be true.
> Any T-SQL alternatives to export data to csv file?
> Thanks
> Mitja Semolic
>