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 |
|
InPharmative
Starting Member
12 Posts |
 Posted - 2008-07-25 : 08:47:32
|
| Ok I have been fighting installing this pack for a week!I have gotten past all issues except for one. Come Guy really need someone to pull this out for me.I have the pack install on MSDB (Sql Server).I set the pack up to run off a SQL Config table configuration.I can NOT get package to run using the configuration tables?Now when I right click and run the package in Execute package Utility and Select Connection Manager in the Execute package Utilityand check all my conection strings change the connection strings to samething I have in my SQL Table it works. But don't seam to check the table on its own and run by just clicking execute?HELP PLEASE I NEED TO GET THIS DONE TODAY!Thanks Michael Webbwww.InPharmative.com |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-25 : 10:51:53
|
| look into this link for sample http://www.mssqltips.com/tip.asp?tip=1405 |
 |
|
|
InPharmative
Starting Member
12 Posts |
Posted - 2008-07-25 : 12:11:54
|
| That don't explain why it works fine on a locl SQL Server on my Pc. But will not run on the Remote Production server?Oh another thing Local Server where it runs is just where I am running the package from. All Connections still point to remote Production Server?Thanks Michael Webbwww.InPharmative.com |
|
|
|
InPharmative
Starting Member
12 Posts |
Posted - 2008-07-25 : 14:20:36
|
| Ok I was wrong and your suggest helped!You either hard code the Config table connection string to a variable then add a expression to the Cofig Connection object/Manager and Set the Connection String = to your variable.OrDo as link says.Thanks Michael Webbwww.InPharmative.com |
|
|
|
|
|
|
SQL Configuration Issue (Urgent)