For...

Do you have a firewall on the serve, which is blocking the connection?

Forgot to mention, resolved this in the end. The problem was due to a Server level trigger (one that a another DBA built and has been a bane in by...

I encountered this error about a week ago when trying to deploy as SSIS project. it turned out the problem was due to a trigger. Do you have any triggers...

How are you defining that these numbers are out of order as well? Is there another column we should be checking against that defines the order that your rows are...

Firstly, an explanation of what what you're doing isn't working. Inside your While loop your returning your full dataset, in this case every row that your going to insert, every...

Using the undocumented procedure sp_MSforeachdb (yes, I know some people don't like it), you could do something like this:

USE OpenGI;
GO

Use master;
GO

Are you specifying the port in your Connection string? if not, what happens if you do? So your Server name would be: FJ-SQLDEV1\fjm,55991

What error message are you receiving when you try to connect. What details show in the SQL Server's Logs? Can you ping the server from your machine? After enabling TCP/IP...

I'm with Lowell here. I think this is something I referenced in a previous topic with you.

I'll have a go at decrypting the XML at the office tomorrow,...

If you're using SSISDB, your packages would t be located in MSDB, they'll be in SSISDB. Which are you using?