Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  View SQL and run Package from Classic ASP

Author  Topic  sw26p2 Starting Member 8 Posts Posted - 2011-01-05 : 15:26:51 Hi, We just converted our 2000 database to 2005. We have several DTS packages which need to be converted to SSIS. Before these are converted we need to be sure these other 2 requirements can be met. We need to have screens written in classic ASP which: 1: Display the SQL statement inside the package 2. Execute the specific package The Package Names for a Customer Account are stored in a database table. The ASP code lists the Package Names for the Account, and provides links to View the SQL and Execute the package. To view the SQL, we were using "DTS.Package2" .Properties("SourceSQLStatement") To execute the package, were were using "DTS.Package" .Execute() I can not find a similar way to do these functions with an SSIS package. Please let me know if you need more information. Thank you so much for your help Sue