Yep, you are correct. I mis-stated this as it should have read : "This has been re-posted, please.....".

Can you tell us what you plan to do with the rows inside the recordset?

The Recordset destination was not designed to pass data between tasks. Use the Raw File...

First off, you won't need a cursor for this. Secondly, I'm not sure I follow what you want to do with the duplicate rows. Can you give an...

No problem. Read through the article, give it a shot, and then post back with your results. If we need to work through it, we will; otherwise, it will...

The Execute SQL task can be a bit tricky to work with when you are trying to return values back into variables. Everything has to be set up just...

Gordon,

SSIS is so metadata dependant that any change to a data source that would result in a metadata change is going to cause problems. Outside of using a...

wwei is right on. The ConnectionString property of the flat file connection manager object represents the path and file name. Setting this property, whether you use one or...

You'll need to use dynamic SQL to get this to work with a parameterized directory path. Look up EXEC(@sql) in BOL for specifics. Basically, you'll need to build...

This is a repost, please continue thread and responses here:

http://www.sqlservercentral.com/Forums/Topic842291-149-1.aspx?Update=1

By the way, this is the exact same response you got the last time you posted this very question.

http://www.sqlservercentral.com/Forums/Topic834653-338-1.aspx

Please do not double post. Most of the regular...

There are a few ways to do this. I'll explain the simplest way in detail and give you a brief expalation of other options.

The simplest way to do this...

I think I'm going to Rue getting into this one...

Are you guys planning on doing this until you've used Allspices?

Also, based on the example you've given, it looks like you want to get the first inserted value from Table2. Yet, as you've shown, Table2 is a heap w/o...

What happens when Table2 does not have a non-NULL value for v_ID, then what do you want to see?