I would define the columns from the text file as strings, then use a data conversion or derived column transformation to change the columns' types. That transformation should have 2...

Are you sure the SSIS package is inserting the data in the correct server?

If the package log indicates it's inserting rows and the destination server doesn't show any activity, then...

This follows the rule for Desired Open.

I'm guessing that you're getting these values from a query and not a table, and the Closed Count should have the value only for...

OMG,...

Alone

patrickmcginnis59 10839 (12/8/2015)

---

smmkr17 (12/5/2015)

---

Current table

ColA ColB ColC

A 1 Yes

A 2 No

A 1 Yes

A 1 Yes

B 1 Yes

B 2 Yes

C 1 Yes

D 1 No

My result should be

A No

B Yes

C No

If ColA...

Can you explain the rows for 2015-07-23 on the new sample data?

Why are the Open counts summed individually and the Closed counts aren't? Why are the previous summed as a...

Depending on the type of bad data. A conditional split could work, or simply error handling to redirect bad rows.

Could you unpivot the data in the query?

CREATE TABLE #Test(

A1 CHAR(2),

A2 CHAR(2),

A3 CHAR(2),...

John Mitchell-245523 (12/8/2015)

---

That doesn't return the result set that the OP requires. He appears to want the cumulative count to show 0 unless there is actually a value in...

Why do you have a zero on CummClosedDate for 2015-07-08? If you really need a cumulative count, the case is not needed.

SELECT IndividualDate,

ClosedDate,

...

3 possible options. I used LOWER, but I'm not sure if you need it.

PRINT UPPER(LEFT(@name,1)) + LOWER( SUBSTRING(@name,2,Len(@name)-2)) + UPPER(right(@name,1))

PRINT STUFF( STUFF( LOWER(@Name), 1, 1, UPPER(LEFT(@name,1))), LEN(@name), 1, UPPER(RIGHT(@name,1)))

PRINT UPPER(LEFT(@name,1))...

Some other ways. The last one is similar to serg's, but should perform better because it should read less rows. However, I can't assure it will perform better without real...

Sean Lange (12/7/2015)

---

Sergiy (12/6/2015)

---

And only on certain versions of CQL Server.

Microsoft SQL...

I'm sorry, I included an aggregation where I shouldn't.

SELECT id

,knt

,dt

...