I have developed a package in SQL Server 2017 with TargetVersion 2012 , where the data source is a component for SalesWalk of KingsWaySoft and the destination is my SQL server. If I launch the package from Visual Studio, it works perfectly.
If I launch it from the management studio of the server using a dtexec it gives me an error.
Can someone give me a cable? I enclose the calling code and the error that it returns to me.
Thank you very much in advance.
CALL CALL:
declare @CADENA varchar(300)
SET @CADENA = 'C:\"Program Files (x86)"\"Microsoft SQL Server"0\DTS\Binn\DTExec.exe /FILE "\MAVIEWP01\Test\Test\Test\Test.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EWCDI /DECRYPT "zzzz"'
EXEC MASTER..xp_cmdshell @CADENA --,NO_OUTPUT
Message ERROR:
Description: The connection type "Salesforce (KingswaySoft)" specified for connection manager "Salesforce" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name. Code: 0xC0014005