Package part debugging is not supported when starting SSIS package

Question

This very strange issue. When I press the start button to execute the SSIS project it shows "Package part debugging is not supported" and nothing else. I create a control flow with the data flow task and execute SQL task. I have a simple use case to count rows using variable and store package names and the number of rows in a table on the SQL server. When I open error list it shows

Error saving PackagePart1.dtsxp: Control flow package part need to contain exactly one executable.
C:\Users\pcp\Documents\Visual Studio 2015\Projects\Transformations\Transformations\PackagePart1.dtsxp

.

What happens when you right click on the package in the solution explorer and press Execute? — Nick.Mc
– Nick.Mc, Commented Feb 12, 2020 at 10:39
there is nothing in the SSIS package. When I right-click the package it says to create new package. Sorry, I am new to SSIS I think i didn't create an SSIS package instead I somehow created a package part and deleted the actual package file. — user3323487
– user3323487, Commented Feb 12, 2020 at 10:43
Oh yes now I see in your screenshot it’s a package part. Just keep experimenting-you’ll work it out! — Nick.Mc
– Nick.Mc, Commented Feb 12, 2020 at 10:52

CODE · Accepted Answer · 2020-12-17 09:00:38Z

-1

Try to change the Debug to Release mode in Visual studio, build and Retry.It worked for me.

answered Dec 17, 2020 at 9:00

CODE

11 bronze badge

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Package part debugging is not supported when starting SSIS package

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related