Have a look at this article, and see whether you can get it working with CHAR(10) + CHAR(13) as a delimiter.

John

Steve is right.  DDL and data would make our task much easier.  Here's a guess in the absence thereof. Have a look at this and at what Thom posted -...

Is there anything in the restorehistory table in msdb?  Maybe not, I suspect - it's not nearly as useful as the backup tables.

John

It's harmless, according to this.  Are you actually using SQL Server 2012?

John

One thing that combines the best of both worlds is to test for existence, and create a stub object if it doesn't exist.  After that, everything is an ALTER.

My advice, if you have any control over this, is to avoid this kind of design.  You've seen how difficult it is to write even the simplest query.  And what...

You're using an Excel Source in your Data Flow task, right?  Why not choose SQL Command for your Data access mode, and then you can write a query that will...

Are you doing Run As Administrator to open Config Manager?  Is there anything in the Windows System and Application event logs that gives more details on why it failed?

Please don't bump your post after only 20 minutes.  You've been around here long enough to know that that's going to annoy people.

Yes, you haven't declared @remotesql1, and...

Right then, as I said, use TRY_CONVERT to identify the offending values.

John