If you want to import data only through a T-SQL query, then use the OPENDATASOURCE function. To repeatedly get data from another server, create a linked server and then use the OPENQUERY function or use 4-part naming. If you are not using T-SQL, then it is better to use the import/export wizard, and you can save it as a SSIS package for future use.

Thanks  for reading  this  article,

Next steps :

1.  Share this with your colleagues because Sharing  is Learning

        2. Comment below if you need any assistance

Powered by CodeReview – Let’s make it Better!