Home Forums Article Discussions Article Discussions by Author Discuss content posted by Wayne Sheffield Creating templates for use in BIDS (SQL Spackle) RE: Creating templates for use in BIDS (SQL Spackle)

  • April 21, 2011 at 9:30 am

    #1314579

    gonsas (4/21/2011)

    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

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

    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.

    Edit: Here's another MS msdn link for making a PACKAGE template.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    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
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2