Componente Services + win xp sp2

Hi.
I've intalled windows xp service pack 2, since there I cant' view Component
Services -> Transaction Statistics from a remote server.
I'm not using XP Firewall.
Any ideia?
Thanks
EsioI found the problem...
RPC changed.
http://msdn.microsoft.com/security/productinfo/XPSP2/networkprotection/restrict_remote_clients.aspx
Esio
"Esio Nunes" <esio_nunes@.hotmail.com> escreveu na mensagem
news:uznYoqk%23EHA.4092@.TK2MSFTNGP09.phx.gbl...
> Hi.
> I've intalled windows xp service pack 2, since there I cant' view
> Component Services -> Transaction Statistics from a remote server.
> I'm not using XP Firewall.
> Any ideia?
> Thanks
> Esio
>

Component wizards

I just posted a couple of wizards on http://www.ivolva.com/ssis_wizards.html to help with creating custom tasks and custom data flow components in C#. It is packaged as MSI, so installation hassle is minimal.

If anyone wants to try this out, please help yourself and let me know how it went.

Oleg
http: http://www.ivolva.com

Hi there Oleg,

I tried them out, they're great starters. Hope you're planning on asking Qs like whether users want async/sync transforms and how many initial inputs/outputs to create.

Thanks for doing this!
regards,
ash

component taking long time to load

hello all
we have an applicaion developed in ASP with SQL server as back end.
Our Application consists of many compoents (typically treated as hyperlinks in the application). now, all the components are responding fine except one component taking long time to load. I have checked my Queries in the backend and they were fine..
what could be the problem ?
I am getting an error OLEDB DRIVER TIMEOUT EXPIRED when i click on the component link.

Plese suggest me some ways...

Thanks and Regards
SAIHave you tried increasing the timeout ? What are you clicking on - what type of application ?|||Originally posted by rnealejr
Have you tried increasing the timeout ? What are you clicking on - what type of application ?

Hello,
the Application is a ASP application, and i am clicking on one of the Hyper link out of several..
Except this link all the other links are working fine..

sai|||But what type of application/database are you trying to connect to ? Have you tried to increase the timeout ? What are the connection strings like for this application that is having a problem - is it hitting a different sql server ?

component services, DTC network access

I am trying to get an XP machine to insert data into a linked Windows
2003 SBS Premium machine. I have done it w/ XP to 2003 but the SBS seems
to have a different Security Configuration on the MSDTC tab in the
COmponent Services. There are no options for inbound or outbound, only:
Network DTC access (checked)
Network Administration (not checked)
Network Transactions (not checked)
Network Clients (not checked)
Transaction Internet Protocol (TIP) Transactions (not checked)
XA Transactions (not checked)
I have done the Application Server option for Network DTC Access.
Any ideas why the screen is different and what I can do to fix?
The server properties say:
Microsoft Windows Server 2003
for Small Business Server
Darin
*** Sent via Developersdex http://www.codecomments.com ***
Hi
I assume that distributed transactions are not working? You may want to ask
in the SBS newsgroup why this is different microsoft.public.windows.server.sbs
John
"Darin" wrote:

> I am trying to get an XP machine to insert data into a linked Windows
> 2003 SBS Premium machine. I have done it w/ XP to 2003 but the SBS seems
> to have a different Security Configuration on the MSDTC tab in the
> COmponent Services. There are no options for inbound or outbound, only:
> Network DTC access (checked)
> Network Administration (not checked)
> Network Transactions (not checked)
> Network Clients (not checked)
> Transaction Internet Protocol (TIP) Transactions (not checked)
> XA Transactions (not checked)
> I have done the Application Server option for Network DTC Access.
> Any ideas why the screen is different and what I can do to fix?
> The server properties say:
> Microsoft Windows Server 2003
> for Small Business Server
> Darin
> *** Sent via Developersdex http://www.codecomments.com ***
>

component services, DTC network access

I am trying to get an XP machine to insert data into a linked Windows
2003 SBS Premium machine. I have done it w/ XP to 2003 but the SBS seems
to have a different Security Configuration on the MSDTC tab in the
COmponent Services. There are no options for inbound or outbound, only:
Network DTC access (checked)
Network Administration (not checked)
Network Transactions (not checked)
Network Clients (not checked)
Transaction Internet Protocol (TIP) Transactions (not checked)
XA Transactions (not checked)
I have done the Application Server option for Network DTC Access.
Any ideas why the screen is different and what I can do to fix?
The server properties say:
Microsoft Windows Server 2003
for Small Business Server
Darin
*** Sent via Developersdex http://www.codecomments.com ***Hi
I assume that distributed transactions are not working? You may want to ask
in the SBS newsgroup why this is different microsoft.public.windows.server.s
bs
John
"Darin" wrote:

> I am trying to get an XP machine to insert data into a linked Windows
> 2003 SBS Premium machine. I have done it w/ XP to 2003 but the SBS seems
> to have a different Security Configuration on the MSDTC tab in the
> COmponent Services. There are no options for inbound or outbound, only:
> Network DTC access (checked)
> Network Administration (not checked)
> Network Transactions (not checked)
> Network Clients (not checked)
> Transaction Internet Protocol (TIP) Transactions (not checked)
> XA Transactions (not checked)
> I have done the Application Server option for Network DTC Access.
> Any ideas why the screen is different and what I can do to fix?
> The server properties say:
> Microsoft Windows Server 2003
> for Small Business Server
> Darin
> *** Sent via Developersdex http://www.codecomments.com ***
>

Component Property Data Types - How to set?

I have developed a component, and within ProvideComponentProperties I have added a property (reflected code)-

IDTSCustomProperty90 property1 = base.get_ComponentMetaData().get_CustomPropertyCollection().New();
property1.set_Name("Seed");
property1.set_Description("The first row number.");
property1.set_Value(1);
property1.set_ExpressionType(1);
property1.set_TypeConverter(typeof(Int32Converter).AssemblyQualifiedName);

I want this to be an Int32, but where do you set this? I am having problems, because sometimes the component ends up with a Decimal type. This only becomes apparent when I try and set an expression. I get -

TITLE: Expression Builder

Cannot convert expression value to property type.
Cannot convert 'System.Int32' to 'System.Decimal'.

The expression I tried always a variable, of type Int32.

Looking at the package Xml I can see the property has been defined as Decimal, but why when I have never told it that-

<property id="18464" name="Seed" dataType="System.Decimal" state="default" isArray="false" description="The first row number." typeConverter="System.ComponentModel.Int32Converter, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UITypeEditor="" containsID="false" expressionType="Notify">1</property>

It would appear that there is no way to set the typ of property, bit limiting, and that SSIS assumes a type, since it clearly has one in the XML. If it gets this wrong
you have to hack the package Xml to recover.

I have tried this several times, and some packages have worked OK, and others get stuck with Decimal. Any ideas why?

You are setting the datatype when you call set_Value. Now why 1 is becoming a decimal I am not certain but that is what is being passed to set_Value. Try creating an Int32 variable and using that to set the value and see if that solves your problem.

HTH,
Matt|||So idea goes that the literal 1 is coming out as decimal, but if I use an explicitly typed set parameter I should remove the ambiguity. I shall give it a go.

Thanks.|||

Matt,

I am having a similar problem again, this time I want the custom property type to be an enumeration. I have tried casting, using variables all sorts, but if I check the type of the variable after I have set the value, it is always Int32. I know Int32 and Enums are pretty much interchangeable, but the issue is I want to set the TypeConverter to EnumConverter. It does not work, and I assume this is because the value type is not an Enum. In the properties grid I just get an empty drop-down.

In this sample _Algorithm is a private class variable defined as an Enum type of mine.

IDTSCustomPropertyCollection90 propertyCollection = ComponentMetaData.CustomPropertyCollection;
IDTSCustomProperty90 customProperty = propertyCollection.New();
customProperty.Name = "DDD";
customProperty.Description = "hkjhgh";
customProperty.Value = _Algorithm;
customProperty.TypeConverter = typeof(System.ComponentModel.EnumConverter).AssemblyQualifiedName;

