Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:58 AM
Points: 5,370, Visits: 9,010
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
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: Tuesday, November 18, 2014 5:51 AM
Points: 328, Visits: 2,001
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
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: Yesterday @ 3:24 AM
Points: 1,156, Visits: 1,133
Excellent tip - thanks very much
Post #1096811
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: 2 days ago @ 6:40 AM
Points: 9, Visits: 211
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
Posted Thursday, April 21, 2011 6:03 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Today @ 6:06 AM
Points: 763, Visits: 2,287
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
Posted Thursday, April 21, 2011 6:33 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 12:52 PM
Points: 13,636, Visits: 11,509
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
Posted Thursday, April 21, 2011 7:18 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, August 6, 2014 11:38 AM
Points: 24, Visits: 129
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
Posted Thursday, April 21, 2011 7:20 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, December 8, 2014 6:44 AM
Points: 1,332, Visits: 19,320
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 (7 views, 126 bytes)
downloadSQLPromptSnippets.cmd.txt (6 views, 155 bytes)
Post #1096971
Posted Thursday, April 21, 2011 7:23 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:58 AM
Points: 5,370, Visits: 9,010
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
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: 2 days ago @ 6:40 AM
Points: 9, Visits: 211
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 12»»

Permissions Expand / Collapse