|
|
You're in the
sql server dts
group:Data Importing From Remote Server
sql server dts:
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
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 [quoted text, click to view] > 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. >
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 [quoted text, click to view] "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. > > > >
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 [quoted text, click to view] > 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. >>>
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 [quoted text, click to view] "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. > >>> > >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |