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 GP (Archived) / Copying Employee Card ...
Microsoft Dynamics GP (Archived)

Copying Employee Card info from Company A to Company B

(0) ShareShare
ReportReport
Posted on by Community Member

We are on GP 2010 and SQL 2012, and starting a "new" Company, but with the same Employees. I found a method of copying the Tables from one Company to another, but it fails with: 

"Failure inserting into the read-only column "DEX_ROW_ID". - because of the timestamp fields. It fails on EVERY table, so I'm guessing this probably worked in a prior version of GP.

So...is there any way, even using Integration Manager, to copy the existing Employee Card information to another Company?

*This post is locked for comments

I have the same question (0)
  • MattPaulen Profile Picture
    MattPaulen 6,912 on at
    RE: Copying Employee Card info from Company A to Company B

    Are you using the SQL Import/Export function?  If so, by toggling the Enable Identity Insert checkbox, that should take care of the DEX_ROW_ID

  • Community Member Profile Picture
    Community Member on at
    RE: Copying Employee Card info from Company A to Company B

    Thanks, Matt. Unfortunately, I tried that option and still receive the following error. This error has not changed:

    Validating (Error)

    Messages

    Error 0xc0202049: Data Flow Task 1: Failure inserting into the read-only column "DEX_ROW_ID".

    (SQL Server Import and Export Wizard)

    Error 0xc0202045: Data Flow Task 1: Column metadata validation failed.

    (SQL Server Import and Export Wizard)

    Error 0xc004706b: Data Flow Task 1: "component "Destination - UPR00100" (253)" failed validation and returned validation status "VS_ISBROKEN".

    (SQL Server Import and Export Wizard)

    Error 0xc004700c: Data Flow Task 1: One or more component failed validation.

    (SQL Server Import and Export Wizard)

    Error 0xc0024107: Data Flow Task 1: There were errors during task validation.

    (SQL Server Import and Export Wizard)

    I can remove one Table at a time, but it will only fail again on the next Table it tries. I am logged in as "sa" and using those credentials to run the Export and Import function on SQL 2012.

  • MattPaulen Profile Picture
    MattPaulen 6,912 on at
    RE: Copying Employee Card info from Company A to Company B

    Hmm, can't say I've ever run in to that before and I've copied employee data multiple times.  I just tried it with SQL2012 and GP 2015 R2 and it worked for me.

    Maybe try this? www.sqlteam.com/.../topic.asp

    It sounds like you can ignore the DEX_ROW_ID and DEX_ROW_TS specifically (although I'm not sure if it will still populate it in the destination table).

  • Community Member Profile Picture
    Community Member on at
    RE: Copying Employee Card info from Company A to Company B

    Unfortunately, no. Continues through to a different error, below. I have checked, and I do not have NULL as an input option. I tired "ignore" and I tried allowing the default value of DEX_ROW_ID, and it still fails with the following error:

    Error 0xc0202009: Data Flow Task 1: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.

    An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 10.0"  Hresult: 0x80004005  Description: "The statement has been terminated.".

    An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 10.0"  Hresult: 0x80004005  Description: "Cannot insert the value NULL into column 'DEX_ROW_ID', table 'HLDTN.dbo.UPR00100'; column does not allow nulls. INSERT fails.".

    (SQL Server Import and Export Wizard)

  • Community Member Profile Picture
    Community Member on at
    RE: Copying Employee Card info from Company A to Company B

    I used the option to Delete the Rows in the Destination along with the Enable Identity option and that seems to be working. I am checking the data now. This is a totally "new" Company with zero data in it, so deleting the existing Rows was an option.

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: Copying Employee Card info from Company A to Company B

    Matt, thanks for your help and suggestions. The 'Enable Identity" worked along with the "Delete Rows in Destination." Since there was really no data whatsoever in the target database, this seemed to be worth an effort. That did the trick.

  • MattPaulen Profile Picture
    MattPaulen 6,912 on at
    RE: Copying Employee Card info from Company A to Company B

    Glad you were able to get it to work.

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…

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 GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans