package execution completed. click here to switch to design mode

• sathiyan00

  SSCommitted

  Points: 1879

  More actions

  March 12, 2013 at 4:27 am

  #275151

  hi all,

  when i run my ssis package after 5-10 sec in the bottom of the screen it's showing "package execution completed,click here to switch to design mode". but actually it's not running.help me to solve this.

  my package i have one data flow task and two execute sql task .

  DFT: i'm reading one excel file and used two lookup and destination.

  Exec sql task:in both task i'm call sp's thats it

  thanks

• KumarVelayutham

  SSCrazy

  Points: 2204

  More actions

  March 12, 2013 at 4:28 am

  #1595891

  Reply with the execution results you got in it.

  Regards,
  Kumar

• sathiyan00

  SSCommitted

  Points: 1879

  More actions

  March 12, 2013 at 4:51 am

  #1595896

  hi,

  when i run the package in execution result it shows only below information

  Task load pricing matrix-----------this is my DFT name

  Validation has started

  [SSIS.Pipeline] Information: Validation phase is beginning.

  Progress: Validating - 0 percent complete

  when i run my two execute sql task separately its running fine.but DFT the same problem.

  So i think the problem is with DFT.