i configured odbc connection.. using that connection i was to login to terdata sql assistant and run query... but when i connect to ssis and try to pull data i get " TDWM Throttle violation for Concurrent Sessions: For Rule Name 'User Session Limit', Limit of 5 concurrent requests"

please suggest 

Must use ADO (.Net) connection

This is a limit your Teradata admin has put on your login.  The simplest thing is to ask them to remove the limit. 

However, if that is not an option, then set "RetainSameConnection"=true.  This will cause the connection to only open once.  If you want concurrent sessions, you would have to create 4 more connections and assign them to data flow tasks individually.

Please see:

http://munishbansal.wordpress.com/2009/04/01/how-to-retain-same-data-connection-across-multiple-tasks-in-ssis/

would like to try that   "RetainSameConnection"=true.  but how do i restart my teradata session or end the other sessions? i am unable to get thorough this error.

Hi Dkuud,

To kill a Teradata session, you can use the Teradata Manager or use the following query:

SELECT 
 *
FROM 
 dbc.SessionInfoVX
WHERE 
 UserName LIKE '%USER_NAME_HERE%'
;

Related Random Notes
 Abort session hostno.username 
 Abort session hostno:sessionno


 syslib.AbortSessions

 select 
  *
 from 
  syslib
 ;

Reference:
http://paintingbluecode.blogspot.in/2011/09/teradata-abort-or-kill-session.html

Re