Ha, I selected the "correct" answer so I could easily get some points (5, woohoo :w00t:) and get some recognition on this forum!

Although I would debate that the "judging skills"...

Thanks for the question.

It would be...

Jeff Moden (7/24/2012)

---

Koen Verbeeck (7/24/2012)

---

Jeff Moden (7/23/2012)

---

Thanks for the response, Jason. Do you have any good examples of where SSIS might outshine T-SQL? Please don't say "anything that...

Not use SSIS?

SSIS and SQL Server in general can only run on Windows OS.

SSIS itself can only run on Windows, so you need to take that into account.

A good book to start with:

SQL Server 2012 Query Performance Tuning

Look around on the web. There are tons of articles, blogs and books written on SQL Server performance.

How about adding a WHERE somewhere?

Try this:

INSERT INTO [dbo].[tblContactInf]([spaceId],[contactId],[datas])

SELECT

SpaceId

,ContactId

,sq.datas

FROM

(

SELECT

s.SpaceId

,contacttype= 'phone' + CONVERT(CHAR(1),ds.IndexNumber)

,datas= ds.DataText

FROM

tblAdSpace s

INNER JOIN

[dbMemberdetail].[dbo].[tblMemberDatadetail] a

ON a.CreatedOn = s.CreatedOn

CROSS APPLY

dbo.Split1(a.PhoneNumbers,',') ds

) sq

INNER JOIN

dbo.ContactType ct

ON ct.datas = sq.contacttype;

This might be a little too complex for a conditional split.

However, you can create a script component as a conditional split and use regular expressions to find out if the...

What exactly are you doing in the package?

Ah OK. To make your Excel Destination dynamic, you need to put an expression on the connectionstring property of the Excel connection manager.

Not 100% sure, but I think the Excel...

No, what I mean is: how do you know if a datafield is a telephone number and not an e-mail?

+1

How would...