Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
McDonB
Starting Member
5 Posts |
 Posted - 2004-06-15 : 16:24:22
|
| I have 2 global Variable, CompanyCode and FirstLoadDateCompanyCode is set from a Parent Package that calls an Internal Package.I am trying to set the Global Variable FirstLoadDate in the internal package, and this can be done by running a query:SELECT FristLoadDate FROM Company WHERE CompanyCode = <Global Variable CompanyCode>I cannot figure out how to set FirstLoadDate through a Dynamic Properties Task and trying to set the Global Variable using a Query. Is this possible, or is there a better way? |
|
|
McDonB
Starting Member
5 Posts |
Posted - 2004-06-15 : 16:41:34
|
| Decided to just do with a ExecuteSQL Task |
 |
|
|
|
|
|
Set Global Variable using Query and Global