I have implemented pretty much the same solution as Grant mentions with my current employer. To help with your bandwidth issue do you have the option of creating a...

Is your database 37GB in size or the drive its currently hosted on only 37GB?

You can take your database offline, move the physical files and bring the database back online...

As i quoted already from the official AWS documentation you cannot utilise SSIS in RDS SQL Server instances currently as its not supported.

One option you have is to...

Not sure which of your posts on this i should reply on however, this is covered in the AWS documentation:

http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_SQLServer.html

While Amazon RDS doesn't support some features of SQL Server, you...

Personally I'd start with the basics, do you know what stored procedures \ sql code is being executed by the application that is timing out? Most applications have...

As GilaMonster has already answered no its not possible, what is possible though and whilst its not true load balancing is to mirror \ log ship \ replicate from...

I'd very much 2nd this, Itzik really does write some excellent material when...

One way is via a script task or process task, before trying to use the file test if it is locked and only proceed if it isn't. ...

Thanks, I checked MSTSC on all servers involved was running but not the config, wil post back if this is the answer.

Unfortunately that doesn't happen with ours, we tried leaving one package for over 10 hours and it never moved on. The particular package we tested with has not...

Jeff Moden (12/17/2015)

Johnny B (12/17/2015)

I've been asked to check the jobs and sql logs for 6 production servers. Two of them are SQL2000 the rest 2008 R2. I don't mind...

Commenting so I can follow the responses, we are getting the same intermittently on a server for the last 2 weeks.

Package starts, validates then does nothing on the first...

Using only Powershell you can do this:

[System.Data.Sql.SqlDataSourceEnumerator]::Instance.GetDataSources() | SELECT ServerName | Format-Table -HideTableHeaders

One thing I have noticed is that your procedure that inserts into the in memory table is reading from a disk based table to do the insert.

Having not used in...

This is how we have done it.

Export from MySQL to CSV File

Import from CSV File to SQL Server.

All done via SSIS with the export being controlled by a process task...