Is it possible to import data using T-SQL commands without using SQL S

1.	Is it possible to import data using T-SQL commands without using SQL Server Integration Services? If yes, please share commands?
Answer» We need to run the SQL Server patch installation minimally 4 times to patch both SQL instance on all 3 cluster NODES. SQL 2005 - 1 installation, SQL 2005 support remote installation. SQL 2005 patch installation will install the patch on all cluster nodes in one go but only for cluster OBJECTS like DB engine or agent. SQL 2008 R2 – 3 installation, SQL 2008 R2 does not support remote installation. We need to patch all 3 nodes separately. Additionally, We may need to run SQL 2005 setup on other 2 nodes to patch non-cluster objects like SSMS but that’s the ADDITIONAL PART.

Is it possible to import data using T-SQL commands without using SQL Server Integration Services? If yes, please share commands?

Answer»

We need to run the SQL Server patch installation minimally 4 times to patch both SQL instance on all 3 cluster NODES.

SQL 2005 - 1 installation, SQL 2005 support remote installation. SQL 2005 patch installation will install the patch on all cluster nodes in one go but only for cluster OBJECTS like DB engine or agent.
SQL 2008 R2 – 3 installation, SQL 2008 R2 does not support remote installation. We need to patch all 3 nodes separately.

Additionally, We may need to run SQL 2005 setup on other 2 nodes to patch non-cluster objects like SSMS but that’s the ADDITIONAL PART.