SSIS Manifest Deployment fails

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
Todd_FieldsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Todd_FieldsAuthor Commented:
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
Todd_FieldsAuthor Commented:
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
Ved Prakash AgrawalDatabase Consultant/Performance ArchitectCommented:
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
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Todd_FieldsAuthor Commented:
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
Todd_FieldsAuthor Commented:
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
Todd_FieldsAuthor Commented:
I gather that using the import option from within Management Studio would allow me to get around this?

Todd
0
Todd_FieldsAuthor Commented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.