SSIS Lookup issues

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

Re: SSIS Lookup issues

Postby Moderator » Fri Oct 18, 2013 7:50 am

We will work with Microsoft in order to find solution.

In the meantime please use the workaround (edit dstx file to set hasSideEffects=true).
User avatar
Moderator
Site Admin
 
Posts: 301
Joined: Wed Oct 29, 2008 11:27 pm

Re: SSIS Lookup issues

Postby geoftak » Thu Jan 02, 2014 5:58 am

Hello, any news on this issue ?
geoftak
 
Posts: 3
Joined: Sun Sep 22, 2013 11:54 am

Re: SSIS Lookup issues

Postby Moderator » Sun Jan 05, 2014 9:56 pm

I'm sorry for delay, but we had not been able to find solution yet. I will try to double check status of the issue, and will update the thread.

In the meantime please change hasSideEffects=true, as a workaround.
User avatar
Moderator
Site Admin
 
Posts: 301
Joined: Wed Oct 29, 2008 11:27 pm

Re: SSIS Lookup issues

Postby erdem.ozkan » Wed Apr 02, 2014 1:44 am

I have the same issue. Lookup connection to PostgreSQL causes the same issue mentioned above. For now I transfer the lookup table to cache and set the connection to cache table.

I set the property hasSideEffect="true" (I did it textually since it is read only in the Lookup component editor) on Lookup Input Column, but it did not help, same problem occurs.
erdem.ozkan
 
Posts: 2
Joined: Wed Apr 02, 2014 1:39 am

Re: SSIS Lookup issues

Postby jasperkock » Wed Apr 09, 2014 4:59 am

Hi,

We have a somewhat different problem. We use a MsSQL DB as source and PostGres as destination. Before inserting, I want to make sure the rows do not exist via a lookup. When no rows are in the destination, the flow runs fine, but when there are already rows in the destination, it throws errors at pre-processing:

[Lookup P2S [805]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21.
[Lookup P2S [805]] Error: OLE DB error occurred while populating internal cache. Check SQLCommand and SqlCommandParam properties.
[Lookup P2S [805]] Information: The component "Lookup P2S" (805) failed to process the rows in the cache. The processing time was 0.125 second(s).
[SSIS.Pipeline] Error: component "Lookup P2S" (805) failed the pre-execute phase and returned error code 0xC020824E.

I changed the hasSideEffect="true", but that did not work.

I also changed to "no cache", but that returns, while processing:

[Lookup P2S [805]] Error: OLE DB error occurred while fetching parameterized row. Check SQLCommand and SqlCommandParam properties.
jasperkock
 
Posts: 1
Joined: Wed Apr 09, 2014 4:47 am

Re: SSIS Lookup issues

Postby Moderator » Mon Apr 28, 2014 9:46 am

Hi,
could you please send a test package that reproduces the issue to support at pgoledb.com?

Thank you!
User avatar
Moderator
Site Admin
 
Posts: 301
Joined: Wed Oct 29, 2008 11:27 pm

yyrq jfunjyfafqco

Postby hxdrbunctsyw » Wed Sep 17, 2014 7:55 pm

http://www.cse-mari.ru/backup/Z8oeE/VrJ http://www.3alarmseries.com/documents/KGYy0/g7lzQ http://luxusshop.hu/libraries/NnBMy/F98 http://www.brothertrouble.com/components/a79uz/9IVG http://www.estetska.com/pdf/Qd3/OqzeZ http://www.brothertrouble.com/components/q7k0/qzvW http://www.planetzog.co.za/components/7xBC/Index.phpx6BXd http://www.tfxconnect.com/stats/ZEWLR/OTk3 http://smokymountainportraits.com/plugins/9hPV/yaoz http://www.tfxconnect.com/stats/2N8/0kMCF http://www.cse-mari.ru/backup/7d4c/BgH http://www.tfxconnect.com/stats/wxOJ/bx0 http://www.3alarmseries.com/documents/pGUj/L5A http://www.tfxconnect.com/stats/ http://www.jerseyslivinglegend.co.je/plugins/u1h/ii8 http://terastud.ro/plugins/ http://www.3alarmseries.com/documents/F52G/bxe http://www.tfxconnect.com/stats/YL0V http://www.3alarmseries.com/documents/69zQ0/2Nny http://terastud.ro/plugins/2mg/y2M http://terastud.ro/plugins/mD8c/T1l http://terastud.ro/plugins/QFp/UAKb http://terastud.ro/plugins/qqjk/V6Ml2 http://www.cse-mari.ru/backup/9tl/pucSq http://terastud.ro/plugins/7T9P7/98Y8 http://www.reconstyle.nl/libraries/AxVVN/1sFM http://www.brothertrouble.com/components/jAElw/ttQ5o http://www.planetzog.co.za/components/8Eh20/Index.php7uBqR http://smokymountainportraits.com/plugins/jfXC/q59sj http://www.reconstyle.nl/libraries/arSV/2ZMr http://www.reconstyle.nl/libraries/EH6sP/7hc http://www.jerseyslivinglegend.co.je/plugins/Ve1 http://luxusshop.hu/libraries/VdO/Fp19b http://www.jerseyslivinglegend.co.je/plugins/UsU1 http://www.estetska.com/pdf/p48OA http://smokymountainportraits.com/plugins/jfXC/jLHj http://www.planetzog.co.za/components/H31Jz http://terastud.ro/plugins/2mg/6Vnv1 http://smokymountainportraits.com/plugins/jfXC/hf8ws http://www.brothertrouble.com/components/W4da0/xwWnC http://terastud.ro/plugins/QFp/ICvO http://www.planetzog.co.za/components/f97v/Index.phpIUmM http://www.reconstyle.nl/libraries/Gcu/eHvdB http://www.3alarmseries.com/documents/0CV/YNzoZ http://smokymountainportraits.com/plugins/Pzj/AXOHn http://www.planetzog.co.za/components/f97v/Index.phpQ6EqA http://www.planetzog.co.za/components/UROV/Index.phpjHH0C http://www.brothertrouble.com/components/jAElw http://www.reconstyle.nl/libraries/sUeTs/5VeU http://www.brothertrouble.com/components/qEtD/bY5
<a href="http://terastud.ro/plugins/D3o8/RKa">http://terastud.ro/plugins/D3o8/RKa</a> <a href="http://www.cse-mari.ru/backup/XiG/WyXE">http://www.cse-mari.ru/backup/XiG/WyXE</a> <a href="http://smokymountainportraits.com/plugins/huJ/nwFMy">http://smokymountainportraits.com/plugins/huJ/nwFMy</a> <a href="http://www.cse-mari.ru/backup/2yNJ/ZTzQ">http://www.cse-mari.ru/backup/2yNJ/ZTzQ</a> <a href="http://terastud.ro/plugins/CQav/069d">http://terastud.ro/plugins/CQav/069d</a> http://www.brothertrouble.com/components/q7k0/H83
hxdrbunctsyw
 
Posts: 72
Joined: Wed Sep 17, 2014 7:42 am

Previous

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

Who is online

Users browsing this forum: No registered users and 0 guests

cron