If you are new to SSIS, how do you know that you need to add something to the toolbox as, presumably, you are not familiar with all of the existing...

Can you provide some sample data? If it's not ASCII, what is it?

Is the Resultset property of the Execute SQL task set to None?

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.