SSIS package skipping data flow components

• daniness

  SSCrazy

  Points: 2890

  More actions

  January 17, 2019 at 2:26 pm

  #376829

  Hi All,

  I've been trying to troubleshoot an SSIS package that appears to be skipping data flow components, and thereby the associated table is not being loaded with records. Can anyone please advise as to what may be causing this? I should also mention that this package is within a parent package. The control flow shows that the package completed:
  
  but within the data flow tab, it's not complete:
  
  However, if the package is run separately, it runs fine...not sure what the issue is. I've checked the connection manager connection strings and all looks okay. Any suggestions would be greatly appreciated. Thanks!

• Phil Parkin

  SSC Guru

  Points: 244733

  More actions

  January 17, 2019 at 2:33 pm

  #2019286

  Looks like Set Audit Key is not terminating properly. Have you checked into that?

  If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
  See https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help/ for details of how to post T-SQL code-related questions.

• daniness

  SSCrazy

  Points: 2890

  More actions

  January 17, 2019 at 2:40 pm

  #2019287

  Hi @PhilParkin,

  Thanks for your comment. Please take a look at my edits.