I have access to a SQL server and my rights are extremely limited.
I have been tasked with uploading 180 flat files. However, I can’t write a tsql script for bulk insert as I can’t access the file stores programmatically and I can’t run PowerShell. This is all because of admin access which I am never going to get.
Is there a convenient way to do this via SSMS? Or is the only option to go through 180 files and use the task import wizard ?