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-24 : 13:27:31
|
| I have a package I am deploying.My Process is as followed.I do a build/Rebuild.Then go to the Deployment folder and get a copy of the folder.Then go to my remote server. Past folder to desktop.Then open/click the package Manifest file.As I go through the wizzard I select to install the Package SQL erver deploymentHit next, Next, Next tell the Package show it install sucessfully.But when I go to the Integration Server it shows it added it to File Location?Also when I select MSDB and select Import Package I get SQL does allow Remote access? Works fine when I install on local Server on my PC.Thanks Michael Webbwww.InPharmative.com |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-24 : 13:42:31
|
| ENable remote access to sql from surface area configuration and try exporting package through SSMS |
 |
|
|
InPharmative
Starting Member
12 Posts |
Posted - 2008-07-25 : 08:35:09
|
| Ok I am able to install the to MSDB now.I am having issue with Package not using the SQL Server Configuration table I set up.I can get it to run if I hard code connection strings at execution time. I have double check the connection string in the config table to make sure they include the password.Package works great on a local server on my laptop?Thanks Michael Webbwww.InPharmative.com |
|
|
|
|
|
|
Deployment issue!!