Wishlist: MOST WANTED Tasks, Sources, Transformations, and Destinations?

Wishlist: MOST WANTED Tasks, Sources, Transformations, and Destinations?

• SeniorDevman

  DouglasL wrote:

  For the HTTP request/response task that you're thinking of: The task would put the response into a variable of type Object What other "output" from the task do you envision Thanks, -Doug

  
  
  How about putting the response in an XML (that corresponds to the response object structure) instead
  
  

• Innovasys

  It would be nice to have skeletons of a custom control flow task and a custom data flow task with all of the possible functions/methods defined. It would also be great if it was "commented up" as to what the purpose of each method is, when it is fired and what properties would commonly be used in them. Especially in VB, there seem to be a few C# samples but no VB anywhere. I know C# is the "wave of the future", but we have no one on staff who knows it or has time to learn it right now. Plus, I think, you can only use VB in the stock script compnents and we would rather only use one language since most of our staff know neither one.
  
  Harry
  
  

• DeKale

  Jamie,

  Can you please explain what you mean by a "custom table" I am in fact looking for a good custom log provider output format for a new sample. But it seems to me that table structure is dictated by the logging output fields that one selects...

  -Doug

   

  
  

• Tino.NB

  A source that attaches to a datareader destination from another dts package would also be very useful.

  
  

• s4supersonic

  Harry,
  
  I agree that "templates" are a useful suggestion. You may want to take a look at the wizards that Oleg Ivanov created for this purpose at http://www.ivolva.com/ssis_wizards.html. Also, if you don't want to wait to see whether these appear from Microsoft, it's easy to add template items in Visual Studio by putting files with the appropriate extensions in the appropriate folders. (Forgive me for hedging, I would need to look up the details.)
  
  I'm not sure what you mean about a lack of VB samples, since all of our BOL samples and code snippets are provided in both VB and C#. Although most of them are relatively simple, they should get folks off to a good start.
  
  Thank you for your suggestions.
  
  -Doug
  

• BIODIGITZMAN

  This seems to be metamorphorsizing into the "SSIS Requests" thread but nonetheless....
  
  
  An example of a custom source component that puts data into the pipeline from a variable that has been populated using the recordset destination would be very VERY handy.
  
  Alot of people are complaining that there is no corresponding recordset source component and while I can completely understand the reasons why, I think that being able to do this is still a valid requirement.
  
  -Jamie
  
  
  

• QuasiLoca

  So this source component in Package #2 would launch Package #1 and read the results of its DataReader destination And the output of Package #1 would become the input, as it were, for a new data flow in Package #2
  
  -Doug
  
  

• Vicki Milton

  DouglasL wrote:

  So this source component in Package #2 would launch Package #1 and read the results of its DataReader destination And the output of Package #1 would become the input, as it were, for a new data flow in Package #2 -Doug

  Yes that is exactly right.

  
  

• janfe313

  I vote for:
  
  - HTTP request/response task (with proxy support)
  - console window destination (obviously because this was my request originally)
  
  - Big vote for custom connection manager AND its use in a custom task (i.e. the custom task uses the custom connection manager)
  
  
  
  
  

  
  
  

• atimsa

  An example of a custom log provider that populates a custom table would be useful.
  
  It was me that originally created the SELECT INTO thing so I vote for that as well.
  
  -Jamie
  
  

• SteveS

  Custom UIs.
  
  The standard UI used by in the box components, provides some basic functionality, like configuring the error output, displaying the input and output columns. It would be good to have that to work off.
  
  SELECT INTO WITH OUTUT would be good, to get the keys of the newly created tasks.
  
  Threading in asynchronous components, so many options, it would be good to know the right ones.
  
  

• Gidmeister

  For the HTTP request/response task that you're thinking of: The task would put the response into a variable of type Object What other "output" from the task do you envision Thanks,
  
  -Doug
  
  

• tthulin

  When I wrote my first custom UI (for a connection manager), I was relieved to discover how relatively easy it is. The methods to implement are nearly identical to those we used to write DTS custom tasks, and are nearly identical from one type of SSIS component to another (connection manager, data flow component, etc.).
  
  The upcoming BOL & samples download includes at least a custom connection manager with custom UI, and a data flow transformation with a more complex custom UI (although the latter is provided in C# only in this release).
  
  Thank you for your suggestions.
  
  -Doug
  
  

• Kenneth LeFebvre

  I would like to see a custom lookup component that would provide the ability to add additional constraints, such as an effective date and an expiration date. This would be usefull when referencing type 2 SCDs.
  
• Wishlist: MOST WANTED Tasks, Sources, Transformations, and Destinations?