Creating SSIS Package Templates for Reusability

Geeks With Blogs

10 Posts | 0 Comments

I currently work as a Senior Software Developer for a Furniture Company. I work closely with the E-Commerce team and support their whole infrastructure. Previously, I did continuos development for over 8 years at a technology company, while maintaining operations for a bank.

For most companies, development and operation teams play a game of volleyball passing blame on each other when service/product has issues. Lack of communication and understanding between the two, causes costly and timely problems for every company. DevOps is not a title, nor is a position. DevOps is culture represented by a white flag waved from both directions. Cooperation and Communication are at the heart of DevOps. It tears down the wall and pride of these two very valuable entities inside a company and unleashes the power of teamwork towards a common goal!

Erald Gjoni

<< DB space check | Home | High Availability and Redundancy Plan >>

Creating SSIS Package Templates for Reusability

Comments | Share

We often need to create similar SSIS packages which contain some common components such as connection managers, data flow components, log providers, event handlers, etc... So do we really need to create a package from scratch each time and add all these commonly used components in each package again and again. Is it possible to create a SSIS package with a basic structure/workflow and common components which can be used as template to create subsequent packages?

Below is a great article for this solution:

http://www.mssqltips.com/sqlservertip/2841/creating-ssis-package-templates-for-reusability/

Posted on Monday, May 26, 2014 6:53 PM devops , ETL , SSIS , SSIS Template , Data | Back to top

Comments on this post: Creating SSIS Package Templates for Reusability

No comments posted yet.

Your comment:

Title:

Name:

Email: (never displayed) (will show your gravatar)

Comment: Allowed tags: blockquote, a, strong, em, p, u, strike, super, sub, code

Verification:

ASP.Net SQL Server Apple Google SharePoint Windows Visual Studio Team Foundation Server Agile Office Design Patterns Web Azure