Could not load package xxxxx because of error 0xC0014062
Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80004005 (Login Timeout Expired). The SQL statement that was issued has failed.
I have a SSIS package that executes fine through BIDS, but when execute the same using dtexec, I am gettig the above error:
The DTEXEC command is as below:
dtexec /Server LOCAL /SQL MIGRATE_FROM_ACQ
BUT IF I GIVE THE NAME OF THE SERVER IN THE COMMAND AS BELOW
dtexec /Server WIN-LCIHG6EMFGN /SQL MIGRATE_FROM_ACQ
I am getting the error as Option -LCIHG6EMFGN is not valid, eventhough I used square brackets while giving the server name as [WIN-LCIHG6EMFGN ]
Could some one provide the solution for the above problem that I am facing?