I think I see the check box you mentioned, however, Ent mgr crashes when I set up the package:

I set a source of SQL db, a destination of Text file,...

yes, all my databases have the Auto create and auto update options on. That's another reason I'm confused as to why the statistics are missing. Anyone?

Should I use "EXEC sp_createstats" after re-loading each table. This is supposed to create statistics for all eligible columns in all user tables.

1. Is there a problem using this daily...

OK. found the answer why my commands didn't execute: I left SET FMTONLY ON. Once I set it to OFF, my commands worked.

However, I still don't understand why the...

Sorry. I failed to specify, that if the row count is not refreshed in Query Analyzer (after executing DBCC UPDATEUSAGE(0) ), then log into Query Analyzer with a new connection...

After you execute DBCC UPDATEUSAGE(0), you may not see the refresh until you log on using a new connection. The existing connection seems to display the "unrefreshed" results. Anyone know...

If you need only to change the connection parameters (server, database, table name, etc), then I would add a dynamic task, creating a global variable for these. Then you can...

One way is to use the xp_cmdshell to call the DTS command line command. For instance, for the command line command...

DTS /Usa /Ppassword /Sserver /Npackage_name /Mpackage_password 

/A"SQLCatalog:8=dist" /A"SQLTable:8=dist.dbo.co" '

which uses two global...

Got it! Thanks.

I found the problem. It was running a version I had saved before adding the truncate table sql task. I'm not sure why. I had the package open and would...

<...cannot see how this can be done from table to table. You are relying on the dts package knowing which fields to join for starters.>

I was hoping there was...

Sorry. I must be missing something. How can I use a sql task to get data from a source to a destination by executing a simple select * from table...

Jules, thanks a bunch for your comments. Regarding the first one...duh. I should have thought of that. Two, I'll try the performance tip.

Very helpful.

I am using DTS now for reports that don't require real time data. However, I was wanting to implement real replication -- where data is near real time. In which...

I am able to use DTS, but just to pull data blindly into empty tables. Using DTS doesn't allow real time reporting, but I am planning on using it for reports that...