SSIS – Feature Request: Snap-To Guides

Have you ever designed an SSIS package and wished that you had easier layout tools? Ever wanted the snap-to guides that allow you to position tasks/components in such a way that they align with existing tasks/components on the design surface? Here’s what I’m referring to (note the blue dashed line on the left): Well, now’s […]

Read more
SQL Server Future – Code Name “Denali” CTP1 Now Available!

The first public CTP of the next major version of SQL Server is now available. Go and get it, kick the tires, and let the team know about any bugs you may find. Some of the immediate changes to highlight in CTP1 are: SSMS is now based on Visual Studio, sequence generators, several new DMV/DMFs […]

Read more
SSIS 2008 – Cannot Show Visual Studio 2008 Tools for Applications error

Should you come across this error message, “cannot show visual studio 2008 tools for applications”, you may have to clean up your VSTA environment. You may also have the following additional error message: The System Cannot Find The File Specified Here’s how to fix it, thanks to Silviu Guea, Microsoft. Create a batch file with […]

Read more
SSIS – Task and Component Naming Conventions

I’m reposting a list of task/component prefix naming conventions that Jamie Thomson posted some years back for SSIS. Using a standard set of prefixes allows for easy log reading, better multi-developer support, and ease of readability. Get the Excel document here: SSIS_Prefix_Naming.xlsx (11 KB) Note that I have not updated this document for 2008 task/component […]

Read more
SSIS – Visio stencils for SSIS

(Hmm, what is a retweet in blog terms? This is a re-blog.) Jamie Thomson has provided a post providing a link to download Microsoft Visio stencils for SSIS diagramming. Get it here (Josh Robinson – original source) or here (Jamie Thomson).

Read more
SSIS – Organize the toolbox in BIDS

A quick tip for those that may want some better organization over the default provided by BIDS when working with SSIS packages. You can add your own groupings to the Toolbox window by right-clicking anywhere in the toolbox, and selecting “Add Tab”. For example, in the data flow window, I can add a new tab […]

Read more
SSIS – SSISTalk.com Content

If you have something that you’d like to see blogged here regarding SSIS and/or SQL Server, please let me know and I’ll see what I can do. Also, if you find a post here that you’re using to work on an issue in SSIS 2008, let me know if it isn’t working for you. It […]

Read more