Very nice question, definately learned something today.

Got it wrong, because the BOL page about CREATE SCHEMA didn't mention anything about batches.

Ah well...

The question itself is good, it poins to a not so well known feature in SSMS.

But the answers, boy, does that suck. Pure trickery...

It is like: "Hahaha, you knew you...

Good question, but I've seen more difficult ones for two points.

:doze: I blame Friday. And the people who placed two...

I think the best practice here is to create an ID column which is a real IDENTITY column to serve as a primary key with no meaning. Then add your...

Just a long shot, but you didn't accidentely map one of your input columns with the [PK_LiveItemInstanceID] column?

No problem. Glad to help.

Something tells me you are not really willing to coorporate.

(or you can't read English)

Steve Jones already provided you with a...

You cannot disable transformations in the data flow.

You can however disable tasks in the control flow.

1. I already answered your question: use a derived column with the expression I gave you. Of course, adapt the expression to your situation.

2. Also use a derived column for...

I believe so. Try it out and let us know how...

SamaReddy (10/12/2010)

---

Hi sir

i have a package in ssis

that is how to change system.int32 datatype to system.int64

which transformation i need apply

now i am using oledb source,dataconversion,derived column,slowly changing dimension in my...

I think a simple SELECT COUNT(1) FROM [Source Table] will be faster than a whole data flow that reads everything into memory to just count the rows. But it is...

1. Use a derived column with the following expression:

ISNULL(myCol) ? "Dummy value" : myCol

2. But how can you put two columns into one column? Do you have to perform...

There are tons of sophisticated sorting algorithms out there. Sort your text file before you load it into SSIS. Use whatever programming language you feel comfortable in (or whatever language...