DTS: ThreadHint in SSIS has not been modified, but has changed since it was build.

Li, Yunyu 0 Reputation points

Screenshot 2024-02-02 104150

I was modifying an SSIS package, updating SQL of the SQL task. when I check the changes, somehow many [DTS: ThreadHint] changed from 0 to 1

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,297 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 30,566 Reputation points

    Hi @Li, Yunyu

    Given that this attribute is only visible in the underlying xml/dtsx and not editable via properties windows, I'd chalk it up to "internals to SSIS and nothing to concern ourselves with".

    If you run the package successfully, you may ignore it temporarily.


    Zoe Hui

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