You might need to change the project properties in SSIS. In the project drop down, click project properties at the bottom. Under Configuration Properties click on Debugging. Change...

Never really found out why this error started occurring all of a sudden. I was able to fix it though. I had to go into the MDS database...

Thanks for the article. 🙂 I have been working with SQL Server for over a year now and didn't know about either of these features.

I just hope I remember...

Thanks Steve. Yeah I restored msdb, but I didn't restore model or master and it seems to be working great. Thanks for all the help!

I am restoring the databases now and am wondering if I need to restore the system databases as well? Do I need to backup and restore the Master and...

Thanks, I'll let you know how it works out. The new servers should be up and running early next week.

If you are restoring over an existing database you need to specify WITH REPLACE. Typically when restoring a database on a different server the RESTORE command will look something like...

Thanks Jack. Is it possible to restore backups to an older version of the database?

What I mean is the database backups will be taken from one server, and then...

It looks like I figured it out.

I had Application.EnableEvents set to False in the code which was preventing the cells to be marked as changed for MDS. I simply...

What if I use the copy database function in SQL Server Management Studio once the new servers are up and running?

If I copy the databases over to the new servers,...

They need to be connected though. If the user makes a change in the store number column the store name column would need to change to the appropriate store....

Changing the column to a period worked, thanks!

I don't understand why this was necessary though. It seems like SSIS should be able to recognize that it was a number...

So I changed up the data flow and set it up to convert the columns to DT_NUMERIC (10,2) before the derived column task and now a different error is coming...

How do I do that from within the SSIS package?

BTW, when I preview the data in the Excel Source editor the decimal numbers look like "0,33" for 0.33.