Novice, sorry, this completely fell off my radar and I saw it cleaning out some old stuff. Are you still having issues with this? If so, I can...

Another option, if you don't want to fire up CLR, is to use SSIS and a script component.

In a dataflow task, pull the table into the dataflow. ...

Msg 102, Level 15, State 1, Line 19

Incorrect syntax near ','.

Msg 102, Level 15, State 1, Line 34

Incorrect syntax near ','.

Msg 102, Level 15, State 1, Line 49

Incorrect...

bullo (4/3/2012)

---

If I run this test against MS Access or MySql it takes aprox. 4000ms.

If I run this test against Sql Server takes aprox. 8800ms. !!!!!!

why is that?? again...if I...

NuNn DaddY (4/3/2012)

---

Is there anyway I could "point" my local copy of BIDS to the SQL Server that has Integration Services installed on it so I no longer receive this...

Lynn Pettis (4/3/2012)

---

Not you either, but I just saw another who should...

GilaMonster (4/3/2012)

---

Evil Kraig F (4/3/2012)

---

mathew.walters (4/3/2012)

---

Evil Kraig, your statement is incorrect, the host_name() function retrieves the host name of the machine making the request, I have used it in the...

mathew.walters (4/3/2012)

---

Evil Kraig, your statement is incorrect, the host_name() function retrieves the host name of the machine making the request, I have used it in the past for auditing of...

S_Kumar_S (4/3/2012)

---

Moreover since all developers use common login, it will be of no use to add such column to table.

What I need is a way to capture the hostname who...

AIRWALKER-375999 (4/3/2012)

---

opc.three (4/2/2012)

---

You may not need to rig something like that up. What event are you waiting to see happen before your Script Tasks do work? Are you by chance...

Steve, looks like you'll be coming to SQLSaturday in Phoenix. It will be a pleasure to meet you. Looking forward to it more now. 🙂

If you can take a look at the first link in my signature (the left side ones) you'll see a way to present data that makes it easy for us...

O.o Huh?

L' Eomot Inversé (4/2/2012)

---

Anyway, it's all an evil plot by Craig to kill off the top point scorers - anyone with more than about 5000 points - so that he...

bullo (4/2/2012)

---

Hi, thank you for reading my first post.

I’m migrating a Classic ASP app from ACCESS to SQL Server. I RE-wrote queries, I’m not using Access with Linked Tables to...