Re: Help Needed understanding prob when executing a DTS fromVB6

#1

Do you get any errors?

Is this scheduled or when you are at the console of the NT Server?

If Scheduled then have a look here

http://support.microsoft.com/?kbid=269074

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know

"Peter Newman" <PeterNewman (AT) discussions (DOT) microsoft.com> wrote

Quote:

I have a simple project which is ment to migrate files from our old ODS
system into a SQL server.

The files to be imported are moved by my exe from a novel directory to a
directory that the SQL server can acces. It then runs a DTS to inport the
file intop the server. This is where the problem arises

I can run the whole project from my dev machine and it completes
correctly,
how ever when running it from the NT server it completes the copy pary of
the
program but fails to execute the DTS and im pulling what little hair i
have
left out trying to figure it out

the section the executes the DTS is as follows

Private Sub ExecutePackage(sPackageName As String, Optional Parameters As
String)

Dim oPKG As DTS.Package, oStep As DTS.Step
Dim nParameters
Set oPKG = New DTS.Package

Dim lErr As Long, sSource As String, sDesc As String

' Load Package
oPKG.LoadFromSQLServer "BACSSYS", , ,
DTSSQLStgFlag_UseTrustedConnection, , , , sPackageName
' Set Exec on Main Thread
For Each oStep In oPKG.Steps
oStep.ExecuteInMainThread = True
Next
' Execute
oPKG.Execute
oPKG.UnInitialize
Set oStep = Nothing
Set oPKG = Nothing
End Sub

The I have signed on the NT server as Administrator and on my SQL server
machine i have given administration rights to Network/Administrator. so i
would presume that it has the rights to execute the DTS. Can any one show
me
how to get what error is being caused to stop ir from running.

Like i said i can run the project from a dev machine and know that it
works
so i know that the DTS works correctly

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Help Needed understanding prob when executing a DTS fromVB6

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: Help Needed understanding prob when executing a DTS fromVB6 - 09-08-2004 , 03:19 PM