How to deploy a custom component?

Hi

I developed a “data flow source” in my computer and it is ready!

It works in my computer, but how do I deploy this component in to the server? I have any programming environment on it.

Any Idea?

You will have to register it with the new computers GAC.

Here is a pretty good article on developing and registering a custom component (you will have to register with the web site but it is free):

http://www.sqlservercentral.com/articles/SQL+Server+2005+-+SSIS/2795/

How to delimit in Derived Column Component

If there are two columns in a Derived Column Component, Is there a way we can put a delimiter between them say a '||' symbol or so and build an expression. All I was able to do was concatenate them.

[Col1]+[Col2]

thanks in advance.

You can specify a literal value, and concatenate, as shown below. Any help?

[Col1] + "||" + [Col2]

|||

Thx for the quick reply :) That was exactly I was looking for...