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: 246686

  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 you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

• 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.