I was wanting to know how do I save an import query in SQL Server Management Studio v18.4 so that way I don't have to keep going through the steps each time I want to import a new version of the same file.
If you need to do the import over and over then consider writing it using bcp or BULK INSERT. If you really prefer to use the GUI then follow this article and post back if you're struggling with a particular part of it. I seem to remember you may only be able to save the package if you have SSIS installed.
John
This reply was modified 4 years, 4 months ago by John Mitchell-245523. Reason: Added link to the article I mentioned
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply