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...]
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...]