So I don't need a foreach loop to read all the rows in the file? It'll do that inside the data flow once I connect to the specific file?

I think I might be able to answer my own question.

1) I have a data flow task that takes all the file data and puts it into a...

Okay, so I've discovered that if I remove the initial parameter that I had looking for a date, and hard code it in my sql for dataset1, then everything works...

Luis,

Can you remove the stored proc in your post? I just got called in because I wasn't supposed to post it.

M@

I believe I got things working, but only partially. If I run it for today, it's fine. If I want to run it for a day last week...

Okay, I think I get it now. I moved things around so I'm using the Row_number() + @new_position_id to insert into the new_position_id field in the temp table, and...

I tried the code, but it's not giving each row it's own new id, it's giving all of the rows the same new id, and inserting them into the temp...

Going to give it a try now, but I'm unsure what this does:

ROW_NUMBER() OVER( ORDER BY position_id) + @new_position_id - 1

I'm about to jump into a meeting, but I'll give it a shot when I get out.

Essentially, you just got rid of the cursors, right?

Yeah, pretty much.

I'm wondering if I can take the code in the stored proc and put it in a function that I can call?

select a,b,fn(getNewIndex),d, e, f, getDate()

plausible?

Just seems there...

I'm wondering if something like this might work.

select * into #temp1 from table1 where update_date = today

select * into #temp2 from table2 where pos_id in (select pos_id from...

That's what I was thinking, but I felt like I was just making a random guess. I'm mostly looking for advice for which direction to head rather than specifics...

Coming from health care, and no, we didn't have any. Just being hopeful I guess 🙂

I would Lynn, but I just started a new job and I don't think they'd appreciate me posting stuff from our internal apps.

I hear that it'd help with diagnosing things,...

awesome, thanks man.

If I had another condition where a and b = us and c = null, can I just add another statement like this after the initial where?