CODEWITHSUNDEEP
sql-serverteradatasql-jobexecuteprocesstask
HarryS
HarryS

Reputation: 31

Code: 0xC0029151. The process exit code was "-1073740791" while the expected was "0"

I'm trying to load multiple tables from SQL server to Teradata by launching Fastload through .bat files on Execute Process tasks one by one. If I run the batch files directly, it works. I run the SSIS package, it works. I run the package from Integration services, it works. This error occurs only when running it through a job.

I have checked the Folder permissions and SQLSERVERAGENT & MSSQLSERVER have been given full control. The Proxy used is my account. I am an admin on the both the Server as well as the SQL Server. The Fastload files were created through 64-bit OLELoad, though I have tried it through both 32 and 64 bit Execution Options, either way it fails. All the other packages created on the same solution go through without a hitch on the same job, only difference : none of the other packages have an execute process task.

Weirdly enough, it completes loading the table on the first task and then fails at the first task instead of moving to the second one. I have checked the table on Teradata and the row count matches and data seems good. Not sure what I'm missing.

Upvotes: 0

Views: 1429

Answers (0)

Related Questions