?
Solved

SSIS Manifest Deployment fails

Posted on 2010-03-29
7
Medium Priority
?
1,737 Views
Last Modified: 2013-11-10
Hi,

I had a working SSIS package deployment and suddently it's not working.  I'm running SSIS as administrator when I build the SSIS package and get the error below when I run it from my MS Explorer window (double click).

As a test I created a new SSIS package with 1 data flow task; built it and tried to deploy from the manifest.  This too failed with the error below.

TITLE: Package Installation Wizard
------------------------------
You need to specify the full path to a SSIS deployment manifest file.

Thanks for any help you can lend me.  

Todd
0
Comment
Question by:Todd_Fields
  • 6
7 Comments
 

Author Comment

by:Todd_Fields
ID: 29003404
Other interesting information.  When I changed the deployment folder to my C: drive and not a network drive, the manifest deployment works.  The IT team says that there has been no permissions changes within the network directory structure.
0
 

Author Comment

by:Todd_Fields
ID: 29012263
For lack of an option, I'm leaving the manifest deployment and going to DTSUTIL:

echo on

DTUtil /FILE "I:\_Finance\FinPlan\DW\Source Code\ODS ETL\D2 Operations\D2 Operations\bin\Deployment\D2 Ops Data Load.dtsx" /DestServer MAY /COPY SQL;"D2 Ops Data Load"

pause

Let me know if you think there is a downside to doing this.

Thanks,
Todd
0
 
LVL 11

Expert Comment

by:Ved Prakash Agrawal
ID: 29060313
Can you rebuild the SSIS package and create menifest file again and tried if this working fine.


Let me know if the error are same.
0
[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

 

Author Comment

by:Todd_Fields
ID: 29101317
I tried a new package called DW TEST with a simple control flow.  This generated a Manifest file and still get the error message.

I've run BIDS as Administrator and without and get the same error.
0
 

Author Comment

by:Todd_Fields
ID: 29101589
Here is my PATH setting:

PATH=C:\Program Files (x86)\Common Files\Fujitsu\COBOL;C:\Windows\SYSTEM32
C:\Windows;C:\Windows\SYSTEM32\WBEM;C:\Windows\SYSTEM32\WINDOWSPOWERSHELL\V1.0\;
C:\PROGRA~2\COMMON~1\FUJITSU\COBOL;C:\Program Files (x86)\Common Files\Macola Shared;
c:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;
c:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;
c:\Program Files\Microsoft SQL Server\100\Tools\Binn\;
c:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\;
c:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86;
C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;
C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\
0
 

Author Comment

by:Todd_Fields
ID: 29109628
I gather that using the import option from within Management Studio would allow me to get around this?

Todd
0
 

Accepted Solution

by:
Todd_Fields earned 0 total points
ID: 30213225
Changed Deployment path to C:\Deployment.

This was shorter and the intended use of deployment.  Deployment should not be done on a network drive if possible.  The deployment folder then copies to the Server where you want to deploy.
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

588 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question