pgoledb.com

PGNP Provider Users' Forum

Skip to content

Assertion Error on INSERT

Using PGNP with MS SQL Server, Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Linked Servers, Snapshot and Transactional Replication and more.
Post a reply

Re: Assertion Error on INSERT

Postby rshapiro » Thu May 20, 2010 10:05 am

This issue has been resolved. The problem was traced to NULL values in text fields that SQL Server 2005 (9.0.4035) was not translating. The issue is fixed in SQL Server 2008. I am working around the problem by converting the NULL values to empty strings using the ISNULL function.
rshapiro
 
Posts: 8
Joined: Wed Feb 10, 2010 8:42 am
Top

Re: Assertion Error on INSERT

Postby Moderator » Thu May 20, 2010 10:51 am

Thank you for the update!
User avatar
Moderator
Site Admin
 
Posts: 235
Joined: Wed Oct 29, 2008 11:27 pm
Top
Previous
Post a reply

Return to SQL Server/DTS/SSIS/Linked servers/Replication

Who is online

Users browsing this forum: No registered users and 1 guest

Powered by phpBB® Forum Software © phpBB Group
cron