In 2006, Jamie Thomson originally came up with naming conventions for SSIS tasks and data flow components which makes packages and logs more readable and easier to find. Koen Verbeeck and André Kamman extended the existing list with almost 40 tasks/components since then. This list should be used just as a reference if you want to use standard naming convention in SSIS. The point is … [Read more...]
How to Quickly Query LDAP in Visual Studio SSIS
At times, you need to do a quick query against LDAP, but if your access is quite restricted, sometimes instead of using SQL Server Management Studio, you can also use SSIS Project within Visual Studio to do it. Steps Launch Visual Studio. Create a new project and double-click on Integration Services Project. Name your Project name (e.g. ITNotaQueryLDAP), then click Create … [Read more...]
How to Fix Failed to Decrypt Protected XML Node Error in SSIS
One morning, you discovered your SSIS package failed to run with the following error message: This is typically caused by a simple setting that is too often overlooked during deployment. In general, you do not want to save any connection ID and password in your package so you can inject the value from variables that you store either in a database or if you use a Package Deployment Model, … [Read more...]
Gotcha in Executing SSIS from DTExec Command Line
This issue was found in a troubleshooting session in one batch job with one company. The company runs its SSIS using a third party enterprise software by calling dtexec command prompt utility (dtexec.exe) and passes the arguments from its interface. The enterprise suite calls the SSIS package using an Active Directory account (DOMAIN\BatchJob) and the SSIS package is comprised of a *.dtsx and … [Read more...]
How to Add Custom Logging to SSIS Package
This post will demonstrate one way to add custom logging to SSIS Package. This is still considered one of the better practice that comes in handy when we need to troubleshoot SSIS packages and track progress. There's no better way to explain the concept other than giving a simple case example on how to add it to a real SSIS package. For starter, the package in this example does a simple … [Read more...]