No components in SSIS toolbox

No components in SSIS toolbox

Postby 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?
IanCockcroft
 
Posts: 2
Joined: Thu 17 Aug 2017 12:12

Re: No components in SSIS toolbox

Postby 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.
Shalex
Devart Team
 
Posts: 7780
Joined: Thu 14 Aug 2008 12:44

Re: No components in SSIS toolbox

Postby 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?
IanCockcroft
 
Posts: 2
Joined: Thu 17 Aug 2017 12:12

Re: No components in SSIS toolbox

Postby Shalex » Fri 18 Aug 2017 10:59

We will support SSIS for VS2017 after it is released.
Shalex
Devart Team
 
Posts: 7780
Joined: Thu 14 Aug 2008 12:44

Re: No components in SSIS toolbox

Postby 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?
gsergii
 
Posts: 2
Joined: Thu 16 Nov 2017 09:58

Re: No components in SSIS toolbox

Postby 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.
Shalex
Devart Team
 
Posts: 7780
Joined: Thu 14 Aug 2008 12:44


Return to SSIS Data Flow Components