SSIS Permission Problem

[Vimalsoft Pty Ltd]

Good Day All I have a Package created and hosted in a Machine(Theresa) that has SQL 2008 and i have my Development Machine(Vuyiswa) that has IIS and am Debugging from the my machine. i have a ASP.NET 2.0 App and am executing a Package that in another machine. The First thing i did was to share a directory where the Packages are stored when i install the packages and supplied "Everyone","ASP.NET","Vuyiswa" Accounts permissions to to access this share. i can go into the share from the another machine without any problem. i have a code like this in my ASP.NET App

try
{
//Start the SSIS Here
Application app = new Application();
Package package = null;
package = app.LoadPackage(@"D:\Program Files\Microsoft SQL Server\100\DTS\Packages\OMEGA\OMEGA.dtsx", null);
//@"C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Packages\OMEGA\OMEGA.dtsx", null);

        Variables vars = package.Variables;

        vars\["Time1"\].Value = time;

        vars\["Time2"\].Value = time;

        vars\["Time3"\].Value = time;

        vars\["TTBLTYPE"\].Value = THREAD\_DATA\[1\].ToString();

        //package.Connections\["SQLNCLI10.1"\].ConnectionString = obj.GetConnectionString(THREAD\_DATA\[0\].ToString());
        //Excute Package
        Microsoft.SqlServer.Dts.Runtime.DTSExecResult results = package.Execute();
      
        if (results == Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure)
        {
            foreach (Microsoft.SqlServer.Dts.Runtime.DtsError local\_DtsError in package.Errors)
            {
               
                Console.WriteLine("Package Execution results: {0}", local\_DtsError.Description.ToString());
                Console.WriteLine();
            }
        }
       
    }
    catch (DtsException ex)
    {
        Exception = ex.Message;
    }

This execute Fine until the

Microsoft.SqlServer.Dts.Runtime.DTSExecResult results = package.Execute();

it does not stop here , but i trap it here

if (results == Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure)

and the Error am Getting is

"SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D.\r\nAn OLE DB record is available. Source:\"Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E4D Description: "Login failed for user 'sa'

O

[Rob Graham]

Does your sql server support sql authentication? It is usually not enabled by default, but must be turned on.

[Vimalsoft Pty Ltd]

yes it does. i have resolved this Problem by adding a dts config file. The Problem was that the Connection Manager was not saving the Password. so i had to make sure that is there by Explicitly adding it in the config File. Thank you for your Reply

Vuyiswa Maseko, Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code. C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/