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 |
|
Hommer
Aged Yak Warrior
808 Posts |
 Posted - 2015-02-19 : 11:00:46
|
| Hi,I have this rather simple ssis package that I couldn't figure out all a sudden its deployment wouldn't run.The change is just adding two extra columns in the select statement, and exec fine inside VS2008, and build successfully. However, when I run the .SSISDeploymentManifest file inside its bin\deployment folder, all I got is a windows warning of allow make change to this computer, then this next, which after I clicked Ok, did not do anything. Normally, it should show me select file system, server option screen. I went through the same process couple weeks ago without issue, and between now and then, I could not find out any environment changes.Help! Thanks!TITLE: Package Installation Wizard------------------------------You need to specify the full path to a SSIS deployment manifest file.------------------------------BUTTONS:OK------------------------------ |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2015-02-19 : 12:00:18
|
I think I am fighting the issue causing by UAC (User Account Control) on Windows 2008. Normally, I shift-right click to choose "Run As Administrator", but now that option is not there. The windows/network team may have updated my pc remotely...quote:
Originally posted by Hommer
Hi,I have this rather simple ssis package that I couldn't figure out all a sudden its deployment wouldn't run.The change is just adding two extra columns in the select statement, and exec fine inside VS2008, and build successfully. However, when I run the .SSISDeploymentManifest file inside its bin\deployment folder, all I got is a windows warning of allow make change to this computer, then this next, which after I clicked Ok, did not do anything. Normally, it should show me select file system, server option screen. I went through the same process couple weeks ago without issue, and between now and then, I could not find out any environment changes.Help! Thanks!TITLE: Package Installation Wizard------------------------------You need to specify the full path to a SSIS deployment manifest file.------------------------------BUTTONS:OK------------------------------
|
 |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2015-02-19 : 15:15:10
|
I think I got it resolved by copy it to my local instead of running it from the network location.quote:
Originally posted by Hommer
Hi,I have this rather simple ssis package that I couldn't figure out all a sudden its deployment wouldn't run.The change is just adding two extra columns in the select statement, and exec fine inside VS2008, and build successfully. However, when I run the .SSISDeploymentManifest file inside its bin\deployment folder, all I got is a windows warning of allow make change to this computer, then this next, which after I clicked Ok, did not do anything. Normally, it should show me select file system, server option screen. I went through the same process couple weeks ago without issue, and between now and then, I could not find out any environment changes.Help! Thanks!TITLE: Package Installation Wizard------------------------------You need to specify the full path to a SSIS deployment manifest file.------------------------------BUTTONS:OK------------------------------
|
|
|
|
|
|
|
|
|
deployment manifest wouldn't run to completion