Custom Transformation Component tutorial

Hi all,

Is there any tutorial to learn how custom transformation component works? maybe a blog, pdf or something...

Specifically, i need to learn how to generate an output column composed from 3 input columns. The problem is i dont know how to set the column value... anyone have some sample code?

Thanks!

I don't think there is any one source. Books Online has some very good topics on this. Make sure you have the latest version Feb 2007, not just the one which came with the original media.

The MS downloads site has some good samples too, just search for SSIS on there. The samples cover lots of functions and build on each other, even when non functional as they stand.

There plenty of sites with articles but I'll cheat and point to some on mine as I know them -

The ReverseString Component Explained
(http://www.sqlis.com/25.aspx)

When to use ProcessInput or PrimeOutput in your Component
(http://www.sqlis.com/24.aspx)

You can also buy books.

|||

Thanks Darren,

I need this new calculated output column as well as the same 3 columns that were the input of the component.

I have been trying my self using msdn, the problem is that , either i get the new column or the three ones, not these 4 columns i need...

I'll read this articles you post.

Thank you.

|||

Sorry for my insistence...

How can i link the inputs of the "custom transformation component" to its outputs in order to use this data in next step?

It's possible to mix this kind of outputs with other outputs generated by the objects?

thanks

|||

I do not really understand the question. Link inputs, why? Do you have multiple inputs? Do you mean an input or an input column?

You can "link" the input to the output via the SynchronousInputID property of the output makes a synchronous component.

Synchronous vs asynchronous is explained in Books Online.

If you have a synchronous component (make sure you know what that mean, see BOL), then an input column is always an "output" column, but it does not appear in the columns collection of the output itself. You can change data and it is available to downstream components.

|||

Dear Friend,

See this example:

http://pedrocgd.blogspot.com/2007/05/ssis-populating-dimension_28.html

Helped? :-(

Regards!

Custom Dataset Data Extension Tutorial

I posted an excerpt from my book "Microsoft Reporting Services in Action" on
the TheServerSide.net
(http://www.theserverside.net/books/manning/ReportingServices/index.tss).
The article discusses how developers can implement a custom dataset data
extension to report off ADO.NET datasets.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---This book has a great section on Advanced reporting that covers reporting
off of an ADO.NET dataset and a custom security log on for Windows Forms.
Teo also gave a great presentation at the .NET user group and the SQL Server
user group in Atlanta, I could only find the slides and code on the SQL
Server group: http://www.atlantamdf.com/Presentations/AtlantaMDF_101104.zip
. This book has helped me thousands of times and it is one of the better
books on drilling down into Reporting Services.
Brendon Schwartz
http://weblogs.cerkit.com/regularguys
"Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> wrote in message
news:uBp9Wga2EHA.4028@.TK2MSFTNGP15.phx.gbl...
>I posted an excerpt from my book "Microsoft Reporting Services in Action"
>on
> the TheServerSide.net
> (http://www.theserverside.net/books/manning/ReportingServices/index.tss).
> The article discusses how developers can implement a custom dataset data
> extension to report off ADO.NET datasets.
>
> ---
> Teo Lachev, MVP [SQL Server], MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com: http://shrinkster.com/eq
> Home page and blog: http://www.prologika.com/
> ---
>|||Thanks for liking my book, Brendon.
To use this occasion, I would really appreciate it if I could get some
feedback from the RS technical community as far what could be improved in my
book moving forward to RS 2005. I actually posted a blog to solicit some
input(http://prologika.com/blog/archive/2004/11/21/185.aspx), but so far
it's been a voice in the desert. Not even a curse! There must be something
wrong here... Don't you guys read my blog or what? :-)
Seriously, everyone that cares about my writings, please take moment to drop
me an e-mail or add a feedback to the blog link and let me know your
thoughts around the questions I listed in the Road Ahead blog.
Thank you in advance,
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Brendon Schwartz" <nomail@.workinghard.com> wrote in message
news:OBKLtqa2EHA.3000@.TK2MSFTNGP15.phx.gbl...
> This book has a great section on Advanced reporting that covers reporting
> off of an ADO.NET dataset and a custom security log on for Windows Forms.
> Teo also gave a great presentation at the .NET user group and the SQL
Server
> user group in Atlanta, I could only find the slides and code on the SQL
> Server group:
http://www.atlantamdf.com/Presentations/AtlantaMDF_101104.zip
> . This book has helped me thousands of times and it is one of the better
> books on drilling down into Reporting Services.
> Brendon Schwartz
> http://weblogs.cerkit.com/regularguys
>
> "Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> wrote in message
> news:uBp9Wga2EHA.4028@.TK2MSFTNGP15.phx.gbl...
> >I posted an excerpt from my book "Microsoft Reporting Services in Action"
> >on
> > the TheServerSide.net
> >
(http://www.theserverside.net/books/manning/ReportingServices/index.tss).
> > The article discusses how developers can implement a custom dataset data
> > extension to report off ADO.NET datasets.
> >
> >
> > ---
> > Teo Lachev, MVP [SQL Server], MCSD, MCT
> > Author: "Microsoft Reporting Services in Action"
> > Publisher website: http://www.manning.com/lachev
> > Buy it from Amazon.com: http://shrinkster.com/eq
> > Home page and blog: http://www.prologika.com/
> > ---
> >
> >
>|||Teo,
I am currently trying to implement your dataset data extension and have
encountered several issues, most of which I have gotten worked out. However,
when I try to preview the report inside of VS.Net 2003, I get an error.
The error states: An error has occurred during report processing. Object
reference not set to an instance of an object.
Any ideas?
"Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> wrote in message
news:OrynjDb2EHA.1076@.TK2MSFTNGP09.phx.gbl...
> Thanks for liking my book, Brendon.
> To use this occasion, I would really appreciate it if I could get some
> feedback from the RS technical community as far what could be improved in
> my
> book moving forward to RS 2005. I actually posted a blog to solicit some
> input(http://prologika.com/blog/archive/2004/11/21/185.aspx), but so far
> it's been a voice in the desert. Not even a curse! There must be something
> wrong here... Don't you guys read my blog or what? :-)
> Seriously, everyone that cares about my writings, please take moment to
> drop
> me an e-mail or add a feedback to the blog link and let me know your
> thoughts around the questions I listed in the Road Ahead blog.
> Thank you in advance,
> ---
> Teo Lachev, MVP [SQL Server], MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com: http://shrinkster.com/eq
> Home page and blog: http://www.prologika.com/
> ---
> "Brendon Schwartz" <nomail@.workinghard.com> wrote in message
> news:OBKLtqa2EHA.3000@.TK2MSFTNGP15.phx.gbl...
>> This book has a great section on Advanced reporting that covers reporting
>> off of an ADO.NET dataset and a custom security log on for Windows Forms.
>> Teo also gave a great presentation at the .NET user group and the SQL
> Server
>> user group in Atlanta, I could only find the slides and code on the SQL
>> Server group:
> http://www.atlantamdf.com/Presentations/AtlantaMDF_101104.zip
>> . This book has helped me thousands of times and it is one of the better
>> books on drilling down into Reporting Services.
>> Brendon Schwartz
>> http://weblogs.cerkit.com/regularguys
>>
>> "Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> wrote in message
>> news:uBp9Wga2EHA.4028@.TK2MSFTNGP15.phx.gbl...
>> >I posted an excerpt from my book "Microsoft Reporting Services in
>> >Action"
>> >on
>> > the TheServerSide.net
>> >
> (http://www.theserverside.net/books/manning/ReportingServices/index.tss).
>> > The article discusses how developers can implement a custom dataset
>> > data
>> > extension to report off ADO.NET datasets.
>> >
>> >
>> > ---
>> > Teo Lachev, MVP [SQL Server], MCSD, MCT
>> > Author: "Microsoft Reporting Services in Action"
>> > Publisher website: http://www.manning.com/lachev
>> > Buy it from Amazon.com: http://shrinkster.com/eq
>> > Home page and blog: http://www.prologika.com/
>> > ---
>> >
>> >
>>
>|||Does clicking on the Refresh Fields button help? You could get more
troubleshooting tips from the log on GotDotNet.com
(http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=B8468707-56EF-4864-AC51-D83FC3273FE5)
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Tarik Peterson" <tarikp@.investigo.net> wrote in message
news:udixGjA9EHA.368@.TK2MSFTNGP10.phx.gbl...
> Teo,
> I am currently trying to implement your dataset data extension and have
> encountered several issues, most of which I have gotten worked out.
> However, when I try to preview the report inside of VS.Net 2003, I get an
> error.
> The error states: An error has occurred during report processing. Object
> reference not set to an instance of an object.
> Any ideas?
> "Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> wrote in message
> news:OrynjDb2EHA.1076@.TK2MSFTNGP09.phx.gbl...
>> Thanks for liking my book, Brendon.
>> To use this occasion, I would really appreciate it if I could get some
>> feedback from the RS technical community as far what could be improved in
>> my
>> book moving forward to RS 2005. I actually posted a blog to solicit some
>> input(http://prologika.com/blog/archive/2004/11/21/185.aspx), but so far
>> it's been a voice in the desert. Not even a curse! There must be
>> something
>> wrong here... Don't you guys read my blog or what? :-)
>> Seriously, everyone that cares about my writings, please take moment to
>> drop
>> me an e-mail or add a feedback to the blog link and let me know your
>> thoughts around the questions I listed in the Road Ahead blog.
>> Thank you in advance,
>> ---
>> Teo Lachev, MVP [SQL Server], MCSD, MCT
>> Author: "Microsoft Reporting Services in Action"
>> Publisher website: http://www.manning.com/lachev
>> Buy it from Amazon.com: http://shrinkster.com/eq
>> Home page and blog: http://www.prologika.com/
>> ---
>> "Brendon Schwartz" <nomail@.workinghard.com> wrote in message
>> news:OBKLtqa2EHA.3000@.TK2MSFTNGP15.phx.gbl...
>> This book has a great section on Advanced reporting that covers
>> reporting
>> off of an ADO.NET dataset and a custom security log on for Windows
>> Forms.
>> Teo also gave a great presentation at the .NET user group and the SQL
>> Server
>> user group in Atlanta, I could only find the slides and code on the SQL
>> Server group:
>> http://www.atlantamdf.com/Presentations/AtlantaMDF_101104.zip
>> . This book has helped me thousands of times and it is one of the
>> better
>> books on drilling down into Reporting Services.
>> Brendon Schwartz
>> http://weblogs.cerkit.com/regularguys
>>
>> "Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> wrote in message
>> news:uBp9Wga2EHA.4028@.TK2MSFTNGP15.phx.gbl...
>> >I posted an excerpt from my book "Microsoft Reporting Services in
>> >Action"
>> >on
>> > the TheServerSide.net
>> >
>> (http://www.theserverside.net/books/manning/ReportingServices/index.tss).
>> > The article discusses how developers can implement a custom dataset
>> > data
>> > extension to report off ADO.NET datasets.
>> >
>> >
>> > ---
>> > Teo Lachev, MVP [SQL Server], MCSD, MCT
>> > Author: "Microsoft Reporting Services in Action"
>> > Publisher website: http://www.manning.com/lachev
>> > Buy it from Amazon.com: http://shrinkster.com/eq
>> > Home page and blog: http://www.prologika.com/
>> > ---
>> >
>> >
>>
>>
>

Custom connection manager development sample?

Does anyone has code/sample/tutorial/pointer to developing custom connection manager with a custom UI. And then developing a custom task with a custom UI that can point to this custom connection manager... and passing values during runtime from UI to the custom class.

TIA,
NiteshThe first updated Web release of BOL will contain one sample that works with SQL Server and simply asks for server name...a kind of "Hello World" version of what you're asking for.

The second Web release next spring will contain a second sample, a replacement Excel connection manager that includes a checkbox for Import Mode to resolve the common "mixed data types" issue.

The code is too long to post in the forum, but if you'll provide an email address, I can send you one or both.

It's pleasantly simple, relatively speaking, the the UI methods are almost identical from task to data flow component to connection manager, so what you learn will also be portable.

-Doug
|||Okay, I see that you have provided an email address. I'll send them along.
|||Hi DouglasL,
Can you also send me those samples? I am looking for ways to develop a custom connection manager in SSIS and the samples you mention would be extremely helpful. Please use my email address without the .(dontspamme) at the end.

Thanks,
Milen|||

Doug, will you please send me the sample as well? My email is svandekrol [at] taic [dot] net

Thanks

|||

Hi, Doug

I'm also trying to create a custom connection manager, so a sample would be really helpful.

Could you please send to: tminorway [at] hotmail [dot] com ?

Thanks,

Thomas

|||

Doug,

I'm interested in the code, too... Just because the Excel import is sometimes a real pain... Perhaps you ask some of your collegues with blogs to post it there or maybe I can do that for you...

|||Hi Doug:

Thanks for your reply to my other question regarding "setting the data source of data flow from external app". I am also very interested in knowing how to do the custom connection manager, could you please send me a copy of the sample too? My email address is mding1 [at] hotmail [dot] com.

Thanks,
Ming
|||Hi Doug,

I'm interested in the sample code, too. We plan to develop some custom connections.

Thanks in advance.
Fridtjof
mailto:fw[at]team4[dot]de
|||

My apologies to all whose requests I've overlooked...I've been having trouble with the Alerts from the forums. I will send samples today.

-Doug

|||

Can you send me the samples too ?

Mailto : peter.ang[at]comcast.net

|||

I would also like these.

Thank You
hcunningham[at]guideone.com

|||

I will also Like have a look At the Code.

There is a sample also Provided at http://msdn2.microsoft.com/en-us/library/ms345276.aspx

Please any one Zip the code and mail at dharmbirk@.aztec.soft.net

Thanks

Dharmbir

|||

Hi Doug,

The sample contains a Sample Ado source. How would i call a custom editor instead of Advanced Editor. Can you point me any help on that.

Thanks

Dharmbir

|||

I assume you mean a custom UI for the component not connection. You follow a similar pattern to tasks, but inherit from IDtsComponentUI Interface.

Developing a User Interface for Components
(ms-help://MS.MSDNQTR.v80.en/MS.MSDN.v80/MS.SQL.v2005.en/dtsref9/html/10b829a1-609b-42e3-9070-cfe5a2bb698c.htm)

A sample is available from here, Ch 14 & 15 - Wrox::Professional SQL Server 2005 Integration Services:Book Information and Code Download
(http://www.wrox.com/WileyCDA/WroxTitle/productCd-0764584359,descCd-download_code.html)

Custom connection manager development sample?

Does anyone has code/sample/tutorial/pointer to developing custom connection manager with a custom UI. And then developing a custom task with a custom UI that can point to this custom connection manager... and passing values during runtime from UI to the custom class.

TIA,
NiteshThe first updated Web release of BOL will contain one sample that works with SQL Server and simply asks for server name...a kind of "Hello World" version of what you're asking for.

The second Web release next spring will contain a second sample, a replacement Excel connection manager that includes a checkbox for Import Mode to resolve the common "mixed data types" issue.

The code is too long to post in the forum, but if you'll provide an email address, I can send you one or both.

It's pleasantly simple, relatively speaking, the the UI methods are almost identical from task to data flow component to connection manager, so what you learn will also be portable.

-Doug|||Okay, I see that you have provided an email address. I'll send them along.|||Hi DouglasL,
Can you also send me those samples? I am looking for ways to develop a custom connection manager in SSIS and the samples you mention would be extremely helpful. Please use my email address without the .(dontspamme) at the end.

Thanks,
Milen|||

Doug, will you please send me the sample as well? My email is svandekrol [at] taic [dot] net

Thanks

|||

Hi, Doug

I'm also trying to create a custom connection manager, so a sample would be really helpful.

Could you please send to: tminorway [at] hotmail [dot] com ?

Thanks,

Thomas

|||

Doug,

I'm interested in the code, too... Just because the Excel import is sometimes a real pain... Perhaps you ask some of your collegues with blogs to post it there or maybe I can do that for you...

|||Hi Doug:

Thanks for your reply to my other question regarding "setting the data source of data flow from external app". I am also very interested in knowing how to do the custom connection manager, could you please send me a copy of the sample too? My email address is mding1 [at] hotmail [dot] com.

Thanks,
Ming|||Hi Doug,

I'm interested in the sample code, too. We plan to develop some custom connections.

Thanks in advance.
Fridtjof
mailto:fw[at]team4[dot]de

|||

My apologies to all whose requests I've overlooked...I've been having trouble with the Alerts from the forums. I will send samples today.

-Doug

|||

Can you send me the samples too ?

Mailto : peter.ang[at]comcast.net

|||

I would also like these.

Thank You
hcunningham[at]guideone.com

|||

I will also Like have a look At the Code.

There is a sample also Provided at http://msdn2.microsoft.com/en-us/library/ms345276.aspx

Please any one Zip the code and mail at dharmbirk@.aztec.soft.net

Thanks

Dharmbir

|||

Hi Doug,

The sample contains a Sample Ado source. How would i call a custom editor instead of Advanced Editor. Can you point me any help on that.

Thanks

Dharmbir

|||

I assume you mean a custom UI for the component not connection. You follow a similar pattern to tasks, but inherit from IDtsComponentUI Interface.

Developing a User Interface for Components
(ms-help://MS.MSDNQTR.v80.en/MS.MSDN.v80/MS.SQL.v2005.en/dtsref9/html/10b829a1-609b-42e3-9070-cfe5a2bb698c.htm)

A sample is available from here, Ch 14 & 15 - Wrox::Professional SQL Server 2005 Integration Services:Book Information and Code Download
(http://www.wrox.com/WileyCDA/WroxTitle/productCd-0764584359,descCd-download_code.html)

Custom connection manager development sample?

Does anyone has code/sample/tutorial/pointer to developing custom connection manager with a custom UI. And then developing a custom task with a custom UI that can point to this custom connection manager... and passing values during runtime from UI to the custom class.

TIA,
NiteshThe first updated Web release of BOL will contain one sample that works with SQL Server and simply asks for server name...a kind of "Hello World" version of what you're asking for.

The second Web release next spring will contain a second sample, a replacement Excel connection manager that includes a checkbox for Import Mode to resolve the common "mixed data types" issue.

The code is too long to post in the forum, but if you'll provide an email address, I can send you one or both.

It's pleasantly simple, relatively speaking, the the UI methods are almost identical from task to data flow component to connection manager, so what you learn will also be portable.

-Doug|||Okay, I see that you have provided an email address. I'll send them along.|||Hi DouglasL,
Can you also send me those samples? I am looking for ways to develop a custom connection manager in SSIS and the samples you mention would be extremely helpful. Please use my email address without the .(dontspamme) at the end.

Thanks,
Milen|||

Doug, will you please send me the sample as well? My email is svandekrol [at] taic [dot] net

Thanks

|||

Hi, Doug

I'm also trying to create a custom connection manager, so a sample would be really helpful.

Could you please send to: tminorway [at] hotmail [dot] com ?

Thanks,

Thomas

|||

Doug,

I'm interested in the code, too... Just because the Excel import is sometimes a real pain... Perhaps you ask some of your collegues with blogs to post it there or maybe I can do that for you...

|||Hi Doug:

Thanks for your reply to my other question regarding "setting the data source of data flow from external app". I am also very interested in knowing how to do the custom connection manager, could you please send me a copy of the sample too? My email address is mding1 [at] hotmail [dot] com.

Thanks,
Ming|||Hi Doug,

I'm interested in the sample code, too. We plan to develop some custom connections.

Thanks in advance.
Fridtjof
mailto:fw[at]team4[dot]de

|||

My apologies to all whose requests I've overlooked...I've been having trouble with the Alerts from the forums. I will send samples today.

-Doug

|||

Can you send me the samples too ?

Mailto : peter.ang[at]comcast.net

|||

I would also like these.

Thank You
hcunningham[at]guideone.com

|||

I will also Like have a look At the Code.

There is a sample also Provided at http://msdn2.microsoft.com/en-us/library/ms345276.aspx

Please any one Zip the code and mail at dharmbirk@.aztec.soft.net

Thanks

Dharmbir

|||

Hi Doug,

The sample contains a Sample Ado source. How would i call a custom editor instead of Advanced Editor. Can you point me any help on that.

Thanks

Dharmbir

|||

I assume you mean a custom UI for the component not connection. You follow a similar pattern to tasks, but inherit from IDtsComponentUI Interface.

Developing a User Interface for Components
(ms-help://MS.MSDNQTR.v80.en/MS.MSDN.v80/MS.SQL.v2005.en/dtsref9/html/10b829a1-609b-42e3-9070-cfe5a2bb698c.htm)

A sample is available from here, Ch 14 & 15 - Wrox::Professional SQL Server 2005 Integration Services:Book Information and Code Download
(http://www.wrox.com/WileyCDA/WroxTitle/productCd-0764584359,descCd-download_code.html)

Custom connection manager development sample?

Does anyone has code/sample/tutorial/pointer to developing custom connection manager with a custom UI. And then developing a custom task with a custom UI that can point to this custom connection manager... and passing values during runtime from UI to the custom class.

TIA,
NiteshThe first updated Web release of BOL will contain one sample that works with SQL Server and simply asks for server name...a kind of "Hello World" version of what you're asking for.

The second Web release next spring will contain a second sample, a replacement Excel connection manager that includes a checkbox for Import Mode to resolve the common "mixed data types" issue.

The code is too long to post in the forum, but if you'll provide an email address, I can send you one or both.

It's pleasantly simple, relatively speaking, the the UI methods are almost identical from task to data flow component to connection manager, so what you learn will also be portable.

-Doug
|||Okay, I see that you have provided an email address. I'll send them along.
|||Hi DouglasL,
Can you also send me those samples? I am looking for ways to develop a custom connection manager in SSIS and the samples you mention would be extremely helpful. Please use my email address without the .(dontspamme) at the end.

Thanks,
Milen|||

Doug, will you please send me the sample as well? My email is svandekrol [at] taic [dot] net

Thanks

|||

Hi, Doug

I'm also trying to create a custom connection manager, so a sample would be really helpful.

Could you please send to: tminorway [at] hotmail [dot] com ?

Thanks,

Thomas

|||

Doug,

I'm interested in the code, too... Just because the Excel import is sometimes a real pain... Perhaps you ask some of your collegues with blogs to post it there or maybe I can do that for you...

|||Hi Doug:

Thanks for your reply to my other question regarding "setting the data source of data flow from external app". I am also very interested in knowing how to do the custom connection manager, could you please send me a copy of the sample too? My email address is mding1 [at] hotmail [dot] com.

Thanks,
Ming
|||Hi Doug,

I'm interested in the sample code, too. We plan to develop some custom connections.

Thanks in advance.
Fridtjof
mailto:fw[at]team4[dot]de
|||

My apologies to all whose requests I've overlooked...I've been having trouble with the Alerts from the forums. I will send samples today.

-Doug

|||

Can you send me the samples too ?

Mailto : peter.ang[at]comcast.net

|||

I would also like these.

Thank You
hcunningham[at]guideone.com

|||

I will also Like have a look At the Code.

There is a sample also Provided at http://msdn2.microsoft.com/en-us/library/ms345276.aspx

Please any one Zip the code and mail at dharmbirk@.aztec.soft.net

Thanks

Dharmbir

|||

Hi Doug,

The sample contains a Sample Ado source. How would i call a custom editor instead of Advanced Editor. Can you point me any help on that.

Thanks

Dharmbir

|||

I assume you mean a custom UI for the component not connection. You follow a similar pattern to tasks, but inherit from IDtsComponentUI Interface.

Developing a User Interface for Components
(ms-help://MS.MSDNQTR.v80.en/MS.MSDN.v80/MS.SQL.v2005.en/dtsref9/html/10b829a1-609b-42e3-9070-cfe5a2bb698c.htm)

A sample is available from here, Ch 14 & 15 - Wrox::Professional SQL Server 2005 Integration Services:Book Information and Code Download
(http://www.wrox.com/WileyCDA/WroxTitle/productCd-0764584359,descCd-download_code.html)

Custom connection manager development sample?

Does anyone has code/sample/tutorial/pointer to developing custom connection manager with a custom UI. And then developing a custom task with a custom UI that can point to this custom connection manager... and passing values during runtime from UI to the custom class.

TIA,
NiteshThe first updated Web release of BOL will contain one sample that works with SQL Server and simply asks for server name...a kind of "Hello World" version of what you're asking for.

The second Web release next spring will contain a second sample, a replacement Excel connection manager that includes a checkbox for Import Mode to resolve the common "mixed data types" issue.

The code is too long to post in the forum, but if you'll provide an email address, I can send you one or both.

It's pleasantly simple, relatively speaking, the the UI methods are almost identical from task to data flow component to connection manager, so what you learn will also be portable.

-Doug
|||Okay, I see that you have provided an email address. I'll send them along.
|||Hi DouglasL,
Can you also send me those samples? I am looking for ways to develop a custom connection manager in SSIS and the samples you mention would be extremely helpful. Please use my email address without the .(dontspamme) at the end.

Thanks,
Milen|||

Doug, will you please send me the sample as well? My email is svandekrol [at] taic [dot] net

Thanks

|||

Hi, Doug

I'm also trying to create a custom connection manager, so a sample would be really helpful.

Could you please send to: tminorway [at] hotmail [dot] com ?

Thanks,

Thomas

|||

Doug,

I'm interested in the code, too... Just because the Excel import is sometimes a real pain... Perhaps you ask some of your collegues with blogs to post it there or maybe I can do that for you...

|||Hi Doug:

Thanks for your reply to my other question regarding "setting the data source of data flow from external app". I am also very interested in knowing how to do the custom connection manager, could you please send me a copy of the sample too? My email address is mding1 [at] hotmail [dot] com.

Thanks,
Ming
|||Hi Doug,

I'm interested in the sample code, too. We plan to develop some custom connections.

Thanks in advance.
Fridtjof
mailto:fw[at]team4[dot]de
|||

My apologies to all whose requests I've overlooked...I've been having trouble with the Alerts from the forums. I will send samples today.

-Doug

|||

Can you send me the samples too ?

Mailto : peter.ang[at]comcast.net

|||

I would also like these.

Thank You
hcunningham[at]guideone.com

|||

I will also Like have a look At the Code.

There is a sample also Provided at http://msdn2.microsoft.com/en-us/library/ms345276.aspx

Please any one Zip the code and mail at dharmbirk@.aztec.soft.net

Thanks

Dharmbir

|||

Hi Doug,

The sample contains a Sample Ado source. How would i call a custom editor instead of Advanced Editor. Can you point me any help on that.

Thanks

Dharmbir

|||

I assume you mean a custom UI for the component not connection. You follow a similar pattern to tasks, but inherit from IDtsComponentUI Interface.

Developing a User Interface for Components
(ms-help://MS.MSDNQTR.v80.en/MS.MSDN.v80/MS.SQL.v2005.en/dtsref9/html/10b829a1-609b-42e3-9070-cfe5a2bb698c.htm)

A sample is available from here, Ch 14 & 15 - Wrox::Professional SQL Server 2005 Integration Services:Book Information and Code Download
(http://www.wrox.com/WileyCDA/WroxTitle/productCd-0764584359,descCd-download_code.html)

Custom connection manager development sample?

Does anyone has code/sample/tutorial/pointer to developing custom connection manager with a custom UI. And then developing a custom task with a custom UI that can point to this custom connection manager... and passing values during runtime from UI to the custom class.

TIA,
NiteshThe first updated Web release of BOL will contain one sample that works with SQL Server and simply asks for server name...a kind of "Hello World" version of what you're asking for.

The second Web release next spring will contain a second sample, a replacement Excel connection manager that includes a checkbox for Import Mode to resolve the common "mixed data types" issue.

The code is too long to post in the forum, but if you'll provide an email address, I can send you one or both.

It's pleasantly simple, relatively speaking, the the UI methods are almost identical from task to data flow component to connection manager, so what you learn will also be portable.

-Doug
|||Okay, I see that you have provided an email address. I'll send them along.
|||Hi DouglasL,
Can you also send me those samples? I am looking for ways to develop a custom connection manager in SSIS and the samples you mention would be extremely helpful. Please use my email address without the .(dontspamme) at the end.

Thanks,
Milen|||

Doug, will you please send me the sample as well? My email is svandekrol [at] taic [dot] net

Thanks

|||

Hi, Doug

I'm also trying to create a custom connection manager, so a sample would be really helpful.

Could you please send to: tminorway [at] hotmail [dot] com ?

Thanks,

Thomas

|||

Doug,

I'm interested in the code, too... Just because the Excel import is sometimes a real pain... Perhaps you ask some of your collegues with blogs to post it there or maybe I can do that for you...

|||Hi Doug:

Thanks for your reply to my other question regarding "setting the data source of data flow from external app". I am also very interested in knowing how to do the custom connection manager, could you please send me a copy of the sample too? My email address is mding1 [at] hotmail [dot] com.

Thanks,
Ming
|||Hi Doug,

I'm interested in the sample code, too. We plan to develop some custom connections.

Thanks in advance.
Fridtjof
mailto:fw[at]team4[dot]de
|||

My apologies to all whose requests I've overlooked...I've been having trouble with the Alerts from the forums. I will send samples today.

-Doug

|||

Can you send me the samples too ?

Mailto : peter.ang[at]comcast.net

|||

I would also like these.

Thank You
hcunningham[at]guideone.com

|||

I will also Like have a look At the Code.

There is a sample also Provided at http://msdn2.microsoft.com/en-us/library/ms345276.aspx

Please any one Zip the code and mail at dharmbirk@.aztec.soft.net

Thanks

Dharmbir

|||

Hi Doug,

The sample contains a Sample Ado source. How would i call a custom editor instead of Advanced Editor. Can you point me any help on that.

Thanks

Dharmbir

|||

I assume you mean a custom UI for the component not connection. You follow a similar pattern to tasks, but inherit fromIDtsComponentUI Interface.

Developing a User Interface for Components
(ms-help://MS.MSDNQTR.v80.en/MS.MSDN.v80/MS.SQL.v2005.en/dtsref9/html/10b829a1-609b-42e3-9070-cfe5a2bb698c.htm)

A sample is available from here, Ch 14 & 15 - Wrox::Professional SQL Server 2005 Integration Services:Book Information and Code Download
(http://www.wrox.com/WileyCDA/WroxTitle/productCd-0764584359,descCd-download_code.html)