The fact that you need to check all of the rows in the file before deciding whether to commit any of them makes a one-pass solution a little difficult.

I'd be...

Koen Verbeeck (1/15/2013)

---

To quote the OP:

to perform additional...

You missed the obvious question: why use a script component to do lookups when there is already a dedicated lookup component?

Have you tried the Import wizard?

kenambrose (1/14/2013)

---

If using Execute Sql task, make the sql text an expression and use variables for table names

If using oledb destination in data flow task, the data access mode property...

Or if you can use SSIS to achieve whatever it is that you are doing, there is at least one CodePlex add-on that would allow you to use RegEx matching...

oliver.morris (1/14/2013)

---

Thanks for this, my CLR skills are non - existent but it is something I need to look into. I don't think such powerful query tools exist to do...

Change your...

kenambrose (1/14/2013)

---

[I am not able to use variable due to there are almost 20 data flow tasks in SSIS package and I need to use more variables.]

Did you consider to...

There's nothing easy.

But if you don't mind writing some code, you may find that a Script Component Destination gives you the flexibility that you need. Have a look here.

Do your various destination tables contain different column definitions, or do they all have exactly the same structure?

If you can make the recordset into a datasource, you can add a script component to make whatever changes you like.

paul.j.kemna (1/11/2013)

---

I don't see a forum for SSIS 2008, so I guess I will post here??

I have an OLE DB connection to an IBM DB2 source. I am trying to...

I'd suggest exporting the Excel data to CSV format and importing that instead. You'll save yourself a grey hair or two. Mixed-datatype columns in Excel have cost the world numerous...

mister.magoo (1/10/2013)

---

opc.three (1/10/2013)

---

Nice offering MM. The technique is one I have seen outlined before but not necessarily applied to SSIS. While no one step is difficult there are quite a...