View Single Post
  #3 (permalink)  
Old January 20th, 2005, 04:26 PM
rweide rweide is offline
Authorized User
 
Join Date: Sep 2004
Location: , , USA.
Posts: 70
Thanks: 0
Thanked 0 Times in 0 Posts
Default

This is the code I use:
Code:
    Set objDTSPackage = CreateObject("DTS.Package")
    objDTSPackage.LoadFromSQLServer "server", "", "", 256,,,,"PkgName" 
    objDTSPackage.FailOnError = true
    objDTSPackage.Execute
    objDTSPackage.UnInitialize 
    Set objDTSPackage = Nothing
I've tried to use server-side code to do this previously, but since it involved IIS permission issue that I can't touch at the moment, I switched to use client-side VBScript. And it does seem to complete the DTS package - at least when I use Enterprise Manager to check the row count, it seems to be correct.
However, if I execute the same SQL query or stored procedure to check row count in ASP page, it doesn't give me any error, but it just gives me 0 row count - even though there're records in the table.

Reply With Quote