SSIS 2008

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 2008

Postby Moderator » Fri Nov 06, 2009 10:23 am

yes, there is some info in downloadable Developer Manual.
User avatar
Moderator
Site Admin
 
Posts: 305
Joined: Wed Oct 29, 2008 11:27 pm

Re: SSIS 2008

Postby shoubs » Tue Nov 10, 2009 8:35 am

Thanks. Your fix worked. I'm testing on the live server over night.

I've sent you another email, - this time I'm trying to use reporting services but having date and interval problems.
shoubs
 
Posts: 40
Joined: Thu Oct 08, 2009 7:47 am

Re: SSIS 2008

Postby Moderator » Wed Nov 11, 2009 8:29 am

The bugs are reproducible. I will send you fixed build as soon as it is ready (in couple of days).
User avatar
Moderator
Site Admin
 
Posts: 305
Joined: Wed Oct 29, 2008 11:27 pm

Re: SSIS 2008

Postby rjamla » Wed Jan 20, 2010 6:02 am

Hi,

I am using PGNP-1.3.0.2124 trial version with SSIS 2008 on 64-bit processor to load data from Postgresl database to sql server 2008 database.
Postgresql database table has 4,937,459 rows but SSIS package insert 313 rows only. Package runs fine giving no error.
I also set CommandTimeout to 3000 but did not help.
I dont understand what is missing here.
Need help.

Thanks,
rjamla
 
Posts: 1
Joined: Wed Jan 20, 2010 5:57 am

Re: SSIS 2008

Postby Moderator » Wed Jan 20, 2010 11:47 pm

This is limitation of the trial version (provider returns first 100 or so rows). Please contact us (support@pgoledb.com) to obtain a special build with trial limitations temporary disabled.

Or purchase developer's license. It should work fine.

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

Previous

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

Who is online

Users browsing this forum: No registered users and 4 guests

cron