Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Wayne Sheffield » Creating templates for use in BIDS (SQL...
Add to briefcase
19 posts, Page 1 of 2
12»»

Creating templates for use in BIDS (SQL Spackle) Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
WayneS
Posted Wednesday, April 20, 2011 11:15 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 9:12 AM
Points: 6,370, Visits: 8,235
Comments posted to this topic are about the item Creating templates for use in BIDS (SQL Spackle)

Wayne
Microsoft Certified Master: SQL Server 2008
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links: For better assistance in answering your questions, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings
Post #1096739
Samuel Vella
Posted Thursday, April 21, 2011 1:56 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 2:22 AM
Points: 328, Visits: 1,852
Nice article, very concise (as a Spackle should be I guess)

Another little tip when adding a template:
When adding a new item you might be tempted to change the file name in the Add New Item dialogue box.
DO NOT DO THIS
Instead, add the package/report leaving in the default file name, then rename it in the project explorer tree.

The reason for this is simple, renaming the file in the dialogue box will not change the object name. Waiting until afterwards will give you the option of automatically changing the object name to reflect the file name.
Post #1096809
Michael Lysons
Posted Thursday, April 21, 2011 2:05 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 17, 2013 1:59 AM
Points: 1,126, Visits: 924
Excellent tip - thanks very much
Post #1096811
gonsas
Posted Thursday, April 21, 2011 3:30 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 1:03 AM
Points: 8, Visits: 142
Samuel Vella (4/21/2011)
Nice article, very concise (as a Spackle should be I guess)

The reason for this is simple, renaming the file in the dialogue box will not change the object name. Waiting until afterwards will give you the option of automatically changing the object name to reflect the file name.


Nice tip!

I'd also add that, after adding the template package, one should use BIDS Helper to reset GUIDs
Post #1096846
LightVader
Posted Thursday, April 21, 2011 6:03 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 11:22 AM
Points: 636, Visits: 1,510
Is there an equally easy way to have the template on the network so all the developers in the company are using the same template (and it would only have to be updated once)?


The opinions expressed herein are strictly personal and do not necessarily reflect the views or policies of my employer.
Post #1096916
Koen Verbeeck
Posted Thursday, April 21, 2011 6:33 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 2:11 AM
Points: 9,378, Visits: 6,473
Nice spackle Wayne, thanks!


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1096934
BIMind
Posted Thursday, April 21, 2011 7:18 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 01, 2013 7:42 AM
Points: 24, Visits: 107
LightVader (4/21/2011)
Is there an equally easy way to have the template on the network so all the developers in the company are using the same template (and it would only have to be updated once)?


I second that question....no reason to go to all that trouble if you're the only one using it unless its a true template for all developers....so how do you get it across to all devs as a template?
Post #1096967
jcrawf02
Posted Thursday, April 21, 2011 7:20 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 6:29 AM
Points: 2,551, Visits: 18,885
LightVader (4/21/2011)
Is there an equally easy way to have the template on the network so all the developers in the company are using the same template (and it would only have to be updated once)?
I used to use a .cmd file to copy templates and SQL Prompt snippets from a shared location to the local folder on login, you could do similar for this. See attached.


Also, Wayne, great article, been thinking about setting up a template for SSIS, so thanks!

If anyone is doing this for SSRS, consider using this in tandem with report styles in the database, a la Barry King (http://www.simple-talk.com/sql/reporting-services/reporting-services-with-style/). That way, you can have your template for the layout you want, and use the db to update the actual styles, or apply multiple styles, and change all reports by updating your db values. Very handy.

---------------------------------------------------------
How best to post your question
How to post performance problems
Tally Table:What it is and how it replaces a loop

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  Post Attachments 
automateDownloadOfSQLPromptSnippets.cmd.txt (6 views, 126 bytes)
downloadSQLPromptSnippets.cmd.txt (5 views, 155 bytes)
Post #1096971
WayneS
Posted Thursday, April 21, 2011 7:23 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 9:12 AM
Points: 6,370, Visits: 8,235
Samuel Vella (4/21/2011)
Another little tip when adding a template:
When adding a new item you might be tempted to change the file name in the Add New Item dialogue box.
DO NOT DO THIS
Instead, add the package/report leaving in the default file name, then rename it in the project explorer tree.

The reason for this is simple, renaming the file in the dialogue box will not change the object name. Waiting until afterwards will give you the option of automatically changing the object name to reflect the file name.


Excellent tip Samuel. (And yet another excellent example of why you need to read the discussions on the articles - lot's of goodies in them, like this!)

Wayne
Microsoft Certified Master: SQL Server 2008
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links: For better assistance in answering your questions, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings
Post #1096974
gonsas
Posted Thursday, April 21, 2011 7:28 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 1:03 AM
Points: 8, Visits: 142
LightVader (4/21/2011)
Is there an equally easy way to have the template on the network so all the developers in the company are using the same template (and it would only have to be updated once)?

Maybe an overkill, but I'd suggest creating hardlinks for the template package files (perhaps using a shell extension).
Post #1096978
« Prev Topic | Next Topic »

Add to briefcase
19 posts, Page 1 of 2
12»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.