I feel like unsubscribing from that item but I'm scared to miss out on a few laugh.

We cannot answer that for you.

Just because you did not find any logged information, it does not mean that the package is not used.

You need to decide yourself if it...

I can't answer the exact question you asked but I believe many would agree with me about what caused the problem. It's bad practice to have a hard coded...

Cookies are acceptable,...

Did you open the DTS package and look at the Logging tab? If you did not do that then I do not know why anybody should waste their time...

Lynn Pettis (1/28/2009)

---

Can we actually purchase SQL Server 2008 Developer Edition yet. Last time I looked it still wasn't on the Microsoft website, just SQL Server 2005 Developer Edition....

It's been a few months since I last did an install so I may not remember all the details correctly.

When you install a second instance of SQL Server on a...

Don't forget that the next version of SQL Server will not be out before 2011. Microsoft should not be dropping support for SQL 2005 before 2011 is out. ...

The first thing you have to do is to open up your DTS packages and look at its properties. Go to the "Logging" tab to see what logging option(s)...

Michael Valentine Jones (1/26/2009)

---

I think to qualify as a really bad answer; it has to meet the following requirements:

1. It has to be syntactically correct code that executes and apparently...

Set up your connection manager with static path. Then, before the actual export, use a script task to change the connection string of the connection manager.

One important question when considering options is how much data needs to be transfrerred?

I'm not sure I understand exactly what you're trying to do, but I'd like to offer an alternative solution.

Can you write a query that returns what you want? If...

I use a script task when I need to change the name of an input or output file. In the script I change the connection string for the appropriate...

.... for whatever reasons?

Looks like the active directory team wants to pass the buck and have you do all the work.