Question

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

Answer 1

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

Answer 2

Yes, it is possible to import data directly from T-SQL commands without using SQL Server Integration Services.  These commands include,

1. BCP
2. OpenRowSet
3. Bulk Insert
4. OPENQUERY
5. OPENDATASOURCE
6. Linked Servers