CODEWITHSUNDEEP
ssis
CompanyDroneFromSector7G
CompanyDroneFromSector7G

Reputation: 4517

SSIS tasks executing in the wrong order

I have a package with 4 Execute SQL tasks and a data flow task.

SSIS Task Sequence

The sequence is defined using precedence constraints and should be:

  1. (SQL) Create table (if not exists)
  2. (SQL) Create backup table
  3. (SQL) backup and clear
  4. (DF) Import teams data
  5. (SQL) Remove stale data

However, it runs in the order 3, 2, 1, 5, 4.

I read on the net that this can be solved by deleting the tasks and adding again in the order of execution, so I did this but the result is exactly the same!

What else can I do to fix it?

[Edit]

SQL version is:

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1) (Hypervisor)

[/Edit]

[Update]

SSIS package "SERVICEAREATEAMS.dtsx" starting. Information: 0x4004300A at Data Flow Task 1, SSIS.Pipeline: Validation phase is beginning. Error: 0xC0209303 at New Package, Connection manager "SourceConnectionOLEDB": SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR. The requested OLE DB provider OraOLEDB.Oracle.1 is not registered -- perhaps no 64-bit provider is available. Error code: 0x00000000. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered". Error: 0xC020801C at Data Flow Task 1, Source - Query 1: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0209303. There may be error messages posted before this with more information on why the AcquireConnection method call failed. Error: 0xC0047017 at Data Flow Task 1, SSIS.Pipeline: component "Source - Query" (1) failed validation and returned error code 0xC020801C. Error: 0xC004700C at Data Flow Task 1, SSIS.Pipeline: One or more component failed validation. Error: 0xC0024107 at Data Flow Task 1: There were errors during task validation. SSIS package "SERVICEAREATEAMS.dtsx" finished: Failure.

[/Update]

[Update 2]

Results in different sequence to design

[/Update 2]

Upvotes: 1

Views: 3777

Answers (1)

Diego
Diego

Reputation: 36146

why would yo usay it runs on that order? I can assure you that, based on your print screen, thre is no way task 3 is runnig before task 1.

If you think that because the way you see the output (your last screen), you are looking at it the wrong way. It doesnt show the order the tasks are executed, it shows each task individually (I even think they are ordered alfabetically). Also be aware on the type of task, you have the PREPARE of sql task 1 finishing at 13:57:04 and the EXECUTE of the pacakge at 13:57:06, whihc seems to be on the right order to me

Upvotes: 2

Related Questions