If I check customProperty.Value.GetType().Name I always get Int32.

Any ideas? I don't want to have to write my own TypeConverter coded to the specific enum, that is maddness.

Component Property Data Types - How to set?

I have developed a component, and within ProvideComponentProperties I have added a property (reflected code)-

IDTSCustomProperty90 property1 = base.get_ComponentMetaData().get_CustomPropertyCollection().New();
property1.set_Name("Seed");
property1.set_Description("The first row number.");
property1.set_Value(1);
property1.set_ExpressionType(1);
property1.set_TypeConverter(typeof(Int32Converter).AssemblyQualifiedName);

I want this to be an Int32, but where do you set this? I am having problems, because sometimes the component ends up with a Decimal type. This only becomes apparent when I try and set an expression. I get -

TITLE: Expression Builder

Cannot convert expression value to property type.
Cannot convert 'System.Int32' to 'System.Decimal'.

The expression I tried always a variable, of type Int32.

Looking at the package Xml I can see the property has been defined as Decimal, but why when I have never told it that-

<property id="18464" name="Seed" dataType="System.Decimal" state="default" isArray="false" description="The first row number." typeConverter="System.ComponentModel.Int32Converter, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UITypeEditor="" containsID="false" expressionType="Notify">1</property>

It would appear that there is no way to set the typ of property, bit limiting, and that SSIS assumes a type, since it clearly has one in the XML. If it gets this wrong
you have to hack the package Xml to recover.

I have tried this several times, and some packages have worked OK, and others get stuck with Decimal. Any ideas why?

You are setting the datatype when you call set_Value. Now why 1 is becoming a decimal I am not certain but that is what is being passed to set_Value. Try creating an Int32 variable and using that to set the value and see if that solves your problem.

HTH,
Matt|||So idea goes that the literal 1 is coming out as decimal, but if I use an explicitly typed set parameter I should remove the ambiguity. I shall give it a go.

Thanks.|||

Matt,

I am having a similar problem again, this time I want the custom property type to be an enumeration. I have tried casting, using variables all sorts, but if I check the type of the variable after I have set the value, it is always Int32. I know Int32 and Enums are pretty much interchangeable, but the issue is I want to set the TypeConverter to EnumConverter. It does not work, and I assume this is because the value type is not an Enum. In the properties grid I just get an empty drop-down.

In this sample _Algorithm is a private class variable defined as an Enum type of mine.

IDTSCustomPropertyCollection90 propertyCollection = ComponentMetaData.CustomPropertyCollection;
IDTSCustomProperty90 customProperty = propertyCollection.New();
customProperty.Name = "DDD";
customProperty.Description = "hkjhgh";
customProperty.Value = _Algorithm;
customProperty.TypeConverter = typeof(System.ComponentModel.EnumConverter).AssemblyQualifiedName;

If I check customProperty.Value.GetType().Name I always get Int32.

Any ideas? I don't want to have to write my own TypeConverter coded to the specific enum, that is maddness.

Component not showing "Show Advanced Editor" in menu

Hi,
I've developed a couple of components now and I know I've seen this problem before but I can't remember how to solve it. My component is built, it has it's own (blank at the moment) UI and it seems to work fine except that there is no right click option to look at the advanced editor. The code is almost identical to another component I wrote that works just fine.
Any ideas anyone?
Thanks
Charlie.The component has more than one input. This apparenty silently disables Advanced Editor support.

Component icons

Hi,

I'm trying to add an icon to a custom component but its not happening and I can't figure out why. I'm sure I've managed to do this in the past. Here's my DtsPipelineComponent attribute:

Code Snippet

