in

Pragmatic Works

Enabling your business intelligence enterprise.

Browse by Tags

  • 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 Data Reader Source. Whilst this is quite easy in...
    Posted to Brian Knight (Weblog) by Brian Knight on 07-02-2008
  • 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 quick posts is a preview of an upcoming article coming...
    Posted to Brian Knight (Weblog) by Brian Knight on 12-11-2007
Page 1 of 1 (2 items)
Copyright Pragmatic Works
Powered by Community Server (Non-Commercial Edition), by Telligent Systems