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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics