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

I won't speak generally, but these are some things I ran into at my current project:

* you must know the URL to go to the repository. Sure, you can keep...

I wouldn't recommand the union all if you want to combine 12 flows. The union all is quite a nightmare in maintenance and since it is a semi-blocking transformation, it...