Module stopping at Call step

[goyal]

I have this module which used to run fine till now.

I did a small change to the module and that was added a DTS call step in between

call runDTS1()


the DTS call function is as follows:

Sub runDTS1(strServer As String, strUser As String, strPassword As String, strDTS As String)

Const DTSSQLStgFlag_UseTrustedConnection = 256
Dim dtsp As New DTS.Package
dtsp.LoadFromSQLServer _
ServerName:=strServer, _
Flags:=DTSSQLStgFlag_UseTrustedConnection, _
PackageName:=strDTS
dtsp.Execute
DoEvents
End Sub

This is running fine..

after that I have some queries and then I call another function
Call UpdateProduct

the problem is the code just stops there. There is no error displayed, no break points..but still it is stopping there..
I have no clue someone please help

 

[Guus2005]

If previously there was a breakpoint remove the line and place it back again (ctrl+x,ctrl+v) The residuel breakpoint was deleted.

As for the rest of the procedure, i find it hard to believe that it runs with no error

call runDTS1() 'With no parameters


the DTS call function is as follows:

Sub runDTS1(strServer As String, strUser As String, strPassword As String, strDTS As String) 'With 4! parameters, none of which are optional.

You should get an error message.

 

[goyal]

I have the parameters just removed it here. I will try removing and pasting that line. Hope that works