I am making the assumption you are running the 32-bit version of SQL Server 2005. With AWE enabled, you may need to remove the 3GB switch and possible need...

The maintenance plan should have created a log file that should provide you more information regarding the error. The error message itself does not provide enough information.

As for controlling...

It will only autoshrink if you have autoshrink turned on (not recommended). You shouldn't shrink the physical size of your transaction log after your log backups as your transaction...

Just to be sure, were you looking at the size of the .ldf file on disk after the BACKUP LOG or were you looking at the space in the .ldf...

Awesome. If you have any advice for a wanna be author let me know by PM and I'll pass on my daughter's email address to you. She really...

Full and Differential backups do not truncate the transaction log. This is only done by a transaction log backupup (BACKUP LOG ...).

You can try this:

exec sp_MSforeachtable 'select ''?'' as TableName, count(*) as RecordCount from ?'

I'm sure others will come up with other solutions as well. 😉

Or is it -5?

😀

What would help would be to see some sample data, just as it is in the original file, just reduce the number of rows to something manageable.

We may (will) have to revisit how we are doing configurations. The process we use now works fine between developing on our workstations and deploying to our development system....

Is there anything in the data to indicate when the data changes from one format to the other?

Personally, different data should be in seperate files.

The book I bought when I started working with SSIS is Professionl SQL Server 2005 Integration Services by WROX. It worked well for me when I first started and...

Can't answer your question(s), yet, as we only have our Data Warehouse development environment at this time. We are still awaiting our QA and Production systems. Here is...

How's this: Let's take a complex process and dissect into it multiple subsystems and make it more complex to understand. If you are writing an ETL system from...