An ODBC based dataset can only be used as a "RelationalSource" in copy activity. Please see this MSDN link for details: ...

English
English (United States)
Deutsch (Deutschland)
German (Germany)
Français (France)
French (France)
日本語
Japanese
한국어
Korean
Русский
Russian