the ssis error said that the odbc link did not support the required odbc level of behaviour or some such words to that effect.

The source of the error was...

this process has been in place for - oh, i dont know - 5 years now.

we pull over 8GB every night.

thats since it was trimmed down - used to be...

Yea there are options to consider.

Unfortunately unloading data to flat files is a no go flat files are all pipe delimited, not text qualified and users type pipes in free...

alas I had feared this to be the case...

Unfortunately there IS NO newer driver! the version of informix is so old that IBM do not release a driver for it...

for info the same error comes up when trying to access as a linked server.

php odbc uses this DSN on this box without issue.

lol it's a program that will be run regularly as part of a big process. the fast execution time going forward is definitely worth 3 hours initial development costs. ;)...

heh heh about 4 hours I think it took me.

The idea behind it was the less steps that had to take place, the less could fall over when processing in...

That's the wierd thing, the IIS box has SQL2005 on it anyway - and has the sqlncli driver selected for this connection.

maybe it's to do with the 'max' setting.

who knows?!

I...

yep thats fixed it.

asp does not seem to like varchar(max) - I can only assume a colleague changed the table for some reason whilst I was on holiday!

appologies for the...

ah.

I've just seen one table has the wrong data types.

I'll play with that and see if it makes a difference...

Hi

Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build...

simply force of habit.

There is a fair amount of missing or incomplete data in my database. Most of my jobs on this server use temporary tables and there are...

hmmm good point

That would have to be done like:

SELECT '"' + REPLACE(someMemoField, '"','') + '"' ...

Manually remove any quotes from the field then add them back in manually?

I dont...

Thanks guys,

Everything on this server is supposed to run sequentially, however, I ran this at the same time as another batch of stored procs were running - it would be...

Maybe when you export from access to CSV, you could concatenate a close quote..

SELECT someMemoField + '"', nextField FROM MyAccessTable