I can not deploy any of my projects

  • I've been stuck on this problem the whole morning. I would really appreciate someone engaging in this issue.

    For some reason, I can not deploy any of my SSIS projects to any of my servers. Just to check my deployment steps, here is what I'm doing.

    (1) I go into my project in Visual Studio and I build my project.

    (2) I go into the bin\Deployment directory and verify that a deployment manifest has been created.

    (3) I double click on the deployment manifest and follow the wizard.

    (4) In the wizard, I chose SQL Server Deployment, local with Windows Authentication.

    When I finish the wizard, I get the following message.

    TITLE: Package Installation Wizard

    ------------------------------

    Could not save the package "C:\SSIS_Proj\TestConfiguration\ParentPkgDemo\bin\Deployment\ParentPackage.dtsx" to SQL Server "(local)".

    ------------------------------

    ADDITIONAL INFORMATION:

    No description found

    ------------------------------

    BUTTONS:

    OK

    ------------------------------

    I get the same result when I chose to deploy to one of our other SQL Servers running. I also created a dummy "do nothing" project and it also fails to deploy. What could I be doing wrong? Am I missing a step or perhaps have a certain setting misconfigured?

  • I was able to fix the problem after finding this article

    http://dojothemouse.livejournal.com/134890.html

    I'm not sure what caused this problem, but I remember applying a Hotfix several days ago from this link

    http://sqlblogcasts.com/blogs/sqldbatips/archive/2007/03/07/another-maintenance-plan-bug-database-integrity-checks.aspx

    to fix another problem which had to do with Check Database Integrity Task not functioning properly.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply