SQL Journey

Journey of SQL Server & Microsoft Business Intelligence

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

SSIS-Error-CantGetPackageList

Fig-1

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.

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

 
Follow

Get every new post delivered to your Inbox.

Join 262 other followers

%d bloggers like this: