data synchronization

I have one Informix in OpenVMS machine and another MS SQL in Windows machine. I cannot touch the Informix server at all.

How to do the extract/update the data periodically from Informix to SQL? I was thinking of writing a service. But I don't know how to do the incremental update.

I was thinking of doing a pull subscription from MS SQL. Is it feasible? Is it a replication or integration service? I dunno. Please help.

Thank you.You don't need to write a service. There already is a service. Use DTS.

I do a nightly tranfer of data from Informix to SQL Server for one of my steady clients.

data synchronisation

Hi,

I'm working with two databases on to physicaly separated servers: #1
is on a local machine en I can only connect to #2 via an ADSL
connection.
I need to syncrhonise the data. This works fine via the wizard from
the Enterprise Manager. But I want to get this done via a script form
the Query Analyzer that I can run whenever I want to. Something like:

insert into srv1.database.dbo.table1
select * from srv2.database.dbo.table1

When I do this I get an error about "linked servers". That surprises
me, because I have no linked servers configured and yet the wizard
works fine?

Can anyone tell me how to accomplish this?

tav
Jan Willemsjhmwillems@.hotmail.com (Jan) wrote in message news:<240176c1.0404060206.4bfaaca3@.posting.google.com>...
> Hi,
> I'm working with two databases on to physicaly separated servers: #1
> is on a local machine en I can only connect to #2 via an ADSL
> connection.
> I need to syncrhonise the data. This works fine via the wizard from
> the Enterprise Manager. But I want to get this done via a script form
> the Query Analyzer that I can run whenever I want to. Something like:
> insert into srv1.database.dbo.table1
> select * from srv2.database.dbo.table1
> When I do this I get an error about "linked servers". That surprises
> me, because I have no linked servers configured and yet the wizard
> works fine?
> Can anyone tell me how to accomplish this?
> tav
> Jan Willems

The Import/Export Data wizard uses a separate connection to each
server, so linked servers are not involved. The INSERT statement above
does require the linked servers to exist, however.

So you could just create the linked servers you need, or if that's not
possible for some reason, then you can save a DTS package from the
wizard, and execute it in whatever way is most convenient:

http://www.sqldts.com/default.aspx?104

Simon

data source error Login Failed

I am using Analysis Services and SQL 2000. On my Analysis Services machine I
define my data source to point to a remote SQL 2000 server using windows
authentication with my domain admin account. I can create the cube and
everything looks great but when I process the cube I get login errors. data
source provider error Login failed for user '\\domain\computer$' 42000.
Surely, this is an easy fix.
Thanks,
Kevin E.
Processing is actually done by the MSSQLServerOLAPService service
(msmdsrv.exe).
It is not based on your interactive credentials (like browsing, etc.)
You need to modify the service to use your domain account.
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"KevinE" <eckart_612@.hotmail.com> wrote in message
news:i8Sdnbpqcc1h0hbfRVn-sA@.centurytel.net...
>I am using Analysis Services and SQL 2000. On my Analysis Services machine
>I define my data source to point to a remote SQL 2000 server using windows
>authentication with my domain admin account. I can create the cube and
>everything looks great but when I process the cube I get login errors.
>data source provider error Login failed for user '\\domain\computer$'
>42000. Surely, this is an easy fix.
> Thanks,
> Kevin E.
>
|||I'm having the same problem now... how do you modify this
MSSQLServerOLAPService service? thanks.
"Dave Wickert [MSFT]" wrote:

> Processing is actually done by the MSSQLServerOLAPService service
> (msmdsrv.exe).
> It is not based on your interactive credentials (like browsing, etc.)
> You need to modify the service to use your domain account.
> --
> Dave Wickert [MSFT]
> dwickert@.online.microsoft.com
> Program Manager
> BI SystemsTeam
> SQL BI Product Unit (Analysis Services)
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "KevinE" <eckart_612@.hotmail.com> wrote in message
> news:i8Sdnbpqcc1h0hbfRVn-sA@.centurytel.net...
>
>
|||Go into your services on the computer that is accessing the data source and
go to the properties of MSSQLServerOLAPService. In the login tab, change the
user from local system account to a domain level account.
KevinE.
"G. Kumar" <GKumar@.discussions.microsoft.com> wrote in message
news:607F313E-A43E-494C-B8F7-214C8320C013@.microsoft.com...[vbcol=seagreen]
> I'm having the same problem now... how do you modify this
> MSSQLServerOLAPService service? thanks.
> "Dave Wickert [MSFT]" wrote:

data source error Login Failed

I am using Analysis Services and SQL 2000. On my Analysis Services machine I
define my data source to point to a remote SQL 2000 server using windows
authentication with my domain admin account. I can create the cube and
everything looks great but when I process the cube I get login errors. data
source provider error Login failed for user '\\domain\computer$' 42000.
Surely, this is an easy fix.
Thanks,
Kevin E.Processing is actually done by the MSSQLServerOLAPService service
(msmdsrv.exe).
It is not based on your interactive credentials (like browsing, etc.)
You need to modify the service to use your domain account.
--
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"KevinE" <eckart_612@.hotmail.com> wrote in message
news:i8Sdnbpqcc1h0hbfRVn-sA@.centurytel.net...
>I am using Analysis Services and SQL 2000. On my Analysis Services machine
>I define my data source to point to a remote SQL 2000 server using windows
>authentication with my domain admin account. I can create the cube and
>everything looks great but when I process the cube I get login errors.
>data source provider error Login failed for user '\\domain\computer$'
>42000. Surely, this is an easy fix.
> Thanks,
> Kevin E.
>|||I'm having the same problem now... how do you modify this
MSSQLServerOLAPService service? thanks.
"Dave Wickert [MSFT]" wrote:

> Processing is actually done by the MSSQLServerOLAPService service
> (msmdsrv.exe).
> It is not based on your interactive credentials (like browsing, etc.)
> You need to modify the service to use your domain account.
> --
> Dave Wickert [MSFT]
> dwickert@.online.microsoft.com
> Program Manager
> BI SystemsTeam
> SQL BI Product Unit (Analysis Services)
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
.
>
> "KevinE" <eckart_612@.hotmail.com> wrote in message
> news:i8Sdnbpqcc1h0hbfRVn-sA@.centurytel.net...
>
>|||Go into your services on the computer that is accessing the data source and
go to the properties of MSSQLServerOLAPService. In the login tab, change the
user from local system account to a domain level account.
KevinE.
"G. Kumar" <GKumar@.discussions.microsoft.com> wrote in message
news:607F313E-A43E-494C-B8F7-214C8320C013@.microsoft.com...[vbcol=seagreen]
> I'm having the same problem now... how do you modify this
> MSSQLServerOLAPService service? thanks.
> "Dave Wickert [MSFT]" wrote:
>

Data source connection to SAS via SS05

Hi all, does anyone have a sample (or knows of one on the web, maybe screenshots) of how to connect via SQL Server 2005 to a SAS box? The SAS machine is Unix, I am able to connect via Enterprise Guide from my local machine - which is also runing SS05 Developer. I'm investingating the possibility of building a cube of off a SAS dataset.

Thanks in advance.

Mark

Two things to keep in mind when building a cube. First, you have to have a driver with which SSAS can connect to the data source and through which SSAS can build objects within the DSV. Next, you need to have a cartridge with which SSAS can construct query statements to pull data from the data source.

You might be able to present SAS objects through SQL Server views using the OPENROWSET function. (This may be where you are already headed.) So, is there a way to connect SQL Server Database Engine to SAS using OPENROWSET?

One other thing, SAS has their own OLAP solution. Is that an option for you?

B.

|||

Ho Bryan,

I went in a different direction (FTP text files for awhile), but am re-visiting this now. We don't have the SAS OLAP Server in house, so unfortunately that isn't an option. However, is there a SAS/MSFT web-site where cartriges can be obtained from? I'm able to connect to the SAS box and can see the SAS datasets, but, I can't render them. Its literally the last step that's blowing up, and I believe it may be cartrige driven.

Thanks,

Mark

|||

Sorry to say I'm not aware of any cartridges other than those provided by default. Worst case, can you perform an OPENROWSET query through SQL Server? If so, you might be able to construct a query in SQL Server using OPENROWSET against SAS which would faciliate processing. Still, no guarantees that would work.

B.

Data source connection to SAS via SS05

Hi all, does anyone have a sample (or knows of one on the web, maybe screenshots) of how to connect via SQL Server 2005 to a SAS box? The SAS machine is Unix, I am able to connect via Enterprise Guide from my local machine - which is also runing SS05 Developer. I'm investingating the possibility of building a cube of off a SAS dataset.

Thanks in advance.

Mark

Two things to keep in mind when building a cube. First, you have to have a driver with which SSAS can connect to the data source and through which SSAS can build objects within the DSV. Next, you need to have a cartridge with which SSAS can construct query statements to pull data from the data source.

You might be able to present SAS objects through SQL Server views using the OPENROWSET function. (This may be where you are already headed.) So, is there a way to connect SQL Server Database Engine to SAS using OPENROWSET?

One other thing, SAS has their own OLAP solution. Is that an option for you?

B.

|||

Ho Bryan,

I went in a different direction (FTP text files for awhile), but am re-visiting this now. We don't have the SAS OLAP Server in house, so unfortunately that isn't an option. However, is there a SAS/MSFT web-site where cartriges can be obtained from? I'm able to connect to the SAS box and can see the SAS datasets, but, I can't render them. Its literally the last step that's blowing up, and I believe it may be cartrige driven.

Thanks,

Mark

|||

Sorry to say I'm not aware of any cartridges other than those provided by default. Worst case, can you perform an OPENROWSET query through SQL Server? If so, you might be able to construct a query in SQL Server using OPENROWSET against SAS which would faciliate processing. Still, no guarantees that would work.

B.

Data migration from Access to SQL server 2005

Hi,

I am trying to migrate the data from the Access database to Microsoft SQL server on my machine using some scripts. I have enabled the OPENROWSET and OPENDATASOURCE support through the surface area configuration. The script that accesses the excel file works fine but when i run the script that trys to open the .mdb file it gives me following error.

OLE DB provider "MSDASQL" for linked server "(null)" returned message "[Microsoft][ODBC Microsoft Access Driver] Cannot open database '(unknown)'. It may not be a database that your application recognizes, or the file may be corrupt.".

Msg 7303, Level 16, State 1, Line 35

Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)".

Any help would be greatly appreciated. Thanks.

-padu

Make sure that the startup account for sqlserver is not a service account (i.e. localsystem/service/etc.). Just use a domain acct.|||

Hi oj,

How do you check the startup account is not a service account? I am pretty new to SQL server.

Thanks.

-padu

|||You can run SQL Server Configuration Manager. It allows you to change service account there (if desired).

Data Flow Task Problem

I have a Windows XP X64 machine with SQL 2005 Developer and VS 2005 Team Edition for Architects on it. For the most part it appears that all normal VS and SQL functions are working properly with the exception of SSIS. If I open the developer studio and drag a Data Flow Task onto the design surface I get the message below. I have tried doing an unistall and reinstall of Integration Services as well as a repair on VS 2005 with no success. I've searched the web and newsgroups and can't find any mention of the problem I'm having. Any help greatly appreciated.
===================================

Failed to create the task. (Microsoft Visual Studio)

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

The designer could not be initialized. (Microsoft.DataTransformationServices.Design)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.DataTransformationServices.Design.SR&EvtID=TaskDesignerCouldNotBeInitialized&LinkId=20476

Program Location:

at Microsoft.DataTransformationServices.Design.PipelineTaskView.Microsoft.SqlServer.Dts.Runtime.Design.IDtsTaskUI.Initialize(TaskHost taskWrapper, IServiceProvider serviceProvider)
at Microsoft.DataTransformationServices.Design.DtrTaskDesigner.InitializeTaskUI()
at Microsoft.DataTransformationServices.Design.DtrTaskDesigner.OnNewTaskAdded()
at Microsoft.DataTransformationServices.Design.DtsBasePackageDesigner.CreateExecutable(String moniker, IDTSSequence container, String name)

Try this.

Go to Windows services, check account under which "SQL Server Integration Services" run.

Switch it to "Local System account"

BAZ

|||

I don't see how the service will effect a designer issue. The service is only used for server storage support or during execution. Local System is not very good practice either, you should understand the security risks involved.

Unfortunately I don't have a solution to the original problem either. Maybe try a Reset Toolbox, as this should clean out any rubbish, and it seems like some tasks are rubbish, or at least not installed correctly. This may prompt something.

