I'm Looking For a Custom Object That Does...

Coordinator
Oct 28, 2009 at 8:52 PM

If you've looked at the directory of custom objects/extensions/tools for SQL Server Integrations Services, and you still don't see what you need, post something here.  Maybe someone really nice will help...

Coordinator
Oct 28, 2009 at 9:10 PM

Some tasks I've got on my "to do" list (because they're interesting and/or I'll use them, I'm sure):

  • Tasks:
    • Set Variable Task - Per the code on the net...
    • HTTP Task - to stuff a web call result into a string
  • Transforms:
    • Unicode to Non-unicode Autoconverter - a transform that you can stick in the middle of a flow and identify which columns you'd like "flipped" from unicode to not (or vice versa).  Kindof like the Data Conversion component - except that it will keep the column name (not lineage ID though), which should make converting a LOT easier.  Possibly having the option to trim and/or upper/lowercase the string as well.  I have a Connect issue asking for this... we'll see who's faster :)
    • Dense Rank - replicating the DENSE RANK functionality in T-SQL.
    • GUID Generator - generates a new GUID for each row.
    • Cross Join - just to create trouble :)
    • Non-blocking Distinct