Your schema requires more than 10 attributes. Your document has elements.

<ClmCalcDetails LendPayoff="1.00" CLRefund="2.00"

.... with other elements as attributes here ...

></ClmCalcDetails>

I don't like the font you are using in the posts. It is way too small, which might be ok with another font.

I constantly have to remind myself that I'm really not the responsible on this issue. If the manager wants to have me do something that someone else can do...

One of the several reasons that I am a contractor rather than a full time employee is that I want the time for training. I don't trust employers to...

I'm not certain, but I think you could add a Derived column to your Data Flow. 

Check out http://msdn2.microsoft.com/en-us/library/59x02y99(vs.71).aspx.

You basically need to create a parameter with a Directon of ReturnValue (1 per command, I'm pretty certain).

You are using a dataset here.  However, in earlier versions...

I had a related problem with a web page.

Some background.  At one of my former clients I developed an SSIS package that pulled information entered into a customer service form...

One major correction!

Replace the following line with something like the second line.  All of the non-AID columns and exclude the identity col if you have one (which means you will...

I don't recognize the statement:

set RS = CreateObject("DistinctRecords.Recordset")

Do you mean ?

set RS = CreateObject("ADO.Recordset")

You would need to open a recordset with the proper connection and command string.  I haven't worked...

Hopefully someone can come up with a better way to do this.

First, create two temporary table that have the same fields as the original two tables.  Copy all of your...

You have a tblTest and you are going to run the rest of your DTS package using distinct combinations of x and y that occur in tblTest.

What I would do...

I have not used the Ident_Current function, but according to http://msdn2.microsoft.com/en-us/library/aa933217(SQL.80).aspx you pass it the name of the table:

SET @CR_ID=Ident_Current('tblCR_Visit')

I would be nervous that this might return someone else's identity...

There is so much that could go wrong.  I need to see your code.

You could wrap this as CDATA which throws out all formatting (note the <![[CDATA[  closed by ]]>.

declare @dd varchar(300), @doc int

select @dd = '<root ><myelement ><![CDATA[' + char(13) + char(10)...

The problem with this is that you have min(column1) and group by Column1.  Think about it.  This query is identical to (Select column1 from table1 group by Column1).

Try

SELECT Column1, column2

from...