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

You are right - set Fail package on Failure to True and you should get the result you desire.

I suggest that you read up on Package Configurations - I think that will work well for you.

This sounds like a T-SQL question to me - this is the SSIS forum.

It is difficult to answer your question without seeing some sample data. Why only 5 items -...

As Luke said, fixed-width files do not generally have delimiters - they are just wasting space.

If it's just a pipe-delimited file you need, pipe can be chosen as delimiter if...