Dynamic Column Transformation....

  • I currently import an Access Database Table,of which the structure changes on a monthly basis. I attempted creating an ActiveX script to dynamically assign each source column to it's matching destination column @ runtime. It works, but takes way too long (almost an hour more than manually setting the transformations). Any tips in using the Transformation Objects to accomplish this in a more efficient means? Thanks in advance.

  • Figured out by setting the oDataPump.SourceSQLStatement at runtime.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply