CODEWITHSUNDEEP
sqlssis
Daniel Ramirez
Daniel Ramirez

Reputation: 17

Can I reuse variables in SSIS?

In a starting point , I use a variable " id" for a particular task . Then in a final package point , I require use that same variable to a completely different task . You can reuse ? or should I create new variables?

Upvotes: 0

Views: 583

Answers (1)

Eric Hauenstein
Eric Hauenstein

Reputation: 2565

Yes, you can reuse variables if they are scoped to the package as a whole.

A typical example is a "Rowcount" variable that populated several times during the course of the package, and the number contained used for logging or validation as the package runs.

Upvotes: 1

Related Questions