Also I just became aware of this SSIS component called CodePageConvert that may do you some good....

http://www.microsoft.com/downloads/details.aspx?familyid=9e56417e-23d1-4fd3-8d6d-61314faa2de3&displaylang=en#QuickInfoContainer

Never done this - but I think you would cast all of your incoming data using the COLLATE operator. Looks like there is plenty of detailed info in BOL...

We probably have over a hundred SSIS packages running here, some daily, monthly, some on demand. I think it should work well for you, but as previously mentioned, there is...

Hmm..

I also use Hyperbac on one of our servers. It works a little differently - its a windows service that "intercepts" standard SQL backup commands. If it detects...

SQLEXPRESS is the default instance name for Sql Express, just as MSSQLServer is the default instance name for Standard.

See

http://msdn.microsoft.com/en-us/library/ms143531.aspx

The software used to perform the backup is recorded in the msdb.dbo.backupmediaset table.

In my case if I run:

select software_name from msdb.dbo.backupmediaset

For standard SQL backups I get "Microsoft SQL Server"

When I...

Just a follow up to my auto-grow ordeal.....

I needed to shrink my db from 950GB to 400GB. After several attempts to shrink by small amounts and letting them run for...

Don't know of an article, but if you type "Fuzzy Lookup Transformation " in BOL it will describe it. Assuming you're familiar with SSIS, this is a component in...

I would suggest the "Fuzzy Match" feature in SSIS. I have used it a couple of times to cross reference data between different systems and it has been very...

ODBC should be fine as long as the database user account is only a member of the new ROLE which only has SELECT permissions on the VIEW.

One way I would...

You can restore a SQL 7 backup to a SQL 2005 server

1 - On the SQL 7 box create a SQL Agent job to backup the database to a location...

I think the SQL backup process is very sensitive to latency caused either by the network or perhaps the device you're writing to. I have had issues with this...

Thanks again for the script. I'll be on the look out for your monitoring solution when you get it posted.

Michael,

Thanks for the script. I'll run it during off-peak times and get this file back to a reasonable size eventually.

GSquared,

Yes, now I see the evils of autogrow. I...

Thank you both. I suspected this was the answer, but I just needed to hear it from someone a little more experienced than I am.