blogs.conchango.com

welcome to the conchango blogging site
Welcome to blogs.conchango.com Sign in | Join | Help
in Search
Blogs

SSIS Junkie

I am currently on holiday until 13th October so comments are disabled until then. Feel free to use the "Email" link but don't expect an answer.

Conchango are busy and need top level Technical Architects for Microsoft & Open Source platforms in and around London. Interested? Email me or send me a message

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

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

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

Leave a Comment

(required) 
(optional)
(required) 
Submit

This Blog

Syndication

News
© 2008 - Any comments or statements made herein do not necessarily reflect those of Conchango.
Powered by Community Server (Personal Edition), by Telligent Systems