Browse by Tags

• aggregate transform
• sort transform
• SSIS

• Making the SSIS Data Reader Source Query Dynamic

  I was recently working with FoxPro for Unix as a data source using ODBC in SSIS (story for another day) and found some interesting scenarios inside of it. We wanted to pull the table name dynamically, thus changing the SELECT statement inside the SSIS... Posted Jul 02 2008, 11:21 PM by Brian Knight with | with no comments Filed under: SSIS, data flow

• Top 3 SSIS Dataflow Mistakes

  There's an old saying that when you have a hammer, everything looks like a nail. If the SSIS data flow is your hammer, too many people thing treat the components in the data flow like nails and don't follow best traditional ETL practices. This... Posted Dec 11 2007, 08:48 PM by Brian Knight with | with 4 comment(s) Filed under: SSIS, data flow, aggregate transform, sort transform