SSIS Appetizer: import numerics with other regional settings Case I have a CSV file with numeric values that use a dot "." as decimal separator instead of the comma "," we use locally. When …
SSIS Naming conventions In 2006 Jamie Thomson came up with naming conventions for SSIS tasks and data flow components. These naming conventions make your packages and logs…
SSIS Appetizer: Cache Transformation File is Raw File SSIS Appetizer I'm not sure I have a purpose for this, but did you know that you can use the cache file of the Cache Transformation (introduced i…
TSQL Merge for Slowly Changing Dimension or Persistent Staging Area Case What is a fast way to load a Slowly Changing Dimension or Persistent Staging Area in SSIS. When using a Data Flow Task for this, the process cou…
Custom SSIS Component: XML Validation Task Case A while ago I did a post on validating XML files in SSIS with nested XSD files. The out of the box XML Task doesn't honor nested XSD files …
BIML force creating connection managers Case If you declare a connection manager in BIML, but don't use it in one of the tasks or transformations, it won't be created. Can you force…
Coming this year... Extending SSIS with .NET Scripting It's not ready yet, but I'm proud to announce the first SSIS book by me and fellow MVP Régis Baccaro ( B | T ). Extending SSIS with .NET Scr…
Insert unknown dimension record for all dimension tables Case I have a lot of dimension packages in SSIS that all insert a default record for unknown dimension values. It's a lot of repetitive and borin…
SQL Saturday #336 Holland - Powerpointslides Had a nice day at SQL Saturday #336 in Utrecht! The PowerPoint slides of my SSIS Development Best Practices session are available for download . I a…
Foreach loop with *.xls wildcard also returns *.xlsx files Case I have a Foreach Loop Container with a file enumerator. The wildcard is *.xls, but it also returns *.xlsx files. How do I prevent that? Loop t…
XSD location hardcoded in XML source Case The path of the XSD file in the XML Source component is hardcoded, but the path on my production environment is different than my development en…
Nested includes in BIML Script Case I want to use nested includes in a BIML Script (an include in an include), but the second level isn't working. It seems to skip it without g…