|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
|
|
#1
January 28th, 2003, 02:08 AM
|
|||
|
|||
DTSStep_DTSDataPumpTask_1 failed.
Is anyone know how to resolve this problem?
Package DTSStep_DTSDataPumpTask_1 failed. Package DTSStep_DTSExecuteSQLTask_1 succeeded. Program:- <html> <head> <title>Information Uploading by using DTS Package</title> </head> <% dim objDTSPackage dim objDTSStep dim strResult dim blnSucceeded dim objCn, sSP, adocmd Set objCn = Server.CreateObject("ADODB.Connection") objCn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=RMEReadWrite;Password=rme;Initial Catalog=SonyRME;Data Source=xx.xx.xxx.xx" const DTSSQLStgFlag_Default = 0 const DTSStepExecResult_Failure = 1 set objDTSPackage = Server.CreateObject("DTS.Package") blnSucceeded = true objDTSPackage.LoadFromSQLServer "xx.xx.xxx.xx", "RMEReadWrite", "rme", DTSSQLStgFlag_Default, "", "", "", "DTSName" objDTSPackage.Execute for each objDTSStep in objDTSPackage.Steps if objDTSStep.ExecutionResult = DTSStepExecResult_Failure then strResult = strResult & "Package " & objDTSStep.Name & " failed.<br>" blnSucceeded = false else strResult = strResult & "Package " & objDTSStep.Name & " succeeded.<br>" end if next if blnSucceeded then Response.Write "<h1>Product Loading Succeeded</h1>" Response.Write "<h1>Press Backspace key to go back to Menu</h1>" else Response.Write "<h1>Product Loading Failed, Please contact MIS for support</h1>" end if Response.Write strResult %> </body> </html>
|
|
| Viewing: Dev Articles Community Forums > Programming > ASP Development > DTSStep_DTSDataPumpTask_1 failed. |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
