Hi,

Thanks both for your replies and help.

Scott, That's brilliant, and has solved the puzzle. I applied it to my work example and removed this bit:

ROW_NUMBER() over(order by AccountNumber) as...

This post just saved the day for me as well.

I had 3 scripts of third party code that I was combining into a single sproc. In the original code there...

Hi all,

I've been experiencing this problem as well recently. It was driving me mad until I found this thread!

Thanks SQLDuck for the solution that worked for me

Lins

Hi Orlando,

Thanks so much. That works perfectly!

I had't thought about it in those terms at all, and it makes sense to.

Cheers loads for such a speedy solution.

Lins

Not sure if it's weird to reply to my own thread(!) but this does seem to work loads better:

select year(fh.transaction_date) as [year]

, month(fh.transaction_date) as [month]

, sum(amount) as total

, floor(datediff(dd,c.date_of_birth,fh.transaction_date)/365.23076923074) as...

After trying a test OpenQuery on a table and seeing how slowly it ran, that's definitely my plan!

I think I'll have a daily rebuild and then build packages to run...

yes, that makes sense. I can visualise how that could work and it strikes me that I could use the SSIS packages for an initial load and then use OPENQUERY...

Hi Phil

I just had a look at some of the key ones and they do yes.

The PL/SQL datatype is datetime2, but it looks as thought the time isn't captured...

thanks

Lins

Hi Koen,

That works! Thanks loads. After a few days of wrestling with that it's great to see that agent job status finally say 'Success'.

I spoke to my boss about this...

Hi all,

Thanks for your suggestions, they've been really helpful.

I've been making some progress, but SQL Agent still won't run the job - albeit with a different error message now.

I successfully...

Koen Verbeeck (7/8/2014)

---

You need to store the connection information into a package configuration.

Hi, Thank you for the response. I've read the article and had a look at creating a package...

Thanks for the response. SSIS it is then!

cheers

lins

Hi,

It works! I was just rebuilding it to put together the screenshot for you.

I used the expression as below (using [] around the table name which SSIS has now dropped)

REPLACE(PRECIS,"~","")

and...

Hi Phil, Thanks for the speedy response

i have rewritten the expression as follows:

replace([precis],"~","")

but am still seeing the error msg pasted below.

There seems to be a problem with the input column...