Are you sure that your destination has been properly shared?

Instead of mapping a drive, try using a UNC (\\ServerName\Directory\[SubDirectory\...]filename).  Be sure that the share permissions are set properly.

Thank you Matt.  I must be suffering from distractionitis, as I did not fully complete my thoughts in my earlier post.

Have you tried BIDS? (Business Intelligence Development Studio)

Cool, one way to use a stored proc as a table.  I would think you would need to be careful doing this, though, by making sure the stored procedure didn't...

Could you provide the code you tried that failed?

If you are constantly shrinking your log file, you are not going to keep it from growing.  Even in simple recovery mode, SQL Server writes all update, delete, and insert...

If this is occuring on a regular basis, you may want to consider keeping the log file at a larger size.  Remember that everytime the log has to grow, your...

Cross posted.  Check here: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=338&messageid=396141

Not that I have found.  You could load a temporary table then query the temporary table.

Since you have the Microsoft SQL Server 2000 DTS Designer Components loaded, you should be able to access the the TS packages using SSMS.  You should access it through the...

You should look into package configuration files in SSIS.  We also use a configuration database to allow us to dynamically configure our SSIS packages simply by making a change to...

Vladan, Be careful using xp_getfiledetails, it goes away when you move to SQL Server 2005.

No.  Only transaction log backups will truncate the transaction log.

Could you post the DDL for one of the procedures?  I'd like to give it a try and see what happens.