DSXchange

Good day everyone,
Is there any way to have an OLEDB stage CREATE a table in the target database where you wish to store info?
I've looked in the documenation and found nothing and the stage properties all seem to be describing update actions only.
Thanks in advance for any assistance/information you can offer...
Have a good day all.

Hi,
If I'm not mistaken with OLEDB you have the before/after sql.
in the before section you need to perform your sql.
consult you SQL Server DBA as to the manor in which you'll create the table, since there are some issues about the file group you place the table in and more.
this might also include some syntax that checks for table existance as well, prior to the create table.

IHTH