Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using Variables - Int from a table

Status
Not open for further replies.

bigfoot

Programmer
May 4, 1999
1,779
US
I built a package a few years ago and I set up the variables for it in a SQL table.
I need to make some changes to this package and add in a few more variables but I can't figure out how I got the variables initialized from the table. There is NO query.

OK, so I feel stupid but we don't use SSIS for much here.

This package was written as a DTS but I remember having to rewrite it in SSIS for SQL Server 2005, using BIDS.

I opened the package in BIDS, and I have went into every tab, trying to find the magic link from the sql table to the variables. This is a simple package that reads a flat file and moves it to a sql table.
I have 2 variables that correspond to 2 rows in a sql table.

I did not use the configuration manager.

Thanks for any and all help. :-(
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top