SQL Journey

Journey of SQL Server & Microsoft Business Intelligence

  • Your Email ID:

    Join 267 other followers

  • SQL Journey

  • Top Rated

  • Bookmarks

  • Blog Stats

    • 157,466 hits
  • Get a Freelancer

    (function(d) { var po = d.createElement('script'); po.type = 'text/javascript'; po.async = true; po.src = '//static.flnaffiliate.com/build/js/affiliate-sdk.js'; var s = d.getElementsByTagName('script')[0]; s.parentNode.insertBefore(po, s); })(document);

SSIS – Error: Could not get a list of SSIS packages from the project

Posted by Prashant on January 28, 2013

While working on a ssis project recently I was trying to build the solution however it was failing again and again without showing any error in Error List !!! and when I checked the Output List it was saying the below message (refer Fig-1).

Error: Could not get a list of SSIS packages from the project.
===== Build: 0 succeeded or up-to-date, 1 failed, 0 skipped =====



This message says there is some missing objects in the project (.dtproj), as CreateDeploymentUtility property was set to True for this project the ssis was not able to show the actual error message.

So set the CreateDeploymentUtility to False and build the project again to get the actual error. In my case there was a package added in the project however because of some source control issues the .dtsx file was not available in the project directory.

Now that you got the error to fix; go ahead and fix the issue then set CreateDeploymentUtility property to True and build the project successfully.

One Response to “SSIS – Error: Could not get a list of SSIS packages from the project”

  1. indeb said

    You saved my day! Your solution worked fine. Thanks a ton!!!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: