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)?

jcrawf02 (4/21/2011)

---

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.

gonsas (4/21/2011)

---

Nice tip!

I'd also add that, after adding the template package, one should use BIDS Helper to reset GUIDs

Note We recommend that you generate a unique ID property value for the package to make analyzing log data easier. To generate a unique ID property value, click the ID in the Properties pane, and then click Generate New ID. If Generate New ID does not appear in the Properties pane, verify that the package properties appear in the Properties pane. If the properties for an item such as a connection manager or task appear in the Properties pane, Generate New ID is unavailable.

WayneS (4/21/2011)

---

I just found this MS KB article that states, at the end,