question

sairam0717 avatar image
sairam0717 asked

Execute package task failing while executing child package

Hi, I am trying to run a parent package which executes 2 child packages. The Child packages are executing with out any errors individually. When I tried to execute them using execute package task It is throwing error in the dataflow task of both child packages. Below is the error message which I am getting. I am using SSIS 2012 Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80040E14 Description: "Statement(s) could not be prepared.". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80040E14 Description: "Incorrect syntax near '4'.". [SSIS.Pipeline] Error: "OLEDB Source Task" failed validation and returned validation status "VS_ISBROKEN". I am wondering why it is throwing syntax error while the child packages are executing with out any syntax errors. Any help on this is greatly appreciated. Thank you.
ssis
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

alexsdba avatar image alexsdba commented ·
Are you using dynamic sql anywhere in those packages?
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.