Sorry... Forgot to update the forum..

Thats exactly what I did and it worked!!

Max

Hello

I am having the exact same issuse and changing the order is not helping me...

Summary of the problem:

SELECT a,b,c,, getdate() -90 AS defaultstartdate, getdate()-60 AS defaultenddate

FROM x,y,z

WHERE x.date BETWEEN @startdate...

Thanks guys for your help... But I think I figured out a work around by using case....

SELECT a,b,c

FROM x,y,z,u

WHERE

x.id = y.id

AND y.num = z.num

AND u.loginid = @REPORTUSER

AND u.id =...

Nevermind guys... I think I figured out a workaround... I change the conenction to ODBC instead of OLE DB and looks like it is working now.... Thanks for all your...

Yes... Right where the select statement is...

Yes it is in a dataflow... When I try to cast it in the select statement in source, i get a DTS_E_OLEDBERROR --> "An OLE DB record is available. Source:"(null)"...

yeah I dont think thats it...

After a lot of investigation and debugging, I've found that its failing at one specific row and only thing that I can see different...

External Data is DT_TEXT

Output Data was DT_IMAGE... I even tried changing this to DT_TEXT.... still failed

Forgot to mention...

The source table has about a million records and the field with 'text' data type has paragraphs of unknown length and all kinds of special characters...

Also... this package...