Maybe I don't get you right, but as I suppose that later you want to load your changed ADO recordset into some table why not use the normal way by...

Online Help states that the ole db destination does not support parameterized insert statements and recommends using the ole db command transformation.

Exactly, some way to initialize these fields.

Are you sure that this is the correct path? AFAIK "E:\" means E on the server not the client.

Do a datatype conversion to a numeric datatype (DT_UI4) and then back to a String (DT_STR).

It depends on how you change your excel sheet. I think SSIS scans the first 10 (or so) rows to determine the column data type. Say you have column A...

Once again to the singular vs. plural topic: Of course there are valid arguments for using plural.

But most of them are weak especially the one that says: "An employee table...

Lyle wrote: "A table that contains information about employees becomes the Employees table, a noun. A table is a collection similar entities, plural. "

I strongly vote for singular, because (OO)...

I don't agree with the naming conventions of identifying columns (<tablename>ID). That does not work with compound identifiers. First, you need more than the tablename, second, "ID" suggests that this...

Sorry, wrong link:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1059616&SiteID=1

Microsoft suggests that this is an error and should be fixed by SQL Server 2005 SP2:

http://www.eggheadcafe.com/aspnet_answers/SQLServerintegrationsvcs/May2006/post26942448.asp

HTH

Alexander