Import/Export Text File in Stored Procedure

Database
Enthusiast

Import/Export Text File in Stored Procedure

I did some searching, but did not find an answer.

Can I import and/or export a text file to a local client within a stored procedure, or even a query. I am using SQL Assistant 12, and publish reports in Reporting Services.

I would like the stored procedure to import and/or export a text file when the report is run on Reporting Services.

Is this possible? If it is not, can it be done in SQL Assistant?

Thanks