Hi Technies,

I would like to get the help from the experts of SQL Server. The current
requirement for me is "to import the data from the remote server" .

I have a SQL Server located in one particular network placed at a particular
location. I wanted to import the data from another different network located
in different geographical area.

The requirement of the data is that i need only certain fields from the
particular table of the database from the remote server.


I would like to get help in this regard. I want this to be scheduled so that
the data importing through the DTS will be done automatically on a daily
basis.

Hello Sasidar,

OK So can the two machines see each other? that's the first hurdle. Forget
doing anything with them right now, can they actually see each other?

If they can then you could use a SQL Server based login to log on to the
remote SQL Server

To get only what you need you would issue a SELECT statement

This would then be pulled across the network to the destination.

Are you looking for help also in how to build the package itself?

For scheduling things like this I guess a lot of use SQL Server Agent






Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Allan,

Thanks for replying the post.

I am able to access the remote server using the citrix client.

Also i am new to this can you tell me how to import the data from the remote
server by scheduling a job which will do automatically on a daily basis.

I have written a dts only with in the same network and that is being done
manually only at present

Awaiting for your earliest reply

Thanks

"Allan Mitchell" wrote:

Hello Sasidar,

You need to sit down with the Network Admin on the Server that needs to access
the remote server and make them see each other (not through Citrix)

After that.

To build the package you can start to have a look at this

Building a Package in the DTS Designer
(http://www.sqldts.com/default.aspx?278)

to schedule a package you can look here

http://support.microsoft.com/?kbid=269074


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Allan,
Thanks for responding so quickly.

I will ask the Network Admin to make both the computers see each other and
in case of any doubts i will post in this forum once again.

Thanks

"Allan Mitchell" wrote: