I would like to update my tables in the local SQL 2005 server with the data
from the tables from an SQL database on the internet.

I used to do this with Data transformation services, but this seems not be
running in SQL2005.

Other solutions how to to this?

Thanks,
Hans

Make sure you have SP2 locally. You should still see the same kinds of
wizards if you right-click a database in Management Studio and choose Tasks
> Import Data or Tasks > Export Data. There is still a DTS-like thing that
they renamed to SSIS (SQL Server Integration Services).

A


On 5/19/08 10:54 AM, in article
48319495$0$6006$ba620dc5@text.nova.planet.nl, "Hans" <info@tct.nl> wrote:

> I would like to update my tables in the local SQL 2005 server with the data
> from the tables from an SQL database on the internet.
>
> I used to do this with Data transformation services, but this seems not be
> running in SQL2005.
>
> Other solutions how to to this?
>
> Thanks,
> Hans
>
>

As long as you can access the SQL instance, it really doesn't matter--for
what you want to do--whether it is on the internet or right next to the other
machine.

Linchi

"Hans" wrote:

> I would like to update my tables in the local SQL 2005 server with the data
> from the tables from an SQL database on the internet.
>
> I used to do this with Data transformation services, but this seems not be
> running in SQL2005.
>
> Other solutions how to to this?
>
> Thanks,
> Hans
>
>
>

Where can I find this tool SSIS on the server?

Hans


"Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> schreef in
bericht news:C4570FC0.564B%ten.xoc@dnartreb.noraa...
> Make sure you have SP2 locally. You should still see the same kinds of
> wizards if you right-click a database in Management Studio and choose
> Tasks
>> Import Data or Tasks > Export Data. There is still a DTS-like thing that
> they renamed to SSIS (SQL Server Integration Services).
>
> A
>
>
> On 5/19/08 10:54 AM, in article
> 48319495$0$6006$ba620dc5@text.nova.planet.nl, "Hans" <info@tct.nl> wrote:
>
>> I would like to update my tables in the local SQL 2005 server with the
>> data
>> from the tables from an SQL database on the internet.
>>
>> I used to do this with Data transformation services, but this seems not
>> be
>> running in SQL2005.
>>
>> Other solutions how to to this?
>>
>> Thanks,
>> Hans
>>
>>
>

I understand but I need tools to copy merge/compare both databases/tables
etc. based on time schedules

Hans

"Linchi Shea" <LinchiShea@discussions.microsoft.com> schreef in bericht
news:4491E185-D3F2-4998-ACC5-611BE093DA16@microsoft.com...
> As long as you can access the SQL instance, it really doesn't matter--for
> what you want to do--whether it is on the internet or right next to the
> other
> machine.
>
> Linchi
>
> "Hans" wrote:
>
>> I would like to update my tables in the local SQL 2005 server with the
>> data
>> from the tables from an SQL database on the internet.
>>
>> I used to do this with Data transformation services, but this seems not
>> be
>> running in SQL2005.
>>
>> Other solutions how to to this?
>>
>> Thanks,
>> Hans
>>
>>
>>

"Hans" <info@tct.nl> wrote in message
news:4833e664$0$6014$ba620dc5@text.nova.planet.nl. ..
>I understand but I need tools to copy merge/compare both databases/tables
>etc. based on time schedules
>
> Hans
>
> "Linchi Shea" <LinchiShea@discussions.microsoft.com> schreef in bericht
> news:4491E185-D3F2-4998-ACC5-611BE093DA16@microsoft.com...
>> As long as you can access the SQL instance, it really doesn't matter--for
>> what you want to do--whether it is on the internet or right next to the
>> other
>> machine.
>>
>> Linchi
>>
>> "Hans" wrote:
>>
>>> I would like to update my tables in the local SQL 2005 server with the
>>> data
>>> from the tables from an SQL database on the internet.
>>>
>>> I used to do this with Data transformation services, but this seems not
>>> be
>>> running in SQL2005.
>>>
>>> Other solutions how to to this?
>>>
>>> Thanks,
>>> Hans
>>>
>>>
>>>

Hi

SSIS is a service that runs on your database server. It is not available in
SQLExpress. You can create packages using the SQL Server Business
Intelligence Development Studio (BIDS).

What you are trying to do sounds like a manual replication, have you checked
out what replication can give you?

John

Did you try following my instructions, using Management Studio? Right-click
a database, Tasks > Import Data? Or right-click a database, Tasks > Export
Data?





"Hans" <info@tct.nl> wrote in message
news:4833e629$0$6024$ba620dc5@text.nova.planet.nl. ..
> Where can I find this tool SSIS on the server?
>
> Hans

What is manual replication?
What I need is to transfer the actual data from tables from an internet SQL
database to local tables in SQL2005 database, based on time schedules.

That's all. An with the DTS in SQL 2000 you could drag and drop that and it
worked fine.

Hans



"John Bell" <jbellnewsposts@hotmail.com> schreef in bericht
news:AA755C36-56FD-42E0-BE3A-D324DD92B078@microsoft.com...
>
> "Hans" <info@tct.nl> wrote in message
> news:4833e664$0$6014$ba620dc5@text.nova.planet.nl. ..
>>I understand but I need tools to copy merge/compare both databases/tables
>>etc. based on time schedules
>>
>> Hans
>>
>> "Linchi Shea" <LinchiShea@discussions.microsoft.com> schreef in bericht
>> news:4491E185-D3F2-4998-ACC5-611BE093DA16@microsoft.com...
>>> As long as you can access the SQL instance, it really doesn't
>>> matter--for
>>> what you want to do--whether it is on the internet or right next to the
>>> other
>>> machine.
>>>
>>> Linchi
>>>
>>> "Hans" wrote:
>>>
>>>> I would like to update my tables in the local SQL 2005 server with the
>>>> data
>>>> from the tables from an SQL database on the internet.
>>>>
>>>> I used to do this with Data transformation services, but this seems not
>>>> be
>>>> running in SQL2005.
>>>>
>>>> Other solutions how to to this?
>>>>
>>>> Thanks,
>>>> Hans
>>>>
>>>>
>>>>
>
> Hi
>
> SSIS is a service that runs on your database server. It is not available
> in SQLExpress. You can create packages using the SQL Server Business
> Intelligence Development Studio (BIDS).
>
> What you are trying to do sounds like a manual replication, have you
> checked out what replication can give you?
>
> John

Thats one of the functions I know but it should be based on automatically
time schedules.

Hans

"Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> schreef in
bericht news:u4IYu5zuIHA.1316@TK2MSFTNGP06.phx.gbl...
> Did you try following my instructions, using Management Studio?
> Right-click a database, Tasks > Import Data? Or right-click a database,
> Tasks > Export Data?
>
>
>
>
>
> "Hans" <info@tct.nl> wrote in message
> news:4833e629$0$6024$ba620dc5@text.nova.planet.nl. ..
>> Where can I find this tool SSIS on the server?
>>
>> Hans
>
>

OK, did you install Integration Services when you installed SQL Server? If
not, you will need to go back through setup I think (it is one of the main
components).



"Hans" <info@tct.nl> wrote in message
news:4835244d$0$6032$ba620dc5@text.nova.planet.nl. ..
> Thats one of the functions I know but it should be based on automatically
> time schedules.
>
> Hans

I installed as much as possible
I now have in Start Menu:
-Sub Analysis services
-Sub Configuration tools
-Sub doc and tutorials
-Business Intell Dvelopment Studio
-Server Management Studio (this looks like the SQL 2000 program, but DTS
doesn't work here)

Hans

"Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> schreef in
bericht news:OCrT5nBvIHA.4376@TK2MSFTNGP06.phx.gbl...
> OK, did you install Integration Services when you installed SQL Server?
> If not, you will need to go back through setup I think (it is one of the
> main components).
>
>
>
> "Hans" <info@tct.nl> wrote in message
> news:4835244d$0$6032$ba620dc5@text.nova.planet.nl. ..
>> Thats one of the functions I know but it should be based on automatically
>> time schedules.
>>
>> Hans
>
>

What does "DTS doesn't work here" mean? How are you trying to "make DTS
work"?

If you have Integration Services (the new version of DTS!) installed, you
should be able to connect to the local instance by opening Management
Studio, opening Object Explorer (F8), and clicking Connect > Integration
Services.

There are many SSIS tutorials and sites out there... You should use Google
and/or visit the Integration Services newsgroup (both to learn more about it
and to determine if it's really what you want to use in this case).


On 5/22/08 12:14 PM, in article
48359c04$0$6011$ba620dc5@text.nova.planet.nl, "Hans" <info@tct.nl> wrote:

> I installed as much as possible
> I now have in Start Menu:
> -Sub Analysis services
> -Sub Configuration tools
> -Sub doc and tutorials
> -Business Intell Dvelopment Studio
> -Server Management Studio (this looks like the SQL 2000 program, but DTS
> doesn't work here)
>
> Hans
>
> "Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> schreef in
> bericht news:OCrT5nBvIHA.4376@TK2MSFTNGP06.phx.gbl...
>> OK, did you install Integration Services when you installed SQL Server?
>> If not, you will need to go back through setup I think (it is one of the
>> main components).
>>
>>
>>
>> "Hans" <info@tct.nl> wrote in message
>> news:4835244d$0$6032$ba620dc5@text.nova.planet.nl. ..
>>> Thats one of the functions I know but it should be based on automatically
>>> time schedules.
>>>
>>> Hans
>>
>>
>
>

I installed everything and checked the setup again
I Found your Connect > Integration > Services buto then got following error:

===================================

Cannot connect to BALLSERVER.

===================================

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

------------------------------
For , click:
http://go.microsoft.com/fwlink?ProdN...r&LinkId=20476

------------------------------
Program Location:

at Microsoft.SqlServer.Management.Smo.Enumerator.Proc ess(Object
connectionInfo, Request request)
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.ObjectExplorer.ValidateConnection(UIC onnectionInfo
ci, IServerType server)
at
Microsoft.SqlServer.Management.UI.ConnectionDlg.Co nnector.ConnectionThreadUser()

===================================

Connect to SSIS Service on machine "BALLSERVER" failed:
De opgegeven service is geen geïnstalleerde service.
..


------------------------------
Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application.GetSer verInfo(String
server, String& serverVersion)
at Microsoft.SqlServer.Dts.SmoEnum.DTSEnum.GetData(En umResult erParent)
at Microsoft.SqlServer.Management.Smo.Environment.Get Data()
at Microsoft.SqlServer.Management.Smo.Environment.Get Data(Request req,
Object ci)
at Microsoft.SqlServer.Management.Smo.Enumerator.GetD ata(Object
connectionInfo, Request request)
at Microsoft.SqlServer.Management.Smo.Enumerator.Proc ess(Object
connectionInfo, Request request)

===================================

Connect to SSIS Service on machine "BALLSERVER" failed:
De opgegeven service is geen geïnstalleerde service.
..


------------------------------
Program Location:

at
Microsoft.SqlServer.Dts.Runtime.Wrapper.Applicatio nClass.GetServerInfo(String
bstrMachineName, String& serverVersion)
at Microsoft.SqlServer.Dts.Runtime.Application.GetSer verInfo(String
server, String& serverVersion)



What to do now?

Hans



"Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> schreef in
bericht news:C45B162C.6093%ten.xoc@dnartreb.noraa...
> What does "DTS doesn't work here" mean? How are you trying to "make DTS
> work"?
>
> If you have Integration Services (the new version of DTS!) installed, you
> should be able to connect to the local instance by opening Management
> Studio, opening Object Explorer (F8), and clicking Connect > Integration
> Services.
>
> There are many SSIS tutorials and sites out there... You should use Google
> and/or visit the Integration Services newsgroup (both to learn more about
> it
> and to determine if it's really what you want to use in this case).
>
>
> On 5/22/08 12:14 PM, in article
> 48359c04$0$6011$ba620dc5@text.nova.planet.nl, "Hans" <info@tct.nl> wrote:
>
>> I installed as much as possible
>> I now have in Start Menu:
>> -Sub Analysis services
>> -Sub Configuration tools
>> -Sub doc and tutorials
>> -Business Intell Dvelopment Studio
>> -Server Management Studio (this looks like the SQL 2000 program, but DTS
>> doesn't work here)
>>
>> Hans
>>
>> "Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> schreef in
>> bericht news:OCrT5nBvIHA.4376@TK2MSFTNGP06.phx.gbl...
>>> OK, did you install Integration Services when you installed SQL Server?
>>> If not, you will need to go back through setup I think (it is one of the
>>> main components).
>>>
>>>
>>>
>>> "Hans" <info@tct.nl> wrote in message
>>> news:4835244d$0$6032$ba620dc5@text.nova.planet.nl. ..
>>>> Thats one of the functions I know but it should be based on
>>>> automatically
>>>> time schedules.
>>>>
>>>> Hans
>>>
>>>
>>
>>
>

>> What to do now?

Run setup again and make sure Integration Services is installed?

Consider replication or database mirroring or backup/restore?

What about ApexSQL Diff? Or RedGate Compare?

--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net


"Hans" <info@tct.nl> wrote in message
news:48319495$0$6006$ba620dc5@text.nova.planet.nl. ..
>I would like to update my tables in the local SQL 2005 server with the data
>from the tables from an SQL database on the internet.
>
> I used to do this with Data transformation services, but this seems not be
> running in SQL2005.
>
> Other solutions how to to this?
>
> Thanks,
> Hans
>

"Hans" <info@tct.nl> wrote in message
news:4835c0f0$0$6030$ba620dc5@text.nova.planet.nl. ..
>I installed everything and checked the setup again
> I Found your Connect > Integration > Services buto then got following
> error:
>
> ===================================
>
> Cannot connect to BALLSERVER.
>
> ===================================
>
> Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
>
> ------------------------------
> For , click:
> http://go.microsoft.com/fwlink?ProdN...r&LinkId=20476
>
> ------------------------------
> Program Location:
>
> at Microsoft.SqlServer.Management.Smo.Enumerator.Proc ess(Object
> connectionInfo, Request request)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.ObjectExplorer.ValidateConnection(UIC onnectionInfo
> ci, IServerType server)
> at
> Microsoft.SqlServer.Management.UI.ConnectionDlg.Co nnector.ConnectionThreadUser()
>
> ===================================
>
> Connect to SSIS Service on machine "BALLSERVER" failed:
> De opgegeven service is geen geïnstalleerde service.
> .
>
>
> ------------------------------
> Program Location:
>
> at Microsoft.SqlServer.Dts.Runtime.Application.GetSer verInfo(String
> server, String& serverVersion)
> at Microsoft.SqlServer.Dts.SmoEnum.DTSEnum.GetData(En umResult erParent)
> at Microsoft.SqlServer.Management.Smo.Environment.Get Data()
> at Microsoft.SqlServer.Management.Smo.Environment.Get Data(Request req,
> Object ci)
> at Microsoft.SqlServer.Management.Smo.Enumerator.GetD ata(Object
> connectionInfo, Request request)
> at Microsoft.SqlServer.Management.Smo.Enumerator.Proc ess(Object
> connectionInfo, Request request)
>
> ===================================
>
> Connect to SSIS Service on machine "BALLSERVER" failed:
> De opgegeven service is geen geïnstalleerde service.
> .
>
>
> ------------------------------
> Program Location:
>
> at
> Microsoft.SqlServer.Dts.Runtime.Wrapper.Applicatio nClass.GetServerInfo(String
> bstrMachineName, String& serverVersion)
> at Microsoft.SqlServer.Dts.Runtime.Application.GetSer verInfo(String
> server, String& serverVersion)
>
>
>
> What to do now?
>
> Hans
>
>
>
> "Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> schreef in
> bericht news:C45B162C.6093%ten.xoc@dnartreb.noraa...
>> What does "DTS doesn't work here" mean? How are you trying to "make DTS
>> work"?
>>
>> If you have Integration Services (the new version of DTS!) installed, you
>> should be able to connect to the local instance by opening Management
>> Studio, opening Object Explorer (F8), and clicking Connect > Integration
>> Services.
>>
>> There are many SSIS tutorials and sites out there... You should use
>> Google
>> and/or visit the Integration Services newsgroup (both to learn more about
>> it
>> and to determine if it's really what you want to use in this case).
>>
>>
>> On 5/22/08 12:14 PM, in article
>> 48359c04$0$6011$ba620dc5@text.nova.planet.nl, "Hans" <info@tct.nl> wrote:
>>
>>> I installed as much as possible
>>> I now have in Start Menu:
>>> -Sub Analysis services
>>> -Sub Configuration tools
>>> -Sub doc and tutorials
>>> -Business Intell Dvelopment Studio
>>> -Server Management Studio (this looks like the SQL 2000 program, but DTS
>>> doesn't work here)
>>>
>>> Hans
>>>
>>> "Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> schreef in
>>> bericht news:OCrT5nBvIHA.4376@TK2MSFTNGP06.phx.gbl...
>>>> OK, did you install Integration Services when you installed SQL Server?
>>>> If not, you will need to go back through setup I think (it is one of
>>>> the
>>>> main components).
>>>>
>>>>
>>>>
>>>> "Hans" <info@tct.nl> wrote in message
>>>> news:4835244d$0$6032$ba620dc5@text.nova.planet.nl. ..
>>>>> Thats one of the functions I know but it should be based on
>>>>> automatically
>>>>> time schedules.
>>>>>
>>>>> Hans

DTS has been replaced with SSIS in SQL Server 2005. To create a SSIS package
you will need to start the SQL Server Business Intelligence Development
Studio (BIDS). You can still maint existing DTS packages but you may require
the "Microsoft SQL Server 2000 DTS Designer Components" downloadable from
http://www.microsoft.com/downloads/d...displaylang=en
and to run DTS packages you may also need "Microsoft SQL Server 2005
Backward Compatibility Components", Check under Management/Legacy/Data
Transformation Services for your packages.

John