Jeffrey Williams (7/2/2009)

---

Better - but still not quite there yet. How do you decide which row you are going to return? How are you deciding that you want...

CREATE TABLE resumein

(

ID3 INT IDENTITY(1,1) NOT NULL,

...

I have a bunch of resumes in my database, which include duplicates.

ResumeData Table

resume

email

What i am trying to do is create a DB VIEW of the same...

What i mean is:

record1 - email, other fileds

record2 - email, other fields

record3 - email, other fields

If record2.email = record1.email NEXT

If record3.email = record1.email NEXT

etc ..........

Thanks

I guess i go into Visual Studio 2008 from SSIS. Apologies for the confusion.

Ted,

I finally got it working 🙂

I can't thank you enough for your help !

Regards

Ian

Hi John,

After reading the MS threads i went in the wrong direction;(

I did some backtracking and found that although my DB I/O fields were nvarchar(max)

the field in the script...

Hi John,

Thanks for your suggestion!

I read the thread and changed the maxconcurrentexecutables from (-1) to (1) with no improvement:(

Any other ideas ?

Regards

Ian

Ted,

Your solution works great if a resume has only one or two emails.

If it has > 2 emails it fails with a

" The value is too large to...

Ted,

Thanks again for your help, but i cant get your script to work on my single resume input file.

How did you test it ?

Regards

Ian

Ted,

My goal is to read a folder of text resumes and extract all the emails for EACH resume.

If you look at the resume in the attachment, it has a generic...

Ted,

May i send you a direct email as it may be quicker ?

Regards

Ian

Update...I finally got your package working after i removed 'local' and changed to my instance and removed 'foo' from the script.

The downside is that it outputs exactly what you...

I finally got your package to run but it keeps locking up SSIS.

I dont have local setup,(which maybe why SSIS is locking up) so i changed the Input file to...

Ted,

Thanks very much for your efforts on this:-D

I have run into a couple of issues:

I created the new DBA05 database and two tables. My input text resumes are in a...