Automate Update Statement with Parameters

Nov 11, 2009 at 3:47 PM

In the video you paste in a pre-made update statement with "?" parameters. How did you make that? Is that something that you created manually or is there an automated way to generate that?

Thanks!

Nov 12, 2009 at 7:23 PM

Unfortunately no - that was some off-screen cut and paste magic. :)

The UI for the OLE DB Command transform is not too pretty, IMO.  You'll have to do the heavy-lifting yourself!

Nov 13, 2009 at 6:18 AM

Dang... well I may just have to go write one :)