web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Software requirements ...
Microsoft Dynamics CRM (Archived)

Software requirements for SSIS package development

(0) ShareShare
ReportReport
Posted on by balakrishna uppala 570

Hi,

In my CRM 365 online project, i need to migrate data from Excel sheets. I am planning to use SSIS with Kingswaysoft.

What are all the softwares that are required to Install SSIS.

I just need one time migration, no need of scheduling the package or deployments.

Softwares required for SSIS development?

Thanks

Krishna

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    gdas Profile Picture
    gdas 50,091 Moderator on at
    RE: Software requirements for SSIS package development

    Hi Bala ,

    Please check here , all the prerequisite are mentioned  -

    www.kingswaysoft.com/.../download

    www.kingswaysoft.com/.../help-manual

  • balakrishna uppala Profile Picture
    balakrishna uppala 570 on at
    RE: Software requirements for SSIS package development

    Hi Goutam,

    Thanks for your reply!

    I have already seen those but didn't understand clearly.

    Basically what i want to Know is,

    Can we install SSDT(SSIS) without SQL Server?

    Also SSDT without Visual Studio.

    My client side, they don't have licences for any softwares, so to develop SSIS package and to one-time data migration what are all the licences i have to buy.

    If SQL Server is required, are there any trail instances of SQL servers can I use for 2months development?

  • Verified answer
    gdas Profile Picture
    gdas 50,091 Moderator on at
    RE: Software requirements for SSIS package development

    As per my knowledge here is your answers -

    Can we install SSDT(SSIS) without SQL Server?

    You can but you have to download the SQL server to install only SSIS as well, so its better to install complete setup SQL server with SSIS.

    check this - docs.microsoft.com/.../install-integration-services

    You can install & use SSDT (BI) without  Visual Studio installed. If no VS is installed, then the free "Visual Studio - Integrated Shell" will be installed. You can get it here-

    docs.microsoft.com/.../download-sql-server-data-tools-ssdt

    You can get more than 2 months trial , check here -

    www.microsoft.com/.../sql-server-downloads

    BTW why you are going to use data migration if you have excel data? You can use configuration migration tool inside SDK , also you can use bulk  import as well.

  • balakrishna uppala Profile Picture
    balakrishna uppala 570 on at
    RE: Software requirements for SSIS package development

    Hi Goutam,

    Thanks for your reply!

    "BTW why you are going to use data migration if you have excel data? You can use configuration migration tool inside SDK , also you can use bulk  import as well."

    I have to import few thousands of contact records in different excel sheets. I need to insert few of them and update some of them in CRM.

    Also they have some N:N relationships exists. Not only contacts i have to import data of around 10 entities. so wanted to do with SSIS.

    'Bulk import', do you mean CRM data import?. As there are many record update scenarios it is difficult to do it manual comparision. Also this needs to be done in 2 other environments.

  • gdas Profile Picture
    gdas 50,091 Moderator on at
    RE: Software requirements for SSIS package development

    Okay great then proceed with SSIS KingswaySoft.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
HR-09070029-0 Profile Picture

HR-09070029-0 2

#1
UllrSki Profile Picture

UllrSki 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans