Get/SetVariable value from SSIS VariableDispenser | Tim Van Wassenhove. SSIS Junkie : SSIS Nugget: Ensure your root folder is valid. In the past I have advocated (and still do advocate) the use of a user variable in SSIS packages to store the path to a folder on the hard drive; I always use a variable called @[User::RootFolder] for this. Having this path available within a package variable enables you to dynamically set the location of files that your package may reference such as other packages, raw files, source files, log files etc..
Typically the value of this variable would get set by a configuration or the /SET option of dtexec however you do run the risk that someone might supply a path that does not have a backslash on the end of it and if you have expressions in your package that assume the presence of a backslash then you're going to get an error somewhere along the way. There's an easy prevention to this problem of course. In addition to @[User::RootFolder] I also have a variable called @[User::ValidRootFolder]. RIGHT(@[User::RootFolder], 1) == "\\" ? What this expression basically says is: -Jamie P.S. Eod - Release: ErrorOutputDescription_2008_V2.0.0. SQLSrvIntegrationSrv - Release: MERGE Destination. Using MERGE in Integration Services Packages. In the current release of SQL Server Integration Services, the SQL statement in an Execute SQL task can contain a MERGE statement.
This MERGE statement enables you to accomplish multiple INSERT, UPDATE, and DELETE operations in a single statement. To use the MERGE statement in a package, follow these steps: Create a Data Flow task that loads, transforms, and saves the source data to a temporary or staging table. Create an Execute SQL task that contains the MERGE statement. Connect the Data Flow task to the Execute SQL task, and use the data in the staging table as the input for the MERGE statement. The remainder of this topic discusses some additional uses for the MERGE statement. For a sample destination component that supports the use of the MERGE statement, see the CodePlex community sample, MERGE Destination. Typically, you use the MERGE statement when you want to apply changes that include inserts, updates, and deletions from one table to another table.
MERGE in Other Scenarios.