Hi,

I want to tun a exe that execute a DTS package in another server.
I do not have administrators rights in the remote sql machine and they won't give me, but i can connect to SQL with the SQL Enterprise Manager with sql authentication, and a username and password that is not the same i use to login in the local machine.

This user (SQL) can execute DTS with no problems in SQL Enterprise Manager.

When i run the exe i get the following error:

Login Failed with mydomain\mydomainusername

The code is:


    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Dim oPkg As DTS.Package2
        Dim oStep
        oPkg = New DTS.Package2
        oPkg.LoadFromSQLServer("SERVERNAME", "USER", "PASSWORD", DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrus tedConnection, , , , "DTS_NAME", )

        ' Set Exec on Main Thread
        For Each oStep In oPkg.Steps
            oStep.ExecuteInMainThread = True

            oPkg.Execute()
        Next
        oPkg.UnInitialize()
        oPkg = Nothing
        Me.Close()


The username and password i use in the code is the same that i use to "log" into the Enterprise manager.

Any idea ?. Can you post some code, to make it.
I'm stuck here.
Thank you.

use this link
http://www.sqldts.com/default.aspx?215

Jaime E. Maccou

Try using the following constatnt in the flags parameter to the
LoadFromSQLServer() method
  DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default

Possible cause :
 DTSSQLStgFlag_UseTrustedConnection is using your Windows Authentication userid/Pwd and I think you want to use the SQl Server UserID/Pwd.

Thanks

THANK YOU both,

But especialy to GREENASH, only adding that constant make it Work.

It was a B I G HELP because as you probably have notice i´m a begginer.

I want to thank to people like "jemacc" because 440 post it IS a big work too.


This probably has save my job.
Happy New Year.