SqlServerKudos - Getting Started with Variables in SSIS

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

1
kudos

Kudos

Getting Started with Variables in SSIS

published 334 days, 19 hours, 47 minutes ago posted by

sa 339 days, 22 hours, 5 minutes ago

Getting Started with Variables in SSIS

I recently had to create an SSIS package that used variables to pass data between procs, and I thought it would make a good topic for a blog post. There are many scenarios as to the how and why to use variables in SSIS, but we’re going to keep it pretty simple. Let’s assume we have some need to retrieve data from Proc A, pass it to Proc B, and store the results in Table C. First, let’s set up our environment:US...

category: Warehousing | clicked: 1 | | source: sqlfool.com | show counter code

tags: BI, BIDS, SSIS, Variables

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

SqlServerKudos