Thank you so much Jeff.:-)

This Post is closed. I will research the issue.

Thanks.

I'm not concerned that it may grow at the same rate.

I am concerned that it happened.

I want to re-index and I thought that it would not hurt to reduce the...

Greg A Goss (9/17/2014)

---

Personally, the first thing I'd do is find out why it grew like that. Was a large table deleted? Indexes changed, removed? Are...

Post moved to 2008 DBA.

I have a Database that is currently 642 GB is size with 317 GB free (49%).

I do not know how it got so large but what would be the best...

I got it to work.

A SSIS Script task worked.

It was the Database Engine Service Account.

I changed it last night and it worked.

Thanks.

:laugh:

Hi.

Why did you remove your post?

But why am I getting the error?

I installed the 64bit and 32 bit client.

The SSIS Packages having been working...

I should have been more clear. The following return 1 record, there are 30 records in the Oracle table:

SELECT *

FROM OPENQUERY(LS_RDB_DWH_POLICY52, 'SELECT * FROM RDB_DWH_POLICY.STG_BATCH_STATUS')

Lynn Pettis (9/3/2014)

---

Welsh Corgi (9/3/2014)

---

I completed the code two hours ago minutes before a meeting that I had.

Edit:

The off shore people did not create the table that I needed until...

I completed the code two hours ago minutes before a meeting that I had.

Edit:

The off shore people did not create the table that I needed until today so I was...