What would be involved in using a lookup transformation to insert new rows and update existing rows?

That's what I did. I used the execute sql task, added the connection and added an SQL statement like delete from tableA where id in (select id from deleteTable)....

There could be around 50,000 differenct record ID's to delete which could be 4 or 5 records in some tables.

We initially receive a historic file and then we get daily updates. The historic load was simple. I just noticed that not all of the updates had delete...

Thanks Jeff! I'll play with these too. I think you also posted some suggestions when I was working with this function a while back, but we thought we...

Thanks! It looks simple enough. I guess if the part I am looking for doesn't exist it will return null. I'm out of the office at the...

I didn't mean for my reply to sound harsh. I am just stating that even a function that doesn't do anything but return a simple string won't debug.

I need...

It doesn't...

Thanks for the info!

At the time we were using that function the string that we were pulling sections from may or may not have multiple parts. And we had...

Nothing would debug because there was an issue with the remote debugging service on the server. After I re-installed that everything was fine. But, the simple function that...

Professional...

After doing some additional research I did a re-install of the remote debugging service on the sql machine and that fixed the problem.

No, the raw data comes as a fixed length file. The name column just contains commas. It could look like the following.

smith,john,thomas,jr

smith,john,thomas,sr

smith,john,thomas,,,

,,smith,john,thomas,

smith,john,,thomas,

smith,john,t,,,,,

,,,smith,,,john,thomas,

smith,john,thomas,AKA,John,thomas

No consistency at all and that is really...

I guess it was doing a rollback of the populate, but it finally cleared itself up. But the answer to your question is yes, that was one of the...

Wow! It took eight hours to create that index, but it was well worth it. The results come back in about a second now.

Thanks!

I am adding the index now, and I have changed the stored proc to use the ReCompile option. Once the index has completed it's build I will try the...