I'm not 100% sure, but I think that joining in the OLE DB source will be more performant than using the conditional split. The conditional split has to evaluate each...

marina.x.rotua (4/28/2010)

---

when I insert the data source using the data flow task in control flow tab, then on the data flow tab using OLE DB Destination, how to make its...

If I were you, I would just write a SQL statement.

Much much much more performant than sorting...

If the source isn't too complicated and it is a database, I would write the join in a SQL statement in the OLE DB Source, instead of using the merge...

Very nice question. I work a lot with SSIS, but I hadn't heard of this function yet.

Thanks all for the (very quick) responses. Now I can sleep at night :-D.

I did some research on Google though, before posting this question, but I didn't find any plausible...

M@N@ (4/28/2010)

---

Yes, you are right,The 'DATE' datatype is exists on SQL Server 2005/2008 but i told that in below QUERY

DECLARE @Today DATE

SELECT @Today = '01 DEC 2009'

SELECT @Today+1

SELECT...

nithya.s (4/28/2010)

---

Gud Quest !! 🙂 I have learnt about casting while trying to solve the error in the Quest... and by the way, can anyone give me the syntax for...

Why wouldn't that work? The date datatype exists on SQL Server...

Nice article. I will never ever use the first option as it is too rigid, but the second one is very interesting and very promising.

Good question. No points for me but I learned something new today.

And also useful, when we will (finally) migrate to 2008.

That will teach you using Safari 😛

I did some more research on the Tortoise SVN we are using, and it's possible that we just can't browse the repo-browser graphically because of security restrictions.

So the limitations I...

Allright. Thank for the reply and the link!

Here you go:

http://msdn.microsoft.com/en-us/library/bb522499.aspx