Re: Data Importing From Remote Server

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:

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 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,

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
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.




.

Relevant Pages

  • Re: network stalls on Fedora Core 3
    ... The remote server is inside our ... | stall, i.e., same motherboard, processor and network card. ... if you are experiencing packetloss for whatever ... Also, try to floodping an idle server on your network, and see how many ...
    (Fedora)
  • Re: [SLE] Connecting a tremial program to an external rs323 port
    ... The main remote server box is on the network... ... When the network backbone is down for some reason... ... you can connect the modem directly to the supervised ...
    (SuSE)
  • Re: how to tell where a network problem is?
    ... I'm looking for a way to get info reaches beyond my network. ... Lets say I replicate SQL Server data between 2 sql servers, ... connectivity to the remote server still. ... > If you're having problems with a WAN - can you call your WAN provider to ...
    (microsoft.public.win2000.networking)
  • Impersonation question
    ... I am trying to get a better understanding of how impersonation works and I ... I have read that one can't access resources on network shares while ... provide enough credentials to the remote server to allow the remote server ...
    (microsoft.public.security)
  • Re: How Do You Change the IP Address of the SBS 4.5 Server
    ... because a server has a number of services related to its IP address. ... the router. ... >>> it onto the 192.168.1.x network? ... >>> Allan C ...
    (microsoft.public.backoffice.smallbiz)
Loading