|||Hi,

I had the error below when adding data flow tasks in the designer, and Baz' advice worked. Must be some strange permission issue, but i do not know enough about this stuff yet to comment further.

Registration information about the Data Flow task could not be retrieved. Confirm that this task is installed properly on the computer.

ADDITIONAL INFORMATION:

TaskHost "{C3BF9DC1-4715-4694-936F-D3CFDA9E42C5}"' is not installed correctly on this computer. (Microsoft.DataTransformationServices.Design)|||I recently ran into this problem and BAZ's suggestion fixed the issue.
|||BAZMIC solution did'nt worked for me... don't know what to do...
|||I had the exact same problem and BAZMIC's solution worked for me as well.|||

Regarding how the IS service affects the designer...

When the designer starts, it needs to know what IS components (e.g. data flow components, tasks, enumerators, etc) are available on the machine. The discovery process can delay the designer start-up enough to cause a bad user experience. To improve the start-up time, the service caches the information which can then be accessed by the designer and saves it from having to go through the discovery process each time. If the designer starts up and the service is not started, the service will attempt to start and fill its cache. Knowing this might help you troubleshoot these kinds of issues further.

|||

I have just upgraded my SQL 2005 to SP2.

I had the error stated in this thread, and tried Baz's solution.

However now I am getting this error message whenever I try to open a DataTask in SSIS:

TITLE: Microsoft Visual Studio

Cannot show the editor for this task.

ADDITIONAL INFORMATION:

The task returned an unsupported control editor type. (Microsoft.DataTransformationServices.Design)

Can anyone please offer some advice?

|||

Anonymous581024 wrote:

BAZMIC solution did'nt worked for me... don't know what to do...

I tried everything and it never worked. I finally deinstalled SQL Server 2005 Integration Services and reinstalled it.
|||

Thanks Bazmic it works with me |||This is apparantly in some cases a problem with the SP2 that was deployed. After installing this on the SQL Server 2005 I have had a variety of problems including this one.

Data Flow Task Problem

I have a Windows XP X64 machine with SQL 2005 Developer and VS 2005 Team Edition for Architects on it. For the most part it appears that all normal VS and SQL functions are working properly with the exception of SSIS. If I open the developer studio and drag a Data Flow Task onto the design surface I get the message below. I have tried doing an unistall and reinstall of Integration Services as well as a repair on VS 2005 with no success. I've searched the web and newsgroups and can't find any mention of the problem I'm having. Any help greatly appreciated.
===================================

Failed to create the task. (Microsoft Visual Studio)

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

The designer could not be initialized. (Microsoft.DataTransformationServices.Design)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.DataTransformationServices.Design.SR&EvtID=TaskDesignerCouldNotBeInitialized&LinkId=20476

Program Location:

at Microsoft.DataTransformationServices.Design.PipelineTaskView.Microsoft.SqlServer.Dts.Runtime.Design.IDtsTaskUI.Initialize(TaskHost taskWrapper, IServiceProvider serviceProvider)
at Microsoft.DataTransformationServices.Design.DtrTaskDesigner.InitializeTaskUI()
at Microsoft.DataTransformationServices.Design.DtrTaskDesigner.OnNewTaskAdded()
at Microsoft.DataTransformationServices.Design.DtsBasePackageDesigner.CreateExecutable(String moniker, IDTSSequence container, String name)

Try this.

Go to Windows services, check account under which "SQL Server Integration Services" run.

Switch it to "Local System account"

BAZ

|||

I don't see how the service will effect a designer issue. The service is only used for server storage support or during execution. Local System is not very good practice either, you should understand the security risks involved.

Unfortunately I don't have a solution to the original problem either. Maybe try a Reset Toolbox, as this should clean out any rubbish, and it seems like some tasks are rubbish, or at least not installed correctly. This may prompt something.

|||Hi,

I had the error below when adding data flow tasks in the designer, and Baz' advice worked. Must be some strange permission issue, but i do not know enough about this stuff yet to comment further.

Registration information about the Data Flow task could not be retrieved. Confirm that this task is installed properly on the computer.

ADDITIONAL INFORMATION:

