Re: -1073741819 Error Code returned from dtexec

Hello Kev,

So this error code as memory serves means Access Denied. This could be due to being unable to log in properly to the Sybase or SQL Server. It could also be around the Sybase Driver you are using. Does it run from the same location through the tools OK using the same accounts etc?

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

Does anyone know what this error code means and why it occurs?
I'm getting it when running SSIS packages from a DOS script. The
packages
migrate data from SQL Server 2005 SP1 to Sybase. The error occurs
randomly
and often.
Cheers.



.

Relevant Pages

  • Re: Migrating SQLServer DBs to Sybase
    ... Server-generated scripts to create the structure in Sybase, and SQL Server ... AseConnection objCon = new AseConnection; ... objCon.ConnectionString = strConnectionString; ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Scheduling DTS job
    ... If you try to transfer the same rowsfrom SQL Server to SQL Server ... > How do i see if there is any difference in the driver ... >>> The SQL server agent is running as Local System Account. ... >>> Nothing has been changed in sybase box. ...
    (microsoft.public.sqlserver.dts)
  • RE: Numeric Overflow of Column of datatype Money
    ... Sybase driver is failing on the column, long before it reaches SQL Server. ... That I have serveral column with datatype money that didnt have the ...
    (microsoft.public.sqlserver.dts)
  • RE: Connecting to Sybase
    ... Have you tried pushing the data directly into AS using SSIS, ... This paper describes push mode processing in more detail: ... issue with pulling the data from Sybase on a daily basis and putting it into ... a Sql server table then having ssas get the data from there. ...
    (microsoft.public.sqlserver.olap)
  • Re: MS SQL server & Sybase interoperability
    ... > I have an application build on Sybase database, and we waant to install MS ... We are using Sybase ASA and SQL Server 2000 on the same machine. ... Installing SQL Server 2000 AFTER installing Sybase did not cause ... caused problems with the ODBC dlls. ...
    (microsoft.public.sqlserver.server)