This is difficult to answer without seeing sample before-and-after data, but it sounds like a merge join might give you the results you need.

Accepted 🙂

In future, you could consider building your packages entirely in code. Then you would get the review features you desire, but it adds a significant layer of complexity to...

Not sure - try it and see what happens!

For testing purpose, I usually just do a "SELECT TOP 5 * ..." as my datasource - makes things fast.

Phil

My question was an honest one - as you're only new here, how am I supposed to make any assessment of your experience and knowledge? If I treated everyone like...

Good practice dictates that you should name your target fields:

insert into t_RowCount(f1, f2) ....

Other than that, looks like it should work.

If you mean: "How do I get back to design mode?" the answer is...

Your BLOB field on SQL Server will come into SSIS as data type text stream [DT_TEXT] and that is what it will remain through the pipeline, before it is output...

Nice sample code, cheers Tim.

Tim Mitchell (5/19/2009)

---

Is the "Sequence" column the last column you have defined in your flat file connection? If so, you're short by 1 column since you have a trailing...

What is the significance of the first field (1, 2, 4, 2, 2)?

Is it true that the only thing linking rows 1 and 2 is the order in which they...

There is no question here ...

Please post the error message.

You can create a very simple data flow task that will perform the extract for you - no need to get fancy about converting anything.

But if you do need to...

I've never tried this, but maybe you could use two Foreach containers - one executes for all (0 or 1) occurrences of Suppliers.xml and one for all (0 or 1)...

catogonzalez (5/15/2009)

---

My solution would be to create a 'template' excel workbook with an empty destination sheet where I only have the columns that will be written to by SSIS. In...