Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2008-07-29 : 10:02:09
|
| hii make odbc (to tabula) in control panaelwhere i found the connection in ssis?i know that exist "Microsoft OLE DB Provider For Odbc Driver" but i dont found it.please help/ |
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2008-07-29 : 13:49:34
|
| I'm not able to see microsoft ole db provider for odbc drivers on sql server 2005 |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2008-07-29 : 14:21:31
|
| Right click in empty area of connection managers window.Choose New Connection...There you can select ODBC.WebfredThere are 10 types of people in the world: Those who understand binary, and those who don't... |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2008-07-30 : 00:00:46
|
| that i know,but what i choose,ole db source OR DataReader Source?and for Destination?i wnat to pull data from table in the operational's systems |
|
|
|
hey001us
Posting Yak Master
185 Posts |
Posted - 2008-07-30 : 00:21:14
|
| DataReader, and DataReaderDesthey |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2008-07-30 : 01:53:38
|
| ok,i choose DataReader DestinationIn INPUT COLUMN i choose all fields,but where and how i defined the destination table?i get error when click on add output in Input and OutPut propertiesthanks |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2008-07-30 : 02:01:13
|
| i have problem with datareader source,i write in sqlcommand :"SELECT * FROM PORDERS".the error:"Cannnot acquire a managed connection from the run-time connection manager" |
|
|
|
|
|
|
ODBC in ssis