ssis

Today I want to talk about my job, the day job. As a Jack-of-All-Trades DBA, I am responsible for backups, security, production releases, data fixes, architecture, schema approvals, development (both...

One of the more difficult aspects of dealing with SSIS packages is the need to find files dynamically. Meaning we don’t always know the exact name of the file or...

Ever run into this error when building an SSIS package? I did, just last week. Here’s the full text of the error: SSIS package "MyPackage.dtsx" starting. Error: 0xC002F210 at Cancel...

Raise your hand if you have a love-hate relationship with SQL Server and SSIS error messages. I know I do. How terribly descriptive the messages tend to be (not) when...

I just learned an interesting fact about SQL 2k8 SSIS script tasks this morning. Generally, I don’t use Script Tasks because I can accomplish with other tasks what most of our devs do...

Running an SSIS package via the SQL Server Agent jobs can be an entertaining experience when said package errors out. It gets even worse when the DBA in question uses an Integration...

Having a problem renaming or deleting a file / folder that is referenced by SQL Server or SSIS? Here’s a tip. If you’re trying to rename or delete a directory folder /...

Following up on my previous post, Creating #Excel Templates in #SQLServer #SSIS, this post walks you through how to use that template for new files. I should note that I...

I’ve seen a lot of advice on the net lately advising people to use Excel templates for their SSIS packages, but I haven’t seen many articles discussing how to create...

Sometimes it’s the stupid things that trip you up. Especially when coding. I was working on a new SSIS package that is supposed to append data to existing files created by...