can DTS perform dynamically???
Posted on 2002-06-28
Hi I'm new to Data Transformtion Service, Does DTS can performall all transformation and act like a program?
What I meant is that does it able to ask you for database name, create differnt table upon falling to different logical formula, etc. like Visual Basic. I know it's has ActiveX VB Script but it's only get data that are provide through the source and destination only, not able to twist the database. And does ActiveX Script able to execute SQL statement?