DTS package

Results 1 to 2 of 2

Thread: DTS package

  1. #1
    Join Date
    Dec 1969

    Default DTS package

    I create a DTS package to export data from SQL Server to MS Access db; the package simply drop a table, re-create it and then transfer data into it.<BR>When I run the package from the SQL Server console it runs perfectly while if I try to run it from an ASP page all works but not the data transfer.<BR>Then I try to run other DTS packages but all works except data transfer (ex. "INSERT INTO ..."); following is my ASP code.<BR><BR>thanks to all<BR>Jacopo<BR><BR>ASP code:<BR> Const DTSSQLStgFlag_Default = 0<BR><BR> Dim oPkg <BR> Set oPkg = Server.CreateObject("DTS.Package")<BR><BR><BR> oPkg.LoadFromSQLServer "SERVERNAME","USERNAME","",DTSSQLStgFlag_Default," ","","","DTSPKGNAME"<BR> oPkg.Execute()<BR>

  2. #2
    Join Date
    Dec 1969

    Default start here ....


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts