While researching using BCP in a stored procedure, the
that xp_cmdshell needs to be used.  I can not use
xp_cmdshell due to security reasons.

Is there any other way to use BCP in a stored procedure?



Thanks in advance.

Single to Multiple columns
Assistance with SQL Script
SQL 2005: Why does DECLARE varchar(MAX) in Stored Procedure not work?
HOW TO: PIVOT for unknown number of column headings?
Passing parameter from a recordset in a Stored Procedure