Advertisement

01.09.2008 at 05:19AM PST, ID: 23069266
[x]
Attachment Details

Problem running DTS package from classic asp page

Asked by pjordanna in MS SQL DTS, MS SQL Server, Active Server Pages (ASP)

Tags: Classic ASP - VBScript - MS SQL Server

Hi Experts,

I'm trying to run a DTS script that copies tables to from a dev server up to a live server.  The DTS script works fine with a right click and execute.

I've been using these two pages as examples.

http://www.asp101.com/articles/carvin/dts/default.asp
http://support.microsoft.com/kb/252987

My code is attached - i've tried varying the usernames and passwords and the permissions within the SQL and the asp for the usernames i try and it doesn't seem to be falling over there - instead i'm getting a package failed sort of error on the first task - with a "copy SQL server objects" failure.

I've tried taking all the stuff out of the DTS package so it doesn't copy anything and i still get the same error.

2nd day now and i'm going to start hitting my head on the desk soon....

Start Free Trial 
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:

<%
 
	Option Explicit
 
	Dim oDTS
	Dim vErrorMessage
	Dim vCount 
	
	Dim vServer
	Dim vUser
	Dim vPassword
	Dim vPackage
	
	vPackage = "HARE"
	vServer = "Mine"
	vUser = "DTSLauncher"
	vPassword = "XXX"
 
	Set oDTS = Server.CreateObject("DTS.Package")
	oDTS.LoadFromSQLServer vServer, vUser, vPassword, 0, "", "", "", vPackage
	oDTS.Execute
	
	For vCount = 1 To oDTS.Steps.Count
 
		'If oDTS.Steps(vCount).ExecutionResult = 1 Then
			vErrorMessage = vErrorMessage + "<p>Step " & vCount & " : " & oDTS.Steps(vCount).Name + " failed. " + chr(13)
		'End If
 
	Next
	
	If vErrorMessage = "" Then
		Response.Write "Success"
	Else
		Response.Write vErrorMessage
	End If
	
 
	Response.Write "<p>ASP Error : " & Err.Description
 
	Set oDTS = Nothing
[+][-]01.09.2008 at 05:29AM PST, ID: 20617868

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.09.2008 at 05:35AM PST, ID: 20617914

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.09.2008 at 05:36AM PST, ID: 20617917

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.09.2008 at 05:46AM PST, ID: 20617998

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.09.2008 at 05:56AM PST, ID: 20618071

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.10.2008 at 01:25AM PST, ID: 20625930

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.10.2008 at 01:26AM PST, ID: 20625940

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.11.2008 at 04:58AM PST, ID: 20635828

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.11.2008 at 08:26AM PDT, ID: 21335165

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: MS SQL DTS, MS SQL Server, Active Server Pages (ASP)
Tags: Classic ASP - VBScript - MS SQL Server
Sign Up Now!
Solution Provided By: httpskk
Participating Experts: 2
Solution Grade: B
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628