Well I should probably say I'm not an expert in SSIS so there may be an easier way than this, but I would start out with the Import/Export wizard. ...

uk00121 90875 (10/26/2011)

---

Kenneth,

I tried

exec sp_msforeachdb "IF EXISTS (select name, suser_sname(sid) from sys.sysdatabases where suser_sname(sid) IN ('domain\one', 'domain\two')) BEGIN USE ?; sp_changedbowner 'sa' END"

and got error

The identifier that starts with 'IF...

I'm not a CMS expert either but you could try opening a query window that connects to all of your servers (right click on the group heading and select open...

Since its a new virtual machine have you checked with your server admin to see if any changes have been made to the server recently?

I find it odd...

jared-709193 (10/26/2011)

---

Kenneth Fisher-475792 (10/26/2011)

---

First let me point out that people trying to help out on this form are shooting blind. We have to start at the beginning and assume...

Have you thought about using SSIS? Its the tool that is really designed for moving data around, particularly into a data warehouse. There is a steep learning curve...

First let me point out that people trying to help out on this form are shooting blind. We have to start at the beginning and assume nothing. Honestly...

Greg Charles (10/21/2011)

---

john.barry-1031177 (10/21/2011)[hrDont let DTS stop you from migrating/updating to 2005. DTS works fine in 2005. We migrated all of our 2000 databases to 2005 instances two...

It would also help to know what type of "parsing" you are doing. It sounded like the package was stopping at the step between the data load and the...

Good question. I learned something 🙂

drew.allen (10/3/2011)

---

Just because it takes the form of a spreadsheet, doesn't mean that it's not a report. All of the reporting tools that I have worked with are capable...

Actually no, in this case a reporting tool won't work. We get the occasional spreadsheet sent to us by upper management with the task of "filling in the blanks"....

drew.allen (9/30/2011)

---

This is a report and you should be using a reporting tool to generate it. T-SQL is...

Awsome stuff, thank you all. Obviously I need to read up on FOR XML more, I didn't realize it was so useful even when you arn't working directly with...

I was able to resolve the problem by changing the IPALL port to 1433 to match IP1 and IP2.

Does anyone know why this would cause an intermittent connection problem?

Thanks

Kenneth