Lynn Pettis (2/16/2010)

---

Elliott W (2/16/2010)

---

I just needed to vent a little bit..

I see that it was in the 7, 2000 group but the title is:

Dynamic Connection TO DIFFERENT...

We have our SSIS packages setup to use dynamic connections. Works great and is easy to do in SSIS. In fact, I think it is easier is SSIS...

Elliott W (2/16/2010)

---

I just needed to vent a little bit..

I see that it was in the 7, 2000 group but the title is:

Dynamic Connection TO DIFFERENT INSTANCES in...

CirquedeSQLeil (2/16/2010)

---

Elliott W (2/16/2010)

---

Grrrr..

Do people not know how to read these days..

Between me and another prominent poster we provided an answer and a link to exactly do the answer. ...

Only problem I see with the solution provided, it doesn't work in SQL Server 7/2000 which is where this post occurs as it is for SSIS, not DTS.

Not really. That was his...

D.Oc (2/13/2010)

---

RBarryYoung (2/12/2010)

---

GSquared (2/12/2010)

---

I'm not sure that's the tag you wanted, Wayne.

Dictionary definition: physic noun: ...

Great. Now, keep an eye on this thread as you may find others that may show you another way to accomplish the task as well. This will give...

The best way to learn SSIS is to use it. I learned SSIS by using it to replace a DTS process written by my predecessor. The DTS process...

Not to be a kill joy, but don't you think you should look at the code provided and see if you can make the necessary changes to format the output...

Duplicate post. Problem is being worked and answered here.

lobbymuncher (2/11/2010)

---

Lynn Pettis (2/11/2010)

---

I may be confused on how things are applied. Could you take one set of records and show how the business rules work to generate one...

CooLDBA (2/11/2010)

---

I was able to change the data to

08-24-2004

08-25-2004

08-26-2004

select CONVERT(datetime, F3, 103) from _CalendarDate

Msg 242, Level 16, State 3, Line 1

The conversion of a char data type to a datetime...

I may be confused on how things are applied. Could you take one set of records and show how the business rules work to generate one of the sample...

Only thing I can think of is to build the query dynamically and execut the query at the end of the try block.