DTS Package from ASP Page?

Results 1 to 2 of 2

Thread: DTS Package from ASP Page?

  1. #1
    Jason Guest

    Default DTS Package from ASP Page?

    I&#039m trying to execute a DTS Package from an ASP Page and I&#039ve tried using this:<BR> Dim objDTS, objFSO<BR> Set objDTS = Server.CreateObject("DTS.Package")<BR> Call objDTS.LoadFromRepository(SQLServer, "", "USer", "Password", "", "", "WorkersCompUpload") <BR>It doesn&#039t work.. I just get an error "Error Type: (0x80041012)"<BR>No description of the problem..<BR>Anybody have any ideas?<BR>Thanks!!!<BR>Jason<BR>

  2. #2
    Richard A. Lowe Guest

    Default This works for me...

    &#060;%<BR><BR> Dim objPkg<BR> Set objPkg = Server.CreateObject("DTS.Package")<BR><BR> objPkg.FailOnError = True<BR> objPkg.LoadFromSQLServer "CORPITGMBME", "sa", "", , , , , "myPkg"<BR> result = objPkg.Execute()<BR><BR> Response.Write(result)<BR><BR> objPkg.Uninitialize<BR> Set objPkg = Nothing<BR><BR>%&#062;<BR>

Posting Permissions

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