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.
OLEDB Stage Table Creation on SQLServer 2000 target
Moderators: chulett, rschirm, roy
OLEDB Stage Table Creation on SQLServer 2000 target
Dan Marshall
Alberta Education
Edmonton, AB
Alberta Education
Edmonton, AB
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
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
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org