Hello,

This is how I declare my stored proc

Dim strSP1, strSP2,strSP3 as string

strSP1= "SP1"

strSP2= "SP2"

strSP3= "SP2"

.... so on

conn.open ("DSN=Hybrid")

conn.begintrans

conn2.open("DSN=NSI")

conn2.begintrans

...this is where where my problems lies which I...

Hello.. I only want to know that distinct from column tracking number.

Hello.. thanks a lot it work. But the reason why I want to put a condition because if the serv_lev is not null, it will insert to tblMatchNSI and if...

Yes, thank you got it now . I'll check on the syntax in VB. And I hope you don't mind if I will...

hello.. i will run the package from my VB 6 program.  My code will go like this:

For calling the DTS:

strServer = "10.160.10.28"

strUsername = "fduser"

strPassword = "fduser"

strPkg = "dtstmpFDimp"

oPackage.LoadFromSQLServer strServer, strUsername,...

hello... thank you so much I really appreciate your help. But I still have one more question. How can I handle if I have a parameter that I need to...

Thanks a lot. It is now working I really appreciate your help. Thanks again.

Yes, I need to give access all users to all projects so they can have rights to put all their concern in each projects.

I really appreciate if you can show...

Thank you so much. You are a big help.

Hi.. I already figure out what went wrong. My code is fine but I just got a problem with the source of my dts package. It is already resolved.

But my...

I am really sorry. Got it now. Some error in my code. Thanks again

Hi, I just changed my stored procedure and it is now doing okay so far... thanks

With the above code you suggested, In line below, it doesn't return any...

got it now. need to open another connection. Thanks anyways.

yes... it return a record but it took me for about 8 mins to 10 mins to complte the query.

So I assume it is one one the cause thats...

Hi... just a follow up question

For other stored procedure, the code you suggested is already working.

Now, I have another store...