package execution completed.. and package doesnt execute

Rohit Kochar 6 Reputation points
2023-02-16T00:00:42.02+00:00

I am scratching my head with this and online solution doest seem of any help. I am executing a package and it will run saying

package execution completed and nothing will happen. I am running Visual stuido 2017.

Has anyone seen this kind of strange behavior? I was getting some other issue because of which I uninstalled Visual stuido 2017 and installed again. To my surpise I also do not see SSDT 2017 and I read that it is included in visual stuido 2017.

Any help would be highly appreciated.

User's image

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,492 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,666 questions
0 comments No comments
{count} votes

4 answers

Sort by: Most helpful
  1. Rohit Kochar 46 Reputation points
    2023-02-25T21:24:31.99+00:00

    I unistalled all verisons of VS on my windows 2019 server machine. Did a clean installation of VS 2019 and then SSDT. Issue was fixed.

    Thanks.

    1 person found this answer helpful.
    0 comments No comments

  2. ZoeHui-MSFT 41,291 Reputation points
    2023-02-16T02:58:06.59+00:00

    Hi @Rohit Kochar

    This message just tells you the package execution is finished. 

    If any error occurred in your package, there would be a red cross on the component. You will find the error message in Output window and Execution Results

    Or you may click Progress to see more details.

    User's image

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.


  3. Rohit Kochar 6 Reputation points
    2023-02-16T04:50:02.2466667+00:00

    User's image

    I see this in the progress so it is validated but didnt get executed. Does anyone know what could be the reason?

    0 comments No comments

  4. Rohit Kochar 6 Reputation points
    2023-02-16T05:17:36.9866667+00:00

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.