I would think that

TEST\MSSQL2008

or

ServerIP\MSSQL2008

Would work provided you have the Browser service running and the firewall is not blocking UDP 1434 AND the port that SQL is listening on.

CEWII

hiram.osiris (12/14/2011)

---

Hi,

I have created an alias for a named instance in my server, for instance SERVERTWO\MSSQL2008, Alias = TEST.

My instance and Alias are working under the same Port (1433) and...

Basic fact is that the schema of the source and/or destination of a data-flow cannot change at run-time with the delivered components. There is a company called CozyRoc that...

AER (12/14/2011)

---

Hi everybody,

Can I create a new SQL Server login with SQL Server Authentication and assign few individual Users (create a Group) that are the Members of Domain to...

Koen Verbeeck (12/13/2011)

---

Although package configurations are surely the best option, a quick fix is that you get yourself a decent flat file editor and do a search-and-replace in all files...

I feel your pain.. Hope it goes well for you.

CEWII

Elliott Whitlow (12/13/2011)

---

I apologize, in the absence of gender specific identifiers I assume "he". This time I was mistaken.

I would like to understand the process more, because it seems...

I apologize, in the absence of gender specific identifiers I assume "he". This time I was mistaken.

I would like to understand the process more, because it seems odd, with...

Hm, maybe.. He could multi-cast it but I'd like to understand the process before I really offer a solution.

CEWIII

You may not add an output after the OLEDB destination. It is the end of the pipeline for successful records.

However, may I ask a dumb question. You are...

It is possible but a little tricky in that all the nodes must be on the same subnet for SQL 2008 (and R2). My understanding was that SQL 2012...

If it runs in standard it will work just fine in enterprise. Bottom line is that there is no standard edition eval. so you cannot satisfy your requirements using...

I have heard it refered to more as "dev server refresh" or "staging server refresh" where the dev or staging environments are blown away an replaced by scrubbed production versions....

Keeping in mind that SSIS packages when stored in SQL are essentially BLOBs a find and replace is tricky. Also keeping in mind that depending on the contents of...

There really isn't a way to do this legally without going through MS.. You would need a volume license or an MSDN license, or something like software assurance, but...