There are loads of examples on the Internet. This one is nice and detailed and will help you get started:

http://www.codebeach.com/tutorials/sql-server-integration-services-your-first-script-component.asp

This one generates multiple output rows from a single input:

http://blogs.conchango.com/jamiethomson/archive/2006/12/13/SSIS-Nugget_3A00_-Unpivoting-using-the-script-component.aspx

Phil

Maybe this article gives you what you need:

http://www.sqlservercentral.com/articles/Integration+Services/61542/

Wow! Can anyone explain that?

steveb (5/5/2009)

---

I would load the data from the files into a table, then use a sql task to create some indexes on the tables, and then join them using...

Your requirement is still puzzling me. You want to create a single XML file and store that in a single BLOB field?

What is the purpose of using XML here? Are you planning to insert the data, including the XML tags, into the table? Please explain a little more what the requirement...

So the regions on your spreadsheet may or may not match existing regions in your region table.

If they do, pick up the region ID

If they don't, create the region and...

It seems that you need to modify the script, which looks curiously like a VBScript DTS script.

Try replacing this line

DTSDestination("CreateDate") = CDate(DTSSource("Col095"))

With this

If IsDate(DTSSource("Col095")) Then

DTSDestination("CreateDate") = CDate(DTSSource("Col095"))

End If

That sounds a bit nasty - I think you might end up having to do that work in a Script Component, where you can certainly generate multiple output rows for...

Change your data source from 'table' to SQL command.

Select fields from your table and (critically) add a Row_Number() column partitioned on the fields you are using to identify duplicates. So...

You have provided neither

a) sample data, nor

b) an example of what you want to print

yet you are asking for sample code. Leaving aside paranormal abilities, just how do you expect...

When you say the second value, you mean the one which is zero in your sample data? Zero is different from null and needs to be handled differently.

If the value...

Have a look here for an example of how it can be done.

http://blogs.conchango.com/jamiethomson/archive/2006/07/11/4209.aspx

GSquared (5/1/2009)

---

--

One way to do that would be something like this:

;with Dupes as

(select row_number() over (partition by facilityid, measureid, order by date desc) as Row,

facilityid,

measureid

from dbo.MyHoldingTable)

delete from Dupes

where Row >...

So the records coming out of the OLEDB source are in the correct order, yet they are written in some other order?

Can you confirm that by adding a Data Viewer...