<div>
Again, I just want to say, I know its not clean.. but it should work given limited options.
</div>


Again, I just want to say, I know its not clean.. but it should work given limited options.

<div>
does this command removes the file from original server B
</div>


does this command removes the file from original server B

<div>
you can add a delete command to be run later. say 10am, or just set the commands to constantly overwrite the file names.<br />
your call..<br />
<br />
it just depends on how you want to do this.
</div>


you can add a delete command to be run later. say 10am, or just set the commands to constantly overwrite the file names.
your call..

it just depends on how you want to do this.

<div>
If the idea it's to import data from a file to a table SSMS already provide this functionality.<br />
Just right-click over the database name, choose Tasks / Import data... and follow the wizard.
</div>


If the idea it's to import data from a file to a table SSMS already provide this functionality.
Just right-click over the database name, choose Tasks / Import data... and follow the wizard.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have a test file in server A and my DB server is in server B.<br />
Now I want to write query in SSMS from Server B and that query should access the file from server A and parse it to store the data in DB.<br />
<br />
I am not sure how to establish the connection to server B and get that file.<br />
I am trying to write a stored procedure for this.<br />
No I should not copy that file.<br />
<br />
So any suggestions how to get that file from server B to DB server A.<br />
<br />
Thanks,
</div>
</div>


Hi,

I have a test file in server A and my DB server is in server B.
Now I want to write query in SSMS from Server B and that query should access the file from server A and parse it to store the data in DB.

I am not sure how to establish the connection to server B and get that file.
I am trying to write a stored procedure for this.
No I should not copy that file.

So any suggestions how to get that file from server B to DB server A.

Thanks,

sql to access file in different server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.