No components in SSIS toolbox

Discussion of issues, suggestions and bugs of Devart SSIS Data Flow Components, our product line for building SSIS-based ETL solutions, performing data access to popular cloud applications and databases.
Post Reply
IanCockcroft
Posts: 2
Joined: Thu 17 Aug 2017 12:12

No components in SSIS toolbox

Post by IanCockcroft » Thu 17 Aug 2017 12:24

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?

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: No components in SSIS toolbox

Post by Shalex » Thu 17 Aug 2017 16:43

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
Last edited by Shalex on Mon 11 Sep 2017 13:18, edited 1 time in total.

IanCockcroft
Posts: 2
Joined: Thu 17 Aug 2017 12:12

Re: No components in SSIS toolbox

Post by IanCockcroft » Fri 18 Aug 2017 08:08

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?

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: No components in SSIS toolbox

Post by Shalex » Fri 18 Aug 2017 10:59

We will support SSIS for VS2017 after it is released.

gsergii
Posts: 2
Joined: Thu 16 Nov 2017 09:58

Re: No components in SSIS toolbox

Post by gsergii » Thu 16 Nov 2017 11:08

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?

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: No components in SSIS toolbox

Post by Shalex » Fri 17 Nov 2017 11:07

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

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: No components in SSIS toolbox

Post by Pinturiccio » Fri 12 Jan 2018 15:13

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

Post Reply