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

Announcements

Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Can we use same packag...
Microsoft Dynamics CRM (Archived)

Can we use same package for the same db but for different company

(1) ShareShare
ReportReport
Posted on by sandeepc 5,516

Since it looks like it is from the same XYZ DB but a different company we should be able to use the same package???

 The new instance is just a new company that will reside in the xyz database.  

Can we use same package for the same db 

We need to pull account related information into CRM from this new  NAV instance. I don’t want to build new packages unless it is absolutely necessary as maintenance becomes an issue 

*This post is locked for comments

I have the same question (0)
  • sandeepc Profile Picture
    sandeepc 5,516 on at

    any suggestions 

  • sandeepc Profile Picture
    sandeepc 5,516 on at

    any suggestions

  • Verified answer
    a33ik Profile Picture
    a33ik 84,331 Most Valuable Professional on at

    Sandeep,

    I'm really sorry but your question is confusing and not clear. If you can extend it and explain everything in detail - in that case you can get suggestions/answer. May be.

  • sandeepc Profile Picture
    sandeepc 5,516 on at

    I have 1 ssis package . now we have one new company name xyz . can we have same ssis package or we need to add new ssis package

  • Verified answer
    Ben Thompson Profile Picture
    Ben Thompson 6,350 on at

    Sandeep,

    From rereading the question you seem to have a single CRM instance and 1 Nav instance with a set of packages that connect the 2 systems.

    You also seem to have a new (second) NAV instance. Are you getting another CRM instance or does this second NAV instance need to talk to the same CRM instance the current NAV instance is talking to?

  • sandeepc Profile Picture
    sandeepc 5,516 on at

    yes @ben

  • sandeepc Profile Picture
    sandeepc 5,516 on at

    we are trying to get  second NAV instance need to talk to the same CRM instance the current NAV instance is talking to?

  • sandeepc Profile Picture
    sandeepc 5,516 on at

    We need to pull account related information into CRM from this new  NAV instance. I don’t want to build new packages unless it is absolutely necessary as maintenance becomes an issue . Since it looks like it is from the same xyz DB but a different company we should be able to use the same package – just add unions for new company in selects from NAV?

    May be we need to add fields into your staging/temp tables for company so we know which account is for which company? we might have to update the new fields for existing data with xyz company?

  • sandeepc Profile Picture
    sandeepc 5,516 on at

    any suggestions ben

  • Verified answer
    Ben Thompson Profile Picture
    Ben Thompson 6,350 on at

    If the data is going from NAV to CRM (and not the other way around) you will be able to use the same template across both instances. However you will need some flag in the  CRM system to identify which NAV system the customer belongs to which will mean you will need to add a flag attribute in CRM for the system and find a means (within the SSIS configuration file) to ensure the SSIS package populates that flag within the appropriate details...

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

Check out the Community Spotlight Video Series

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans