I ran into this problem today that didn't take a long time to resolve, but took me a little by surprise. Most of my SSIS packages use the Lookup transformation component to look up keys used in source systems and match them to the data warehouse. When SSIS packages fail at the Lookup component, the most common cause is that the source system's key does not exist in the data warehouse and must be added first. This time was different, however.
Category: SSIS
While working with an SSIS package that uses a custom component (in this case the RegexClean transformation from Konesans) that was upgraded from SSIS 2008 to SSIS 2012, I ran into this error trying to delete it from the designer when I realized I couldn't work with it: "SSIS Designer does not allow this component … Continue reading Removing an Upgraded Component from SSIS Designer Results in Error
As part of my research for my Managing SSISDB talk, I came across an interesting script by Mike Davis. The script intends to copy an environment in the SSISDB. Mike does a good job explaining why this is useful. The SSIS Catalog does not provide a UI for that. Mike's script seems to work, but it has … Continue reading Copy or Duplicate an SSIS environment in the SSIS 2012 Catalog (SSISDB)
SQL Saturday Atlanta 2013 is around the corner: this Saturday, May 18. Like in previous years, the event will be held at the GSU location in Alpharetta, GA. It looks to be a full event with a great roundup of speakers and sessions. I wasn't originally scheduled to speak. Due to a cancellation in the … Continue reading Speaking at SQL Saturday Atlanta #220: Managing the SSIS Catalog
I ran into this error today in SQL Server 2012. It was caused by having promoted a package-level connection manager to project-level and then copying and pasting some data flow components from one package to another in the same project. By copying the data flow components from one package to another, the SSIS designer also copied a … Continue reading SSIS 2012: Failure Saving Package: An Item With the Same Key Has Already Been Added
Edit/Update (2012-12-11): MSDN has now published a 2012 version of the same tutorial: http://msdn.microsoft.com/en-us/library/ms169917(v=sql.110).aspx For SQL Server 2008 R2 Integration Services, Microsoft created a series of tutorials (http://msdn.microsoft.com/en-us/library/ms167031(v=sql.105).aspx). One of those was a nice step-by-step example of creating a basic ETL package. When I teach the undergraduate data warehousing class at Troy University, I have … Continue reading Updating the SSIS Tutorial: Creating a Simple ETL Package to SQL Server 2012
For those interested in upgrading SSIS packages to SQL Server 2012 and who weren't able to make it to my session (or to TechEd at all), the recording is now available on Channel9: http://channel9.msdn.com/Events/TechEd/NorthAmerica/2012/DBI329 The slide deck is also there for download. If you have any questions or comments, please feel free to post them … Continue reading TechEd North America 2012 Session Recording Available
In less than a week, I'll be presenting DBI329 - Upgrading Packages to SQL Server 2012 at TechEd North America 2012 (which is sold out by the way!). I have my session and demos prepared, but I am very interested in hearing from developers and DBA who have already migrated to SSIS 2012 what their … Continue reading Request for Comment: Upgrading Packages to SSIS 2012
A frequently seen question related to editing SSIS packages for 2012 is related to the SQL Server Data Tools (SSDT). SSDT is the successor to the former BIDS and to the former VSDB. However, even though Microsoft likes to think of SSDT as a single product rolling up the functionality of BIDS and VSDB, there … Continue reading When SSDT is not SSDT
In a previous post, I wrote about using SSIS 2008 custom components in SSIS 2012. In that post, I noted that the custom component's UI (Edit, Advanced Edit) does not work in SSDT. It turns out there is a way to get some UI for some components to work though. The key is that the component's … Continue reading Editing SSIS 2008 Custom Component Properties in SSDT
Sven Aelterman 