PSB (10/14/2015)

---

I am not getting distinct values .

CREATE TABLE #ListString

(

JobNo VARCHAR(10),

InvNo VARCHAR(MAX),

Address1 VARCHAR(100)

)

INSERT INTO #ListString ( JobNo, InvNo,Address1 )

SELECT '3079', 'abc' ,'Add1'

UNION ALL

SELECT '3079',...

Use the FOR XML PATH technique described here.

PB_BI (10/14/2015)

---

To get the column name is a bit fiddly but possible (unless you have a time machine and are using SQL 2016 where it's been made simple finally[/url]. Also,...

And now I just got this warning in Gmail, for a "SQLServerCentral.com - New Topic " e-mail:

This message could be a scam. The sender's account may have been compromised and...

Felix Pamittan (10/14/2015)

---

So that's why I received an email saying:

A new reply has been added by CELKO to...

The error message does not say what went wrong, so I don't know whether anyone can help much without more information.

Did you check whether you have sufficient disk space for...

botta.5283 (10/14/2015)

---

Hi All,

please find the below is my requirement

how to fetch data from oracle database in sql server 2014

example

----------

oracle schema :t1

sql server :t2

now...

rajarajansudar (10/13/2015)

---

i need to write condtion like this

if ( System ID =="RE2")

{

Account_num +"-"+ coulum

}

i wrote in SSIS like below

System ID ?...

Sounds like something is setting this value.

If you click once on the CM and then get properties, can you check the 'Expressions' property – is there anything in there?

No. Create a dummy project, add the package to it, then you should be fine.

Kristen-173977 (10/13/2015)

---

Dave Convery (10/13/2015)

---

Currently there are filters based on post numbers, with automatic approval for people over a certain number of posts. This is a bit more robust than just...

PearlJammer1 (10/13/2015)

---

I am having trouble changing the properties on a connection manager, specifically the server name. I have exported one of our production packages to my work desktop pc. I...

Dave Convery (10/13/2015)

---

Currently there are filters based on post numbers, with automatic approval for people over a certain number of posts. This is a bit more robust than just the...

Table A has a row where Id = 4.

Table B does not have...

Try changing it to 'Required' on the container. Leave the data flows within as supported.