Remote Connection to SQL-Server for data extract I have zero experience with MSSQL Server, but I'm trying to determine the most effective way to extract data from table into flat files from a remote location.
Here's the usage case scenario:

We are a data-integration company and we have some customers who run software ( ERP ) on top of a MS SQL Server. The ERP vendor previously supported a extract and delivery process directly to our ( company ) location. The ERP company has now become unresponsive to our ongoing extract issues ( bugs ) and we're preparing for the possibility of losing customers as a result (even though we have a contract with the software company).

I'm assuming that there's a way for us to connect directly to the MSSQL server and extract the data, bypassing the ERP vendor extract solution altogether, but I'm not familiar w/ MSSQL or Connections / Connectors at all.

Would anyone be willing to share with me if this sort of thing is possible and what the best route for me to continue my research might be?
As @FutbolFan said, best approach is to use SSIS (which takes a bit more time) or SQL Server Import/Export Wizard (the feasible option, in your case).


Right Click on the Database in question ans Select Tasks -> Export Data (the wizard will open up)
Select The Database in question as your source (might have to switch between SQL 10.0 or 11.0 depending on your version.
Select Flat File as your destination.  You'll be able to customize your delimiters and text qualifiers here
Select the Object you want to export.  You can do this by using the Object selector, or by using a custom query.  Up to you.
Run the package for each table you want to export, verify your results.