Solution:

The Flat File Connection Manager had the Text qualifier as _x0022_. When I changed it to " (double quotes) on the production SSIS package it works as advertised.

Thanks for...

Thanks for the quick response.

What I find interesting is that the package works fine when I point to Development which was used to restore the production database.

Figured it out

Since the field was being used as a @parameter, I added created the IIF based on the @parameter and and not the dataset field

Let me try to make my question a little complicated.

What would be the simplest way to shrink the table.

1. Drop/Create /put data back

2.Drop Database

3. No Idea :o)

TIA

For some reason this table has records that are not getting removed during ghost clean up. I have tried rebuild/reorg and dbshrink (both db and files).

No Text/image columns - there are XML columns though

I ran the following:

declare @DBID int, @ObjID int

select @ObjID= OBJECT_ID(N'')

select @DBID=db_id()

SELECT alloc_unit_type_desc, page_count, avg_page_space_used_in_percent, record_count, *

FROM sys.dm_db_index_physical_stats(@DBID, @ObjID, NULL, NULL , 'Detailed');

And...

I apologise!

Reverse the data and reserved numbers for both databases.

Yes, I have sp_spaceused @updateusage=true (for both databases)

The ldf file is very small and percent free is about98 percent.

spaceused on table shows reserved 110.1GB and data 110.5Gb and unused 650MB

Hovever, when this database is backed up and...