Hi GilaMonster,

bad design 🙁 At least sql has to inform me about this.

yes, i'm using top and also distinct clause inside the sql statement.

Is there a workaround to order the...

:w00t:

Thank you,

i never thought the float type could be the issue.

Thank you.:-D

I'm testing on a copy of a production table.

Basically i have a ssis package which populate this table.

There are about 100.000 rows 🙂

Its very fast.

🙂

thank you.

here is the code i have used

create the tally table on the TallyTest (taken from the article)

--=============================================================================

-- Setup

--=============================================================================

USE TallyTest

...

What about something like this?

Use mydbTest

GO

CREATE FUNCTION dbo.FirstToken(@Parameter VARCHAR(8000))

RETURNS varchar(500)

AS

BEGIN

RETURN

(

...

Hi Gianluca,

This is the first time i hear about a tally table.

I have simply created a tally table and also executed your script.

It seems not working..

I'm getting as result the...

Hello,

i have again the errors.:crying:

I have tried to execute the package in debug mode and i see that it takes a long time to download the data from the oracle...

i understand.

Thank you.

Elliott W (2/26/2010)

---

I read that as you having picked the view out of the list. If so, replace it with a SELECT * FROM dbo.ViewName. I think you...

Elliott W (2/26/2010)

---

I went back to the original error:

"Cannot get a row from the provider OLE DB "BULK" from the connected server "(null)".".

This is indicative of the provider having trouble...

It allows null values. I dont even need a key for...

No errors when i had executed manually the package this morning.

it happens occasionally.

this is a scheduled package which runs at 03.00 AM...

.

Here is a screenshot of the package. The dataflow marked with red arrows is generating the error.

As i said before, this package grabs 3 tables from a db situated in...