TaskHost "{C3BF9DC1-4715-4694-936F-D3CFDA9E42C5}"' is not installed correctly on this computer. (Microsoft.DataTransformationServices.Design)|||I recently ran into this problem and BAZ's suggestion fixed the issue.
|||BAZMIC solution did'nt worked for me... don't know what to do...
|||I had the exact same problem and BAZMIC's solution worked for me as well.|||

Regarding how the IS service affects the designer...

When the designer starts, it needs to know what IS components (e.g. data flow components, tasks, enumerators, etc) are available on the machine. The discovery process can delay the designer start-up enough to cause a bad user experience. To improve the start-up time, the service caches the information which can then be accessed by the designer and saves it from having to go through the discovery process each time. If the designer starts up and the service is not started, the service will attempt to start and fill its cache. Knowing this might help you troubleshoot these kinds of issues further.

|||

I have just upgraded my SQL 2005 to SP2.

I had the error stated in this thread, and tried Baz's solution.

However now I am getting this error message whenever I try to open a DataTask in SSIS:

TITLE: Microsoft Visual Studio

Cannot show the editor for this task.

ADDITIONAL INFORMATION:

The task returned an unsupported control editor type. (Microsoft.DataTransformationServices.Design)

Can anyone please offer some advice?

|||

Anonymous581024 wrote:

BAZMIC solution did'nt worked for me... don't know what to do...

I tried everything and it never worked. I finally deinstalled SQL Server 2005 Integration Services and reinstalled it.
|||Thanks Bazmic it works with me |||This is apparantly in some cases a problem with the SP2 that was deployed. After installing this on the SQL Server 2005 I have had a variety of problems including this one.

Data Flow Task Problem

I have a Windows XP X64 machine with SQL 2005 Developer and VS 2005 Team Edition for Architects on it. For the most part it appears that all normal VS and SQL functions are working properly with the exception of SSIS. If I open the developer studio and drag a Data Flow Task onto the design surface I get the message below. I have tried doing an unistall and reinstall of Integration Services as well as a repair on VS 2005 with no success. I've searched the web and newsgroups and can't find any mention of the problem I'm having. Any help greatly appreciated.
===================================

Failed to create the task. (Microsoft Visual Studio)

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

The designer could not be initialized. (Microsoft.DataTransformationServices.Design)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.DataTransformationServices.Design.SR&EvtID=TaskDesignerCouldNotBeInitialized&LinkId=20476

Program Location:

at Microsoft.DataTransformationServices.Design.PipelineTaskView.Microsoft.SqlServer.Dts.Runtime.Design.IDtsTaskUI.Initialize(TaskHost taskWrapper, IServiceProvider serviceProvider)
at Microsoft.DataTransformationServices.Design.DtrTaskDesigner.InitializeTaskUI()
at Microsoft.DataTransformationServices.Design.DtrTaskDesigner.OnNewTaskAdded()
at Microsoft.DataTransformationServices.Design.DtsBasePackageDesigner.CreateExecutable(String moniker, IDTSSequence container, String name)

Try this.

Go to Windows services, check account under which "SQL Server Integration Services" run.

Switch it to "Local System account"

BAZ

|||

I don't see how the service will effect a designer issue. The service is only used for server storage support or during execution. Local System is not very good practice either, you should understand the security risks involved.

Unfortunately I don't have a solution to the original problem either. Maybe try a Reset Toolbox, as this should clean out any rubbish, and it seems like some tasks are rubbish, or at least not installed correctly. This may prompt something.

|||Hi,

I had the error below when adding data flow tasks in the designer, and Baz' advice worked. Must be some strange permission issue, but i do not know enough about this stuff yet to comment further.

Registration information about the Data Flow task could not be retrieved. Confirm that this task is installed properly on the computer.

ADDITIONAL INFORMATION:

TaskHost "{C3BF9DC1-4715-4694-936F-D3CFDA9E42C5}"' is not installed correctly on this computer. (Microsoft.DataTransformationServices.Design)|||I recently ran into this problem and BAZ's suggestion fixed the issue.|||BAZMIC solution did'nt worked for me... don't know what to do...|||I had the exact same problem and BAZMIC's solution worked for me as well.|||

Regarding how the IS service affects the designer...

