Something like this?

SELECT

myID -- something that uniquely identifies your row

,userAccount

,Status = CASE WHEN userAccount IS NULL

...

amit_adarsh (6/14/2012)

---

I don't think the answer is correct for the question (mentioed in screen shot).Because if you write like this , it will create

a key that is...

You have two options:

* reroute all the rows with a ? to another destination or error table/file

* replace thet ? with an actual data

Let me know which one you prefer...

gelli.pavankumar (6/13/2012)

---

hi,

when i run single sql task ,it's working fine. but i put five sql task run parprelly ,i got error like that

"...

Great question Hugo.

This is a statement that supports the answer:

CREATE TABLE dbo.QotD2

(KeyColumn INT NOT NULL PRIMARY KEY

,Test INT NOT NULL

,CONSTRAINT [UX_Test]...

Sorry, but I'm still a bit in the dark how this scenario should be handled.

It does indeed look like you can only reference external packages in the MSDB or on...

L' Eomot Inversé (6/13/2012)

---

Koen Verbeeck (6/13/2012)

---

L' Eomot Inversé (6/13/2012)

---

Interesting question. And straightforward.

I guess calling it a .ispac file instead of a .zip file makes sense if you want to...

KWymore (6/13/2012)

---

It is. It's written by Matt Masson, developer on the SSIS team.

Check out his site, there are also follow-up...

Nakul Vachhrajani (6/13/2012)

---

muthukkumaran Kaliyamoorthy (6/13/2012)

---

In my server the browser is disabled. and the port is 5555

Server is listening on [ 'any' <ipv4> 5555].

Dedicated admin connection support was established for listening...

Odd. Never had this issue before, but good to know Notepad++ can come to the rescue 😀

Praveen Kumar-379209 (6/13/2012)

---

>>> A had a quick glance through the article. The title says it's about CDC, but I don't see anything about the change data capture functionality introduced in...

KWymore (6/13/2012)

---

I prefer Merge statements versus performing everything via SSIS tasks. I use lookups as well but find that they bog down with larger data sets. Most of my packages...

L' Eomot Inversé (6/13/2012)

---

Interesting question. And straightforward.

I guess calling it a .ispac file instead of a .zip file makes sense if you want to know from the extension which...

Hmmm, do I sense some frustration? 😀

No problem, glad to help.