How can I call a BCP command from within a stored procedure and embed it within a transaction?

Thanks in advance.