When the designer starts, it needs to know what IS components (e.g. data flow components, tasks, enumerators, etc) are available on the machine. The discovery process can delay the designer start-up enough to cause a bad user experience. To improve the start-up time, the service caches the information which can then be accessed by the designer and saves it from having to go through the discovery process each time. If the designer starts up and the service is not started, the service will attempt to start and fill its cache. Knowing this might help you troubleshoot these kinds of issues further.

|||

I have just upgraded my SQL 2005 to SP2.

I had the error stated in this thread, and tried Baz's solution.

However now I am getting this error message whenever I try to open a DataTask in SSIS:

TITLE: Microsoft Visual Studio

Cannot show the editor for this task.

ADDITIONAL INFORMATION:

The task returned an unsupported control editor type. (Microsoft.DataTransformationServices.Design)

Can anyone please offer some advice?

|||

Anonymous581024 wrote:

BAZMIC solution did'nt worked for me... don't know what to do...

I tried everything and it never worked. I finally deinstalled SQL Server 2005 Integration Services and reinstalled it.

Data Flow Task Problem

I have a Windows XP X64 machine with SQL 2005 Developer and VS 2005 Team Edition for Architects on it. For the most part it appears that all normal VS and SQL functions are working properly with the exception of SSIS. If I open the developer studio and drag a Data Flow Task onto the design surface I get the message below. I have tried doing an unistall and reinstall of Integration Services as well as a repair on VS 2005 with no success. I've searched the web and newsgroups and can't find any mention of the problem I'm having. Any help greatly appreciated.
===================================

Failed to create the task. (Microsoft Visual Studio)

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

The designer could not be initialized. (Microsoft.DataTransformationServices.Design)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.DataTransformationServices.Design.SR&EvtID=TaskDesignerCouldNotBeInitialized&LinkId=20476

Program Location:

at Microsoft.DataTransformationServices.Design.PipelineTaskView.Microsoft.SqlServer.Dts.Runtime.Design.IDtsTaskUI.Initialize(TaskHost taskWrapper, IServiceProvider serviceProvider)
at Microsoft.DataTransformationServices.Design.DtrTaskDesigner.InitializeTaskUI()
at Microsoft.DataTransformationServices.Design.DtrTaskDesigner.OnNewTaskAdded()
at Microsoft.DataTransformationServices.Design.DtsBasePackageDesigner.CreateExecutable(String moniker, IDTSSequence container, String name)

Try this.

Go to Windows services, check account under which "SQL Server Integration Services" run.

Switch it to "Local System account"

BAZ

|||

I don't see how the service will effect a designer issue. The service is only used for server storage support or during execution. Local System is not very good practice either, you should understand the security risks involved.

Unfortunately I don't have a solution to the original problem either. Maybe try a Reset Toolbox, as this should clean out any rubbish, and it seems like some tasks are rubbish, or at least not installed correctly. This may prompt something.

|||Hi,

I had the error below when adding data flow tasks in the designer, and Baz' advice worked. Must be some strange permission issue, but i do not know enough about this stuff yet to comment further.

Registration information about the Data Flow task could not be retrieved. Confirm that this task is installed properly on the computer.

ADDITIONAL INFORMATION:

TaskHost "{C3BF9DC1-4715-4694-936F-D3CFDA9E42C5}"' is not installed correctly on this computer. (Microsoft.DataTransformationServices.Design)|||I recently ran into this problem and BAZ's suggestion fixed the issue.
|||BAZMIC solution did'nt worked for me... don't know what to do...
|||I had the exact same problem and BAZMIC's solution worked for me as well.|||

Regarding how the IS service affects the designer...

When the designer starts, it needs to know what IS components (e.g. data flow components, tasks, enumerators, etc) are available on the machine. The discovery process can delay the designer start-up enough to cause a bad user experience. To improve the start-up time, the service caches the information which can then be accessed by the designer and saves it from having to go through the discovery process each time. If the designer starts up and the service is not started, the service will attempt to start and fill its cache. Knowing this might help you troubleshoot these kinds of issues further.

|||

I have just upgraded my SQL 2005 to SP2.

I had the error stated in this thread, and tried Baz's solution.

However now I am getting this error message whenever I try to open a DataTask in SSIS:

