Devart Forums

Hi guys, I am using VS data tools 2015.
I installed the download.Closing VS first.
but the Divart component doesnt appear..
what am i doing wrong?

The components should be available in SIS Toolbox (not Toolbox).

Please reinstall SSIS Data Flow Components in the following way: create a *.bat file with the line "devartssis.exe /log=Install.log" and run it 'As Administrator'. The Install.log file will be created in the folder where the installation file is located.

Now open the Data Flow tab in your *.dtsx package, navigate to View > Other Windows > SSIS Toolbox (not Toolbox), open the Common section. Are there Devart components?

If there are no Devart components in SSIS Toolbox, please make sure that the Devart.SSIS.%ServerName%.*.dll (* means 110/120/130) assembly is present in:

* C:\Program Files (x86)\Microsoft SQL Server\110\DTS\PipelineComponents\
* C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Connections\

* C:\Program Files (x86)\Microsoft SQL Server\120\DTS\PipelineComponents\
* C:\Program Files (x86)\Microsoft SQL Server\120\DTS\Connections\

* C:\Program Files (x86)\Microsoft SQL Server\130\DTS\PipelineComponents\
* C:\Program Files (x86)\Microsoft SQL Server\130\DTS\Connections\

If there is no such assembly, copy it there from the C:\Program Files (x86)\Devart\SSIS Data Flow\Assemblies\ folder.

If Devart SSIS components are still missing in SSIS Toolbox, send us:
1) the generated Install.log file
2) Help > About Microsoft Visual Studio > Copy Info
3) a screenshot of the opened Common section in SSIS Toolbox when the Data Flow tab of *.dtsx [Design] is active

Thanks, I copied the dll's to
* C:\Program Files (x86)\Microsoft SQL Server\140\DTS\PipelineComponents\
seems to have worked.
maybe because i am using SQL SSMS v17.1 and the installer needs to catch up?

We will support SSIS for VS2017 after it is released.

I have a similar issue.
windows 10 x64
installed sql server 2014 express
sql management studio 2017
visual studio 2015
ssdt
devart dotconnect for salesforce, and after installation Devart tools did not appear in SSIS toolbox, so I added file Devart.SSIS.Salesforce.120 to folders
C:\Program Files (x86)\Microsoft SQL Server\140\DTS\Connections\Devart.SSIS.Salesforce.120.dll"
"C:\Program Files (x86)\Microsoft SQL Server\140\DTS\PipelineComponents\Devart.SSIS.Salesforce.120.dll
After that devart tools started to appear in SSIS toolbox and I was able to create a Salesforce Destination, and use Salesforce devart connection. But when executing the package it gave me the following error:

"[SSIS.Pipeline] Error: Cannot find the connection manager with ID "{6913F8B7-B667-4241-B541-1827D6FF4CD1}" in the connection manager collection due to error code 0xC0010009. That connection manager is needed by "Devart Salesforce Destination.Connections[Devart Salesforce]" in the connection manager collection of "Devart Salesforce Destination". Verify that a connection manager in the connection manager collection, Connections, has been created with that ID.
"

What should I check to fix it?

Please right click your SSIS project in Solution Explorer > Properties > Configuration properties > General and specify the value of your TargetServerVersion.

We have supported SQL Server Data Tools (SSDT) 2017.

New version of Devart SSIS Data Flow Components 1.6 is released.
It can be downloaded from https://www.devart.com/ssis/download.html or from Customer Portal (for users with valid subscription only).
For more information, please refer to viewtopic.php?t=36454