Blogs
Welcome to EMC Consulting Blogs Sign in | Join | Help

Welcome to EMC Consulting Blogs

SSIS Junkie

Once upon a time this blog was a hive of activity. Now however its pretty lifeless as you can probably tell so if are pining for more of the same you can find me over at http://sqlblog.com/blogs/jamie_thomson. I look forward to seeing you there!

SSIS: Location for your package templates

Phillipe Cand asked me recently where you should put your SSIS templates so that you can use them as the basis for your packages. The answer is:

%ProgramFiles%\Microsoft Visual Studio 8\Common7 \IDE\PrivateAssemblies\ProjectItems\DataTransformationProject\DataTransformationItems

Once you have them there you can right-click on a project in BIDS and select "New Item...". Your template should be available.

 

Any problems, let me know!

 

-Jamie

 

 

Published 12 November 2005 14:17 by jamie.thomson

Comments

 

Kristian Wedberg said:

There's also a "Visual Studio user project templates" directory in the Options | Projects and Solutions pane, with a user specific directory, sounds like that might be an appropriate place too depending on your needs...
November 16, 2005 13:55
 

Jamie Thomson - SSIS Jibber Jabber said:

For reasons that I'll save until another post, I always deploy my packages as files rather than to SQL...
May 24, 2006 17:36
 

ajedi2k said:

the link doesn't seem to work....

September 11, 2006 02:15
 

NK said:

Can you please share your template package for download?

Thanks

NK

March 7, 2007 18:38
 

jamie.thomson said:

NK,

I don't have my own template per se. The contents of templates that I use are defined by the requirements of the project that I am currently working on. There is no "one size fits all".

Maybe one day I'll look to build a very generic template that builds on my suggested best practices: http://blogs.conchango.com/jamiethomson/archive/2006/01/05/SSIS_3A00_-Suggested-Best-Practices-and-naming-conventions.aspx

-Jamie

March 7, 2007 19:36
 

SSIS Junkie said:

Someone recently left a comment on my blog about Package Template Locations asking if I could share my

March 11, 2007 03:36
 

Professional Association for SQL Server (PASS) SIG said:

April 4, 2007 15:00
 

SS said:

Yeah that's great but saving templates on your local machine is hardly multiple developer (team environment) friendly. The Visual Studio templates location option doesn't seem to apply to BIDS either - is there a workaround??

September 18, 2008 11:33
 

jamie.thomson said:

SS,

Afraid not. The templating function in BIDS is sadly lacking I'm afraid.

September 18, 2008 11:49
New Comments to this post are disabled

This Blog

Syndication
EMC2, EMC, and where information lives are registered trademarks of EMC Corporation.
All other trademarks used herein are the property of their respective owners.                  
© Copyright 2009 EMC Corporation. All rights reserved.                                                    
Powered by Community Server (Personal Edition), by Telligent Systems