SSIS 2008

More
10 years 9 months ago #158 by shoubs
shoubs replied the topic: Re: SSIS 2008

Moderator wrote: I've got the schema and am working on the datetime issue as well. Will let you know results asap.

Cool. Did you find anything that gives you an idea of what might be wrong?

Please Log in or Create an account to join the conversation.

More
10 years 9 months ago #160 by Moderator
Moderator replied the topic: Re: SSIS 2008
Nope, I still cannot reproduce the issue. I have created OLEDB source and set of variables for INSERT command with parameters. Then executed the package and found that the record was successfully inserted and the values were correct.

Then I have tested with BULK_METHOD=COPY. It worked right as well.

What could be different in the way I test and your tests?

Please Log in or Create an account to join the conversation.

More
10 years 9 months ago #161 by shoubs
shoubs replied the topic: Re: SSIS 2008

Moderator wrote: OLEDB source


We are using SQL Task, not OLEDB source. It didn't occur to me even that you could insert into a source (I thought I was for extracting data - so it looks like source and destination are almost the same thing),

So SQL TASK is what I am using in the CONTROL FLOW.

Please Log in or Create an account to join the conversation.

More
10 years 9 months ago #162 by Moderator
Moderator replied the topic: Re: SSIS 2008
I have sent you a fixed build (with fix for DateTime corruption issue).

Please Log in or Create an account to join the conversation.

More
10 years 9 months ago #163 by shoubs
shoubs replied the topic: Re: SSIS 2008

Moderator wrote: I have sent you a fixed build (with fix for DateTime corruption issue).

Thank you, please see my email for more details (TRUNCATE TABLE no longer works).

Please Log in or Create an account to join the conversation.

More
10 years 9 months ago #164 by shoubs
shoubs replied the topic: Re: SSIS 2008
Here's a question you might know a quick answer to: I'm using retain connection for a couple of the querys (so I can get an id of a serial col) but the connection stays open. I want to close that connection to the database (or all connections) so I can do a VACUUM FULL FREEZE ANALYZE at the end of my process. Any idea's?


The weird problem I'm having is something to do with the data - there are 211 rows, if I reduce the number to 1, it works. There must be some data problem somewhere, and the provider may not be handling the exception?

There appears to be a lot of cells with '' as the value (thats two single quotes) or problems with extended characts such as @ and . (dot) That wouldn't be a problem would it?

Please Log in or Create an account to join the conversation.

More
10 years 9 months ago #165 by Moderator
Moderator replied the topic: Re: SSIS 2008
I cann't answer it from top of my head. Let me experiment with the connection a little bit...

I do not exclude chance that there is a bug that we and our existing clients have not discovered yet. Could you provide more details about your insert/update scenario? Could you narrow the issue to smaller number of records and possibly send us some that we could use for reproduction?

Thank you very much!

Please Log in or Create an account to join the conversation.

More
10 years 9 months ago #166 by shoubs
shoubs replied the topic: Re: SSIS 2008

Moderator wrote: Could you narrow the issue to smaller number of records and possibly send us some that we could use for reproduction?

Thank you very much!


I found it - see the email I sent you, Could it be a problem with a NULL constraint - one field has a value of NOT NULL and has two single quotes in it. When you select this it appears to show NULL.

Please Log in or Create an account to join the conversation.

More
10 years 9 months ago #167 by Moderator
Moderator replied the topic: Re: SSIS 2008
Yes, the defect is reproducible and we are working on the fix.

Please Log in or Create an account to join the conversation.

More
10 years 9 months ago #168 by shoubs
shoubs replied the topic: Re: SSIS 2008

Moderator wrote: Yes, the defect is reproducible and we are working on the fix.


Cool, what was the problem?

Please Log in or Create an account to join the conversation.

More
10 years 9 months ago #169 by Moderator
Moderator replied the topic: Re: SSIS 2008
The issue was caused by bug in formatting data for bulk insert. PGNProfiler shows following error during data flow execution:
Client SQL
PQputCopyData
Error
ERROR: null value in column "groupname" violates not-null constraint
CONTEXT: COPY tmp_groupowner, line 1: "172|||||||||||0|0|01/01/2007 12:00:00|0|f"

I could not initially reproduce it because I did not use BULK_METHOD=COPY in connection string. Will send you fixed build shortly.

Please Log in or Create an account to join the conversation.

More
10 years 9 months ago #170 by shoubs
shoubs replied the topic: Re: SSIS 2008

Moderator wrote: Will send you fixed build shortly.


Thanks. Are there any instructions on useing the profiler? I haven't looked at it to be honest.

Please Log in or Create an account to join the conversation.

More
10 years 9 months ago #171 by Moderator
Moderator replied the topic: Re: SSIS 2008
yes, there is some info in downloadable Developer Manual.

Please Log in or Create an account to join the conversation.

More
10 years 8 months ago #172 by shoubs
shoubs replied the topic: Re: SSIS 2008
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.

Please Log in or Create an account to join the conversation.

More
10 years 8 months ago #173 by Moderator
Moderator replied the topic: Re: SSIS 2008
The bugs are reproducible. I will send you fixed build as soon as it is ready (in couple of days).

Please Log in or Create an account to join the conversation.

More
10 years 6 months ago #219 by rjamla
rjamla replied the topic: Re: SSIS 2008
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,

Please Log in or Create an account to join the conversation.

Time to create page: 0.124 seconds
Powered by Kunena Forum