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

Notifications

Announcements

No record found.

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,514

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,514 on at

    any suggestions 

  • sandeepc Profile Picture
    sandeepc 5,514 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,514 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,514 on at

    yes @ben

  • sandeepc Profile Picture
    sandeepc 5,514 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,514 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,514 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

Quick Links

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans