I do not see any DDL?

Could you include some with sample data?

It seems like? That does not sound very convincing.

You said that the package would be using the...

I saw on the the SQLShare Demos and they used a 3 hints.

They ran profiler, executed the queried and showed what the best hint was in this scenario.

Perhaps that was...

That is set in the Group Policy.

Perhaps this may provide you with some insight.

http://weblogs.asp.net/cabhilash/archive/2010/04/07/login-failed-for-user-sa-because-the-account-is-currently-locked-out-the-system-administrator-can-unlock-it.aspx

Duplicate Post.

http://www.sqlservercentral.com/Forums/Topic1172870-359-1.aspx

Permissions to be set on the Server that is writing to Excel and the Second Server:

http://www.windowsecurity.com/articles/share-permissions.html

If you have issues log on using the Service Account and read a file and...

Did you test using you user Account or the SQL Server Agent Service.

Using Windows Explorer can you navigate to the UNC path and read write to the folder.

You said...

64 bit or 32bit?

What would be better yet if you provided the DDL and sample Insert Statement.;-)

I'm having a little trouble on what youi are doing other you want to extract Data From SQ Server to Excel.

Why don't you try doing real quick ussing the SSIS...

ops. Your suggestion to restore from a backup is good.

I would restore to a non-production server and load the table via SSIS.

What I would suggest as a work around would be to script out the table and modify it to the new name.

Then load it via a query or the SSIS...

I could have swored I did this last night (early morning) but I got an error. :w00t:

2008.

If you are going to take 8GB from the Database and archive it to a Database on the same Server then you are not accomplishing anything with respect to space.

HowardW (9/9/2011)

---

Tried it out, also can't find a work-around (can't rename in the UI either). The only option I can find is to script the table, recreate it as the...