TITLE: Microsoft Visual Studio

Cannot show the editor for this task.

ADDITIONAL INFORMATION:

The task returned an unsupported control editor type. (Microsoft.DataTransformationServices.Design)

Can anyone please offer some advice?

|||

Anonymous581024 wrote:

BAZMIC solution did'nt worked for me... don't know what to do...

I tried everything and it never worked. I finally deinstalled SQL Server 2005 Integration Services and reinstalled it.

Data Flow Task Problem

I have a Windows XP X64 machine with SQL 2005 Developer and VS 2005 Team Edition for Architects on it. For the most part it appears that all normal VS and SQL functions are working properly with the exception of SSIS. If I open the developer studio and drag a Data Flow Task onto the design surface I get the message below. I have tried doing an unistall and reinstall of Integration Services as well as a repair on VS 2005 with no success. I've searched the web and newsgroups and can't find any mention of the problem I'm having. Any help greatly appreciated.
===================================

Failed to create the task. (Microsoft Visual Studio)

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

The designer could not be initialized. (Microsoft.DataTransformationServices.Design)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.DataTransformationServices.Design.SR&EvtID=TaskDesignerCouldNotBeInitialized&LinkId=20476

Program Location:

at Microsoft.DataTransformationServices.Design.PipelineTaskView.Microsoft.SqlServer.Dts.Runtime.Design.IDtsTaskUI.Initialize(TaskHost taskWrapper, IServiceProvider serviceProvider)
at Microsoft.DataTransformationServices.Design.DtrTaskDesigner.InitializeTaskUI()
at Microsoft.DataTransformationServices.Design.DtrTaskDesigner.OnNewTaskAdded()
at Microsoft.DataTransformationServices.Design.DtsBasePackageDesigner.CreateExecutable(String moniker, IDTSSequence container, String name)

Try this.

Go to Windows services, check account under which "SQL Server Integration Services" run.

Switch it to "Local System account"

BAZ

|||

I don't see how the service will effect a designer issue. The service is only used for server storage support or during execution. Local System is not very good practice either, you should understand the security risks involved.

Unfortunately I don't have a solution to the original problem either. Maybe try a Reset Toolbox, as this should clean out any rubbish, and it seems like some tasks are rubbish, or at least not installed correctly. This may prompt something.

|||Hi,

I had the error below when adding data flow tasks in the designer, and Baz' advice worked. Must be some strange permission issue, but i do not know enough about this stuff yet to comment further.

Registration information about the Data Flow task could not be retrieved. Confirm that this task is installed properly on the computer.

ADDITIONAL INFORMATION:

TaskHost "{C3BF9DC1-4715-4694-936F-D3CFDA9E42C5}"' is not installed correctly on this computer. (Microsoft.DataTransformationServices.Design)|||I recently ran into this problem and BAZ's suggestion fixed the issue.
|||BAZMIC solution did'nt worked for me... don't know what to do...
|||I had the exact same problem and BAZMIC's solution worked for me as well.|||

Regarding how the IS service affects the designer...

When the designer starts, it needs to know what IS components (e.g. data flow components, tasks, enumerators, etc) are available on the machine. The discovery process can delay the designer start-up enough to cause a bad user experience. To improve the start-up time, the service caches the information which can then be accessed by the designer and saves it from having to go through the discovery process each time. If the designer starts up and the service is not started, the service will attempt to start and fill its cache. Knowing this might help you troubleshoot these kinds of issues further.

|||

I have just upgraded my SQL 2005 to SP2.

I had the error stated in this thread, and tried Baz's solution.

However now I am getting this error message whenever I try to open a DataTask in SSIS:

TITLE: Microsoft Visual Studio

Cannot show the editor for this task.

ADDITIONAL INFORMATION:

The task returned an unsupported control editor type. (Microsoft.DataTransformationServices.Design)

Can anyone please offer some advice?

|||

Anonymous581024 wrote:

BAZMIC solution did'nt worked for me... don't know what to do...

I tried everything and it never worked. I finally deinstalled SQL Server 2005 Integration Services and reinstalled it.
|||Thanks Bazmic it works with me |||This is apparantly in some cases a problem with the SP2 that was deployed. After installing this on the SQL Server 2005 I have had a variety of problems including this one.