Running SSIS package in cmd with config file but encounters error

Question

Hello there.

I have created several SSIS packages to import CSV files into a SQL Server database.

Inside the packages, the connection to the SQL Server database is defined. And running with dtexec cmd it works fine.

I have saved the InitialCatalog, Password, ServerName, and UserName in the config file, and modified the ServerName ConfiguredValue so that it would refer to a different database in the same server.

I run the SSIS package with the dtexec command and an additional /conf argument pointing the modified config file. And I deleted the original config file.

However a timeout error was encountered.

Since it is same server, but only different database destinations, I don't see how this is possible.

Am I missing something here?

Fyi the following is the config file, I only changed the ServerName ConfiguredValue from "nee-bi-ec2\BI" to "nee-bi-ec2\BI_Test".

<?xml version="1.0"?>
<DTSConfiguration>
<Configuration ConfiguredType="Property" Path="\Package.Connections[nee-bi-ec2\BI.BI].Properties[InitialCatalog]" ValueType="String">
    <ConfiguredValue>BI</ConfiguredValue>
</Configuration>
<Configuration ConfiguredType="Property" Path="\Package.Connections[nee-bi-ec2\BI.BI].Properties[Password]" ValueType="String">
    <ConfiguredValue></ConfiguredValue>
</Configuration>
<Configuration ConfiguredType="Property" Path="\Package.Connections[nee-bi-ec2\BI.BI].Properties[ServerName]" ValueType="String">
    <ConfiguredValue>nee-bi-ec2\BI_Test</ConfiguredValue>
</Configuration>
<Configuration ConfiguredType="Property" Path="\Package.Connections[nee-bi-ec2\BI.BI].Properties[UserName]" ValueType="String">
    <ConfiguredValue></ConfiguredValue>
</Configuration>
</DTSConfiguration>

Thanks in advance.

Best,

Roxie