VietMX's Blog

Is it possible to import data directly from T-SQL commands without using SQL Server Integration Services? If so, what are the commands?

Technology Community › Category: T-SQL › Is it possible to import data directly from T-SQL commands without using SQL Server Integration Services? If so, what are the commands?
0 Vote Up Vote Down
VietMX Staff asked 3 years ago

Yes – Six commands are available to import data directly in the T-SQL language.  These commands include:

  • BCP
  • Bulk Insert
  • OpenRowSet
  • OPENDATASOURCE
  • OPENQUERY
  • Linked Servers
Question Tags: ,

DMCA.com Protection Status