namespace Jamiet.Ssis
{
[DtsPipelineComponent(
DisplayName="MyComponent",
Description="Does some stuff",
ComponentType=ComponentType.Transform,
NoEditor=true,
IconResource="MyComponent.ico"
)

MyComponent.ico is stored in the same folder as my project (i.e. at the same level as the .cs file and the C# project file).

In the application property page I've pointed the icon resource at MyComponent.ico

Everything compiles OK. But I see no icon in my component when I deploy it to the toolbox or use it in a package.

I've also tried changing the attribute to this:

Code Snippet

namespace Jamiet.Ssis
{
[DtsPipelineComponent(
DisplayName="MyComponent",
Description="Does some stuff",
ComponentType=ComponentType.Transform,
NoEditor=true,
IconResource="Jamiet.Ssis.MyComponent.ico"
)

Again, it compiles OK, but no icon!

Any ideas what I'm doing wrong?

Thanks

Jamie

Having in no way shape or form done this myself, looking at pg 476 of the wrox professional guide it appears what you are doing is correct (the only difference I see is the closing bracket "]" but I don't believe that is the problem)...

[DtsPipelineComponent(

DisplayName="ReverseString",

ComponentType="ComponentType.Transform,

IconResource="Konesans.Dts.Pipeline.ReverseString.ReverseString.ico",

UITypeName="Konesans.Dts.Pipeline.ReverseStringUI.ReverseStringUI, Konesans.Dts.Pipeline.ReverseStringUI, Version=1.1.0.0, Culture = neutral, PublicKeyToken=7b20fe705a17bed2")]

public class ReverseString : PipelineComponent

...

|||

In the project properties for the .ico file, make sure you have Build Action set to Embedded Resource.

Also, you may need to use a fully qualified name for the icon - the full assemby name.[your icon].ico

|||

cheers John. I'll give it a bash tonight.

Bothers me that there is no docs around this.

|||

jwelch wrote:

In the project properties for the .ico file, make sure you have Build Action set to Embedded Resource.

Also, you may need to use a fully qualified name for the icon - the full assemby name.[your icon].ico

Hey hey hey. It was the build action bit that I was missing.

Thanks John! Much appreciated!

Component icons

Hi,

I'm trying to add an icon to a custom component but its not happening and I can't figure out why. I'm sure I've managed to do this in the past. Here's my DtsPipelineComponent attribute:

Code Snippet

namespace Jamiet.Ssis
{
[DtsPipelineComponent(
DisplayName="MyComponent",
Description="Does some stuff",
ComponentType=ComponentType.Transform,
NoEditor=true,
IconResource="MyComponent.ico"
)

MyComponent.ico is stored in the same folder as my project (i.e. at the same level as the .cs file and the C# project file).

In the application property page I've pointed the icon resource at MyComponent.ico

Everything compiles OK. But I see no icon in my component when I deploy it to the toolbox or use it in a package.

I've also tried changing the attribute to this:

Code Snippet

namespace Jamiet.Ssis
{
[DtsPipelineComponent(
DisplayName="MyComponent",
Description="Does some stuff",
ComponentType=ComponentType.Transform,
NoEditor=true,
IconResource="Jamiet.Ssis.MyComponent.ico"
)

Again, it compiles OK, but no icon!

Any ideas what I'm doing wrong?

Thanks

Jamie

Having in no way shape or form done this myself, looking at pg 476 of the wrox professional guide it appears what you are doing is correct (the only difference I see is the closing bracket "]" but I don't believe that is the problem)...

[DtsPipelineComponent(

DisplayName="ReverseString",

ComponentType="ComponentType.Transform,

IconResource="Konesans.Dts.Pipeline.ReverseString.ReverseString.ico",

UITypeName="Konesans.Dts.Pipeline.ReverseStringUI.ReverseStringUI, Konesans.Dts.Pipeline.ReverseStringUI, Version=1.1.0.0, Culture = neutral, PublicKeyToken=7b20fe705a17bed2")]

public class ReverseString : PipelineComponent

...

|||

In the project properties for the .ico file, make sure you have Build Action set to Embedded Resource.

Also, you may need to use a fully qualified name for the icon - the full assemby name.[your icon].ico

|||

cheers John. I'll give it a bash tonight.

Bothers me that there is no docs around this.

|||

jwelch wrote:

In the project properties for the .ico file, make sure you have Build Action set to Embedded Resource.

Also, you may need to use a fully qualified name for the icon - the full assemby name.[your icon].ico

Hey hey hey. It was the build action bit that I was missing.

Thanks John! Much appreciated!