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!

How can I get Teradata Views in SQL Server DTS Wizard?

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.

 
Sort by date Sort by votes
I believe this was a restriction in SQL Server 7 that got removed in SQL Server 2000.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Teamalone
  • Locked
  • Question
How to export multiple files using teradata tpt
Replies
0
Views
179
Teamalone
Teamalone
multipledatabases
  • Locked
  • Question
How to bulk import a CSV or a TXT file trough command into a Teradata database
Replies
1
Views
293
Miguel93
Miguel93
Samm2020
  • Locked
  • Question
Oracle to Teradata for data source setup
Replies
1
Views
153
johnherman
johnherman
tmcrouse
  • Locked
  • Question
tough time with a teradata date format
Replies
0
Views
137
tmcrouse
tmcrouse
jholl
  • Locked
  • Question
Create Volatile Table in Teradata is showing 0 rows being processed
Replies
0
Views
135
jholl
jholl

Part and Inventory Search

Sponsor

Back
Top