Custom task database connection

I'm developing a custom error task for SSIS. I've got a couple of existing OLE DB connections that exist in the Connection Manager. I want a drop down to be displayed in the Custom Task dialogue properties where the user can select one of the databases from the Connection manager.

2 questions:
1. How can i get the list of OLE DB databases in the properties dialogue?
2. Does anyone have a code sample on accessing a database like that within the custom component?Try this post http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=122993&SiteID=1

I don't think you can use an OLE-DB connection directly in managed code. You may (I haven't tried) be able to read off the connection string and use that to create your own ADO.net connection. I have been using ADO.Net connections myself, normally SQL, which gives you a SqlClient.SqlConnection object.

|||Hi Darren,

I don't understand how the IDtsTaskUI.Initialize one ties in here? Also, do you have to tie in the connections within the Acquire Connection method?|||If you have a custom UI for your task then you will have implemented IDtsTaskUI.Initialize in the class that implements IDtsTaskUI.

You call AcquireConnection on the connection you want to get the real connection object. For a file connection that is just a string of the filename, for an ADO.NET connection type SQL, that is a SqlConnection. You would call this in your UI, and also at run-time in the Execute method.

Custom Delivery Extension

SSRS2000 - Is it possible to combine two existing delivery extensions into one custom delivery extension? If possible, I would like to combine file share and email delivery extensions to send email after file has been created by the file share delivery extension. Any help will be much appreciated.

Thanks

Sorry, no this is not possible. You would have to write your own extension that does the same thing.

All is not lost however: If you enable caching for the report, it should be possible to create two subscription that fire at the same time based on a shared schedule that deliver the same report (due to caching) to different locations.

-Lukasz

|||KKaps-

Although they can't be combined, you could create your own custom

delivery extension that does both functions. Take a look at the

PrinterDeliverySample to get started with creating delivery extensions.

Regards,

Scott

Custom Delivery Extension

SSRS2000 - Is it possible to combine two existing delivery extensions into one custom delivery extension? If possible, I would like to combine file share and email delivery extensions to send email after file has been created by the file share delivery extension. Any help will be much appreciated.

Thanks

Sorry, no this is not possible. You would have to write your own extension that does the same thing.

All is not lost however: If you enable caching for the report, it should be possible to create two subscription that fire at the same time based on a shared schedule that deliver the same report (due to caching) to different locations.

-Lukasz

|||KKaps-

Although they can't be combined, you could create your own custom delivery extension that does both functions. Take a look at the PrinterDeliverySample to get started with creating delivery extensions.

Regards,
Scott