How to import a . csv file to a Stored Procedure on SQL Server without using "BULK INSERT"?

Asked

Viewed 62 times

0

I am trying to perform an SP that lists the . csv files in a folder via the command

XP_CMDSHELL

And then imports the files. csv for an auxiliary table in the database, but I do not have permission to use bulk import (BULK INSERT).

What would be the best way to perform this import? Should I try to use an ETL model?

sql sql-server csv
No answers

Browser other questions tagged sql sql-server csv

You are not signed in. Login or sign up in order to post.