Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Server: DTS: wizard access to Teradata Views?

Status
Not open for further replies.
KathDHS

KathDHS

Programmer
Jun 18, 2003
2
US

I'm wondering if anyone uses the wizard to create DTS packages in SQLServer 7.0 against Teradata views, and if so, whether you had to change something in DTS in order to do so.

We can user wizard to create a package against any of our Teradata databases, as long as the databases are not views. We've tried changing the default database on the User DSN and changing the default database for the user in Teradata. The views will not display as an option.

 
Status
Not open for further replies.

Similar threads

V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
364
Volvere
V
gbaughma
  • Locked
  • Question
SQL Performance
Replies
11
Views
340
pjw001
pjw001
elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
234
Mike Lewis
Mike Lewis
Cpreston
  • Locked
  • Question
Seconds to minutes 2
Replies
5
Views
463
Chris Miller
Chris Miller
Colin Burton
  • Locked
  • Question
Determine if a file exists on s different server to the SQL Server 1
Replies
2
Views
416
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top