question

sidneyl avatar image
0 Votes"
sidneyl asked Monalv-msft edited

SSIS Package Parent - Child Execution

I have two SSIS packages named Parent.dtsx and Child.dtsx. For simplicity, the child package simply
inserts a row into an oracle table and this .dtsx has EncryptSensitiveWithPassword for the Oracle connection.
The parent package has only one task which is Execute Package Task which calls the Child.dtsx.
The parent package has ReferenceType = ExternalReference with the connection pointing to SQL Server that
contains both parent.dtsx and child.dtsx.

Child.dtsx runs fine in Visual Studio. I get the row inserted. If I run parent.dtsx via a sql agent job, I get an error saying "ORA-01005: null password given; logon denied" However, If I logon to Integration Service and manually do a "Child -> Run Package", it works fine. Of course, I get the pop up asking for the password to the package because it's encrypted.

Why can't I run via the SQL Agent to execute parent.dtsx? If I change the agent job step to run child.dtsx, then it works.

sql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Monalv-msft avatar image
0 Votes"
Monalv-msft answered Monalv-msft edited

Hi @sidneyl ,

If I run parent.dtsx via a sql agent job, I get an error saying "ORA-01005: null password given; logon denied".

May I know if the user that to execute the parent.dtsx has full permission to connect to the oracle connection?

May I know if you try to run parent.dtsx in SSDT?

Please try to deploy the ssis packages to SSISDB Catalog and then run the packages in Sql Agent Job from ssisdb catalog.

Please refer to ORA-01005: null password given; logon denied" Error when trying.

Best regards,
Mona


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @sidneyl ,

May I know if you have anything to update?

Best Regards,
Mona

0 Votes 0 ·