If you have default dates in the DB, you don't include the columns in the
insert statement
As for changing the names, you do that by including an operation that rename
the value:
row["Phone"] = row["PHONE_TXT"]
row.Remove("PHONE_TXT")On Fri, Apr 9, 2010 at 12:48 AM, Larry R <[email protected]> wrote: > My ETL package is moving along nicely, > 100K records in 40m, which > given the amount of "fondling" necessary is great. > > Looking at speeding things up a bit by using the > ConventionSqlBulkInsertOperation. The tables do not have a identity > column, so I thought it would be good. > > I've created a Schema that matches the table. > > How do I go about matching a row["PHONE_TXT"] to Schema["Phone"] ? > What about default dates ( I use GetDate() ) ? > > Thanks > Larry > > -- > You received this message because you are subscribed to the Google Groups > "Rhino Tools Dev" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<rhino-tools-dev%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/rhino-tools-dev?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Rhino Tools Dev" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rhino-tools-dev?hl=en.
