Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

Don't see Kingswaysoft CRM tools in SSIS Toolbox

Posted on by 285

I'm trying to set up the development license version of the Kingswaysoft tool to use with Visual Studio for some CRM data imports. I'm having trouble getting the CRM tools to show up in the SSIS Toolbox though. I manage to connect to my CRM using the Dynamics CRM Connection Manager, but that's it.

I'm using:

  1. Visual Studio 2017
  2. IntegrationToolkit-DynamicsCRM(v7.4)-x64 and IntegrationToolkit-Dynamics365-x64 (tried both)
  3. Standalone SSDT installation
  4. SQL Server 2012 Integration Services
  5. Remote SQL Server 2012 
  6. Remote (not "CRM Online") Dynamics CRM 2015

I haven't found much information on how to troubleshoot this, as googling Kingswaysoft mostly leads to the website, not any install related discussions.

*This post is locked for comments

  • Suggested answer
    Hammed Profile Picture
    Hammed 366 User Group Leader on at
    RE: Don't see Kingswaysoft CRM tools in SSIS Toolbox

    Here how i resolved the issue: community.dynamics.com/.../kingswaysoft-tool-for-microsoft-dynamics-365-not-showing-up-in-the-ssis-toolbox

  • Daniel Cai Profile Picture
    Daniel Cai 935 on at
    RE: Don't see Kingswaysoft CRM tools in SSIS Toolbox

    Such problems do not happen very often to our client installation. Most likely it is an incomplete installation or otherwise, you are in the wrong view with SSDT. Please confirm the following. 

    • You want to make sure that you install our software after your SSDT installation.
    • During the installation, you want to use the Complete or Custom options. We recommend you use the Custom option so that you have the opportunity to review all detected SSIS installations in your system. You want to make sure all SSIS versions have been selected using the Custom option. 
    • You want to make sure that you are in the Data Flow (not Control Flow) view in order to see our components.
    • Lastly, you should review your project’s TargetServerVersion setting. You want to make sure that the TargetServerVersion is one of the SQL Server versions that we provide support for the installed version. For example, if you are running our v21.2 release, we only support up to SQL Server 2019 for this release. If you are running the latest SSDT which might default the TargetServerVersion to SQL Server 2022, you will need to make sure that you have selected a lower TargetServerVersion. SQL Server 2022 support should be available in our next official release. 
  • Hammed Profile Picture
    Hammed 366 User Group Leader on at
    RE: Don't see Kingswaysoft CRM tools in SSIS Toolbox

    @Daniel Cai

    I am having the same issue  but this does not solve my issue.

    I have VS 2019 and installed the latest version of the Kingswaysoft CRM tools in SSIS Toolbox but it doesnt work. I uninstall it and installed the old versions but still got the same issue.

    Please i need help on this.

    I am not sure why we couldnt find information about how to troubleshoot this kind of issue. I only find this one here.

    Please help out. thanks

  • Edwin Hebbink Profile Picture
    Edwin Hebbink 80 on at
    RE: Don't see Kingswaysoft CRM tools in SSIS Toolbox

    After I installed the version that you send me it worked: https://www.kingswaysoft.com/products/ssis-integration-toolkit-for-microsoft-dynamics-365/download

    The problem was that I installed this product: https://www.kingswaysoft.com/products/ssis-productivity-pack/download because if you Google SSIS+Kingswaysoft you get to that page easily 

    Just imagine I have installed this so many times on new computers and am a dev with 20 years of experience and fell for this one 

    Both download pages look alike and if you look in the “C:\Program Files (x86)\Microsoft SQL Server\xxx\DTS\PipelineComponents” folders you see Kingswaysoft dll’s so I was fooled into thinking the installation was done but just not the right one.

    Perhaps someone else will fall for this in the future so that's why I answered you here as well.. 

    Thanks for your help!

  • Daniel Cai Profile Picture
    Daniel Cai 935 on at
    RE: Don't see Kingswaysoft CRM tools in SSIS Toolbox

    Hi Edwin Hebbink, it is very strange that you are still not seeing our components after upgrading to v11. Please reach out to us through email, someone from our team will be able to assist you. 

  • Edwin Hebbink Profile Picture
    Edwin Hebbink 80 on at
    RE: Don't see Kingswaysoft CRM tools in SSIS Toolbox

    I'm experiencing the exact same situation as Flydancer. So after installing the manual v10 package the tools appear but now I get this update screen and downloading and installing the newest version does not work

    6505.kingswaysoft.png

  • Daniel Cai Profile Picture
    Daniel Cai 935 on at
    RE: Don't see Kingswaysoft CRM tools in SSIS Toolbox

    Good catch, Flydancer. With our latest release, the manual installation package should never be needed (we would be happy to look into such situations if that ever happens). For our earlier releases, we do provide a manual installation package which can be used for this situation if upgrading to the latest version is not an option.

  • Suggested answer
    Flydancer Profile Picture
    Flydancer 1,332 on at
    RE: Don't see Kingswaysoft CRM tools in SSIS Toolbox

    I had the same problem but it worked with the "manual installation package" from Kingswayssoft. There doesn't seem to be a manual package for the newest version, look at the archive: www.kingswaysoft.com/.../release-archives

  • Verified answer
    Daniel Cai Profile Picture
    Daniel Cai 935 on at
    RE: Don't see Kingswaysoft CRM tools in SSIS Toolbox

    It is strange that you have found the files there, but not able to see the component under Data Flow view. Try to install the latest release of our software. If it still doesn't help, please reach out to our support channel as Adrian has suggested. We will set up a remote meeting to have a look of the situation.

  • Artemy Profile Picture
    Artemy 285 on at
    RE: Don't see Kingswaysoft CRM tools in SSIS Toolbox

    [quote user="NicholasC"]

    Hi Artemy,

    Have you opened the SSIS Toolbox in a "Data Flow Task"? Because the KWS Tools will only show at that level.

    Otherwise try searching for "KingswaySoft.IntegrationToolkit.DynamicsCrm.dll" under "C:\Program Files (x86)" or "C:\Program Files". If this file can't be found then KingswaySoft wasn't installed correctly.

    Search-for-KWS.png

    [/quote]

    I found the file in multiple locations following this pattern: C:\Program Files (x86)\Microsoft SQL Server\<number>\DTS\<subfolder>\

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans