afantozzi,

thank you for the response. the reason for filling in two of the parameters ahead of time is that the XML file is only providing 2 parameters for...

An OLE DB Command component in the Package's Data Flow Panel.

It is inside that component in the SqlCommand property that I say "EXEC storedProcedure @rowCount = 0, @NewTitle = ?,...

Thanks everyone for your input and help. It was beneficial to getting this to work. I think I have it now and I am grateful.

Lowell, if...

I am really tired because my 1 yr. old woke me really early this morning.

I'm looking through the suggested solutions to this problem, and I'm not understanding them. ...

Lowell, thank you very much for the pointer. I sometimes don't think of the other functions that are available inside of SQL Server.

I appreciate your help and...

I think I have it figured out!

SSIS is expecting UNICODE data strings. But in the stored procedure I wrote I'm using varchar for my data types. ...

Ok, now I see in the OLE DB Command 'Advanced Editor for OLE DB Command' under the 'Input and Output' tab, the 'Data Type Properties of my parameters (or 'External...