1

I have a SSIS task which reads XML files from a folder. It reads each XML file into a variable and then loads that data into a SQL server table (bulk column). This process works fine in the Local and Dev environments, but it gives me an error when executing in stage environment:

Exception has been thrown by the target of an invocation.

The size of the XML file is 200 MB and above is the error that I face in stage environment.

I attached an image of the execution log:

ExecutionLog

How can I fix this?

zx485
  • 28,498
  • 28
  • 50
  • 59
Aashay Uppala
  • 11
  • 1
  • 3
  • Do you have permissions in stage environment? Also, I'd check variable names as there are case sensitive. – BI Dude Apr 15 '18 at 08:31
  • Yes,I do have permissions in stage environment. Variable names are correct as well. The thing is it works in Developer tools but fails when the package is deployed using dtsx. – Aashay Uppala Apr 15 '18 at 12:52
  • I have added try and catch blocks in my Script task and it now shows Out of memory Exception "Exception of type 'System.OutOfMemoryException' was thrown." Files size normally ranges from 100MB and above. Thanks. – Aashay Uppala Apr 15 '18 at 14:27

1 Answers1

0

Issue got resolved. The package was throwing out of memory exception when executed in 64 bit mode and was working fine in 32 bit mode (not sure why the Exception was thrown in 64 bit mode though).

So, created a task in task scheduler to run the package using DTexec.exe (x86) and it executed successfully.

Aashay Uppala
  • 11
  • 1
  • 3