DDL operation in OLE DB Command
Hi,
Can we do the DDL operation in OLE DB Command transformation.
like Declare variable etc
Regards
Tom
December 29th, 2010 2:41am
declare variable is not DDL operation as I know,
but you can put any script(contains declaration as many as variables you need) that you want in a stored procedure and then execute it with OLEDB Command , but for detailed help we need to know what exactly you want to do?
and Note that every statement you write in OLEDB Command will execute FOR EACH ROW IN DATA STREAM, and usually you don't want to do an ALTER command ( DDL operation ) for every row, so If you want to do DDL operations I think it's better to use Execute sql
task which can execute a statement regardless of rows .http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
December 29th, 2010 2:49am