SSIS

  • In SSIS,How to create a template package with variables and using it for all the dimension packages. so kindly provide me an example of this type with the location and accessing those common templates .

    Thank you

  • What I did, from the SQL ToolBox book, for template is, create an actual package with all standard connection and component generic to my development and save it to sql server. Now in BIDS when I add a package i select add existing package and select SQL server as source and then rename it. I hope that does the trick for you too.

    FP


    FP

    True Love is Like A Ghost. Everyone Talks About It & Nobody have seen it.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply