DTS Main Package fails

Last Post 17 Nov 2007 05:56 AM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
srinath003
New Member
New Member

--
05 Nov 2007 11:13 AM
Hi Everybody,

Can Any one help out from the following situation.

We have a main package with some inner packages. Out of which we have a package that
gets the data from Teradata as a source. Recently we have changed the username and password for the
Teradata connection for this package. This package runs fine when we execute it seperately but when we are trying to execute this package from the main package, it fails.

First it thrown error like not sufficient previleges to logon to teradata.

then we have applied version change to the main package.

then it threw the following error for one of the step,

Step Error Description:[NCR][ODBC Teradata Driver] Not enough information to log on (Microsoft OLE DB Provider for ODBC Drivers (80040e4d): [NCR][ODBC Teradata Driver] Cannot find a compatible package match between client and gateway in terasso library.) (Microsoft OLE DB Provider for ODBC Drivers (80040e4d): [NCR][ODBC Teradata Driver] Major Status=0x04b6 Minor Status=000000-The operation completed successfully.
) (Microsoft OLE DB Provider for ODBC Drivers (80040e4d): [NCR][ODBC Teradata Driver] Major Status=0x04b6 Minor Status=000000-No Routine error/No calling error).

and the following error for remaining steps or tasks,

Step Error Description:[NCR][ODBC Teradata Driver] Not enough information to log on (Microsoft OLE DB Provider for ODBC Drivers (80040e4d): [NCR][ODBC Teradata Driver][Teradata Database] TWM Workload violation: User Limit of 5 concurrent sessions, For object DT168475, Regulation applies from 00:00 to 24:00 )

how can i call this inner package from the main package with the new user and password for the teradata connection.



SQLUSA
New Member
New Member

--
17 Nov 2007 05:56 AM
Save the packages in VB format and list them for us.

Kalman Toth, Database Architect
SQL Server 2005 Training - http://www.sqlusa.com/order2005ssis/



Acceptable Use Policy
---