I've a minimal SQL Server installation in my desktop PC and a source text
file containig my orders.
From my desktop is it possible in DTS to channel data from my single source
text file to a remote destination table in a remote SQL Server?
In my network environment is forbidden to share folder.

Exists some example?

Thanks

You can push data from a text file on your local machine to a different
SQL Server.
Run the DTS package interactively - when you run the package it is run
on your machine under your credentials and will see the file on your drive.
This wouldn't work if you scheduled the package on a different server
though.

Simon Worth

andrea favero wrote:

I want to use a "Bulk Inser task", but in "Bulk Insert Task properties"
windows if I select a "existing connection" to a my remote server I can to
choose "source data file" only on remote SQL Server file system and not on my
PC file system.

How can I do to resolve my problem??

"Simon Worth" wrote: