Hi,

I have next code that run without problems:

    Dim objPackage2 As New DTS.Package2

    objPackage.FailOnError = True
    objPackage.LoadFromSQLServer "BCN01SERVER", _
        "sa", "", _
        DTSSQLStgFlag_Default, , , , "Package01"
    objPackage.Execute

But when I change LoadFromSQLServer line and subst "sa" user with a windows 2000 user, something is wrong:

    objPackage.LoadFromSQLServer "BCN01SERVER", _
        "DOMAIN\User01", "aaaaa", _
        DTSSQLStgFlag_UseTrustedConnection, , , , "Package01"

I have an "Login failer for user 'DOMAIN\Kalli'" error, when I hint "DOMAIN\User01".
What is wrong?


Thanks very much to all

JC

If you created the package using sa or dbo, the user will need to use that password to run it. When you save the package you can specify a owner pw and a user pw.