February 7, 2011 at 8:30 pm
i am using ODBC to connect to Teradata and have execute SQL task in my package and get the below error. can anyone suggest why this happens?
Error: 2011-02-07 09:11:50.86
Code: 0xC0014020
Source: ReportWl 1 -OD Connection manager "test"
Description: An ODBC error -1 has occurred.
End Error
Error: 2011-02-07 09:11:50.86
Code: 0xC0014009
Source: ReportWl 1 -OD Connection manager "test"
Description: There was an error trying to establish an Open Database Connectivity (ODBC) connection with the database server.
End Error
Error: 2011-02-07 09:11:50.99
Code: 0xC00291EC
Source: Execute SQL Task
Description: Failed to acquire connection "tet". Connection may not be configured correctly or you may not have the right permissions on this connection.
February 8, 2011 at 5:18 am
The only thing one can deduce from the information that you've given is that no ODBC connection could be made to the server.
So please tell us what you've already did and tried.
Did you set-up an ODBC connection at your computer? Did you test it?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 8, 2011 at 9:28 am
i created a system ODBC connection thru Control Panel - admin tools and used that odbc for ssis connection manager with id and pwd
i created a execute sql task to create table on the Teradata database using the odbc connection.
DBA created system odbc in the development server and i imported the package and tried running it and got the above error.
it works in my system.
February 8, 2011 at 11:16 am
keywestfl9 (2/8/2011)
i created a system ODBC connection thru Control Panel - admin tools and used that odbc for ssis connection manager with id and pwdi created a execute sql task to create table on the Teradata database using the odbc connection.
DBA created system odbc in the development server and i imported the package and tried running it and got the above error.
it works in my system.
If it works on your system and not on the development system, you must research the differences.
How are the credentials of the connection passed to the package? Did you use package configurations or did you enter them manually in the package? If the latter, what is the protection level of your package?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 8, 2011 at 12:30 pm
i am using package configuration thru dtsconfig file.
February 9, 2011 at 12:55 am
keywestfl9 (2/8/2011)
i am using package configuration thru dtsconfig file.
And the ID and the password are saved into that dtsconfig file? Just to make sure 🙂
How did you try running the package on the server?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply