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.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 deployment manifest wouldn't run to completion

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
------------------------------


Go to Top of Page

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
------------------------------


Go to Top of Page
   

- Advertisement -