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.