Hi @Vishnu Narayan,
Seems that the error is related with the connection manager.
Have you run the package or edit it in VS to see if there are more messages.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi Team,
I have six .dtsx packages. The packages read flat files and insert the data from the flat files into the database tables. I reset the password of the DB account(account name , say VISH) in the DB server. After resetting, I cloned the MyAppETL repository from bitbucket(the repository that contains the .dtsx packages,.sln file ), then updated the new password in all the dtsx packages using VS pro. There were some errors that prevented execution initially, but managed to resolve those errors and the .dtsx files ran successfully in my local. Then I copy pasted all the 6 packages from my local into development server(it is a network server, //servername/). In the location //servername/folderpath/MyAPPETL, there will be 6 .dtsx packages, 1 dtsconfig file and ssis_log_settings.xml file. This .dtsx file paths are configured in SQL server agent job(SSMS) that runs everyday at a scheduled time. Each step in the job executes a .dtsx file. So there are 6 steps in the SQL server agent job. A service account runs the job everyday.
Noticed that all the steps of the job fails. Given below is the error message found in Job history for the first step :
Microsoft (R) SQL Server Execute Package Utility Version 13.0.6300.2 for 64-bit Copyright (C) 2016 Microsoft. All rights reserved. Started: 6:53:21 PM Error: 2024-09-27 18:53:21.62 Code: 0xC0010018 Source: LoadFirstStep Description: Error loading value "www.microsoft.com/SqlServer/Dts"><DTS:ConnectionManager DTS:refId="Package.ConnectionManagers[FIRSTSTEP ARLBALS]" DTS:CreationName="FLATFILE" DTS:DTSID="{<some_id>}" DTS:ObjectName="FIRSTSTEP ARLBALS"><DT" from node "DTS:ConnectionManagers".
End Error Could not load package "\servername\folderpath\MyAppETL\LoadFirstStep.dtsx" because of error 0xC0010014. Description: The package failed to load due to error 0xC0010014 "One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.". This occurs when CPackage::LoadFromXML fails. Source: LoadFirstStep Started: 6:53:21 PM Finished: 6:53:21 PM Elapsed: 0.312 seconds. The package could not be loaded. The step failed.
Hi @Vishnu Narayan,
Seems that the error is related with the connection manager.
Have you run the package or edit it in VS to see if there are more messages.