Browse by Tags

• Analysis Services
• business intelligence
• Darren Herbold
• delete file
• DTS conversion
• DTS to SSIS conversion
• end to end BI
• ETL
• File System Task
• Groups
• Hierarchy
• move file
• Report Viewer
• reporting services 2008
• script component variable
• SQL 2008
• SQL saturday
• SQL Server 2008 Integration Services
• SQL Server Integration Services
• SQL Server Reporting Services
• SSAS
• SSIS business rules
• SSIS File System Task
• SSIS transactions
• ssis variable in script component
• ssis variables
• SSRS
• Tech Speaking
• transactions

• 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... Posted Sep 13 2008, 08:03 AM by Darren Herbold with | with no comments Filed under: SQL Server Integration Services, SSIS, SSIS transactions, SQL Server 2008 Integration Services, SSIS business rules, script component variable, ssis variable in script component, ssis variables

• 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... Posted Sep 12 2008, 07:00 PM by Darren Herbold with | with no comments Filed under: Report Viewer, Groups, SQL Server Integration Services, SSIS, Hierarchy, ETL, SSIS transactions, SQL Server 2008 Integration Services, reporting services 2008, business intelligence, DTS to SSIS conversion

• Business Intelligence at SQL Saturday in Jacksonville

  Last Saturday I had the privilege to speak at the 3rd SQL Saturday event in Jacksonville, Florida. I have to admit that I didn't quite know what to expect, but I was blown away! This was a beautifully orchestrated event that I felt proud to be a part... Posted May 07 2008, 08:40 PM by Darren Herbold with | with no comments Filed under: SSRS, SSIS, SSAS, Analysis Services, SQL 2008, SQL saturday, business intelligence, end to end BI

• 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... Posted Mar 06 2008, 12:04 PM by Darren Herbold with | with no comments Filed under: Darren Herbold, SQL Server Integration Services, SSIS, delete file, SSIS File System Task, File System Task, move file, SSIS transactions, transactions

• Microsoft Quarterly Tech Briefing

  Recently I had the opportunity to speak at Microsoft's quarterly tech briefing in Ft. Lauderdale, Tampa, and Jacksonville. The travel schedule was a bit brutal doing all three cities in just 3 days. The agenda of the briefings were all Business Intelligence... Posted Jan 10 2008, 11:52 AM by Darren Herbold with | with 2 comment(s) Filed under: SQL Server Reporting Services, Tech Speaking, Darren Herbold, SQL Server Integration Services, SSIS, DTS conversion