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...

Please also post how you would like the active date to look after the update has been performed. Your post shows the 'before' situation only.

This isn't easy.

The way I was thinking of doing this was to use a Script Task and use Excel.Application etc etc - but that relies on a reference to Microsoft.Office.Interop.Excel,...