>>I just discovered the awesomeness that is SQL Bulk Insert. In theory I can use that to create a stored procedure to load a table from a file.
>>
>>Now I'm wondering if there is a way to extract from a view to a flat data file from a query also. Anybody have any examples?
>
>Look at DTS and/or BCP.
Sergey,
Is BCP something I can call from a query (I want to encapsulate my logic into a Stored Procedure) or is it strictly command line?