Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part IV: Variables and Expressions > Making a Package Dynamic with Variables

Chapter 28. Making a Package Dynamic with Variables

Creating dynamic packages in SQL Server Integration Services (SSIS) enables you to have packages that can reconfigure themselves at runtime. Using variables is a significant part to making a package dynamic because with variables you are able to pass values directly into the properties of individual components.

A variable is essentially a placeholder for a value within a package that you can write to or read from as many times as you want. A process within the package can read the variable's value and use it or write to the variable and change the value directly.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint