in

Pragmatic Works

Enabling your business intelligence enterprise.

Browse by Tags

  • SSIS variables in Data Flow Script Component in Milwaukee

    While at a client in Milwaukee, I came upon an interesting problem on how to access a user-defined variable in a Script Component in the Data Flow. There are actually two ways to solve this problem. One technique is to place a Derived Column before the Script component and create a new derived column...
    Posted to Darren Herbold (Weblog) by Darren Herbold on 09-13-2008
  • SSIS in Chicago

    While at a client in Chicago, I was tasked with loading data from a series of flat files. Easy enough. The interesting requirement though, was to obtain a hash value from the file before loading to determine if in fact the file had been previously loaded. The client had an executable that when run, provided...
    Posted to Darren Herbold (Weblog) by Darren Herbold on 09-12-2008
  • Transactions in SSIS - rolling back deleted files?

    An interesting question was asked of me from a student in my End to End Business Intellingence class during the transactions discussion of the SSIS portion. The question is this: If you have a File System Task in a Sequence container that deletes files from a directory and a subsequent task in the sequence...
    Posted to Darren Herbold (Weblog) by Darren Herbold on 03-06-2008
Page 1 of 1 (3 items)
Copyright Pragmatic Works
Powered by Community Server (Non-Commercial Edition), by Telligent Systems