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. :-(
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. :-(
