No announcements
Found 4114939 threads
-
0 Votes
Should I move data from an external EDW (Teradata) that my app uses to a local SQL server instance?
Considering the data in Teradata is only loaded once a day I feel as if I create an ETL process that loads the results of these queries into a ...Answered | 3 Replies | 91 Views | Created by Anonymous - Friday, October 2, 2015 3:27 PM | Last reply by Anonymous - Monday, October 5, 2015 9:13 PM -
0 Votes
Comparing Data from SQL server with Teradata
Great steps, I will give it a try...can you tell me if there is a way to pass parameters to the data source in the data flow??Answered | 5 Replies | 8163 Views | Created by jsnmk - Monday, March 28, 2011 11:04 PM | Last reply by SaeedB - Tuesday, March 29, 2011 12:42 PM -
0 Votes
how to import data from teradata to sql server
They can be downloaded from microsoft Ver 1.2 for SQL 2008:Answered | 2 Replies | 13610 Views | Created by kiranshiva - Friday, May 25, 2012 2:53 PM | Last reply by Onur Omer Ozturk - Friday, May 25, 2012 4:01 PM -
2 Votes
Automation for Teradata to SQL Server PDW transformation
hi Dinseh, thanks for reaching out - my understanding is that (a) you want to move data from Teradata to PDW and (b) migrate/re-write ...Answered | 6 Replies | 2085 Views | Created by Deenasusi - Monday, March 3, 2014 11:36 AM | Last reply by Artin Avanes (MSFT) - Thursday, March 27, 2014 7:08 PM -
0 Votes
Teradata Linked Server: How to write a teradata table
Insert into teradata and selects from ms sql.Answered | 5 Replies | 9140 Views | Created by etlman - Tuesday, April 17, 2012 6:28 PM | Last reply by etlman - Friday, April 27, 2012 12:04 AM -
0 Votes
Passing dynamic Parameters to TeraData Server using SSIS
Now try using this variable as source inside OLEDB source by selecitng data access mode as SQL Command from variable.Answered | 2 Replies | 9712 Views | Created by nz87f4 - Thursday, April 15, 2010 1:56 AM | Last reply by Muqadder - Thursday, April 15, 2010 9:17 AM -
1 Votes
Extract Data From Teradata using SSIS Package
Is there any other options to extract the data?Answered | 3 Replies | 1446 Views | Created by cmk1 - Friday, October 24, 2014 3:06 PM | Last reply by ArthurZ - Friday, October 24, 2014 5:30 PM -
0 Votes
get data from Teradata using SSIS
Hi Dkuud, To kill a Teradata session, you can use the Teradata Manager or use the following query: SELECT ...Answered | 5 Replies | 5461 Views | Created by Dkuud - Wednesday, August 14, 2013 8:35 PM | Last reply by Dkuud - Thursday, September 5, 2013 9:41 PM -
0 Votes
SQL to Teradata
One other way of doing this is perhaps Execute SQL Task in which you would do all using a stored procedure residing on the SQL Server side.Answered | 2 Replies | 4535 Views | Created by a123man - Friday, January 28, 2011 12:56 PM | Last reply by Reza Raad - Friday, January 28, 2011 4:08 PM -
0 Votes
Linked Server with TeraData
Basically, I ended up with Teradata team and they confirmed its a Tera Data Issue.Answered | 3 Replies | 9576 Views | Created by Karumajji - Tuesday, April 21, 2009 10:36 PM | Last reply by Brian N Wagstaff - Thursday, July 23, 2009 4:13 PM -
0 Votes
Teradata Source SQL Server where clause In SSIS
You can use an OLE DB Source adapter to extract data from the Teradata database without WHERE clause, then add a Lookup Transformation which lookups ...Answered | 2 Replies | 2329 Views | Created by cmk1 - Saturday, April 12, 2014 11:21 PM | Last reply by Mike Yin - Tuesday, April 15, 2014 8:21 AM -
2 Votes
Installing ODBC driver for TERADATA to use un SQL Server
this provider is 32 bit but my SQL server is 64 bit.Answered | 11 Replies | 10798 Views | Created by Anna25 - Saturday, July 14, 2012 6:13 PM | Last reply by Anna25 - Sunday, July 15, 2012 5:11 PM -
0 Votes
I am unable to connect to my local SQL server using (local)
Narasimham, by the looks of it you have installed SQL Server creating a Named Instance - [ServerName\InstanceName].Answered | 2 Replies | 5544 Views | Created by NarasimhamAVSL - Thursday, August 4, 2011 7:21 PM | Last reply by SHAH HS - Tuesday, August 9, 2011 5:11 PM -
0 Votes
SQL Server 2012 SSAS and Teradata as data source
Do you have the same providers installed on both the client and the server?Answered | 2 Replies | 1216 Views | Created by ndimic - Wednesday, February 26, 2014 4:56 PM | Last reply by Darren Gosbell - Monday, March 3, 2014 3:41 AM -
0 Votes
SQL-SSIS-Informatica-Teradata
My question is, if i want to use Informatica to load records from SQL Server to Teradata, do i still need to use ...Answered | 5 Replies | 4796 Views | Created by NSG12 - Friday, July 31, 2009 2:53 PM | Last reply by Nik - Shahriar Nikkhah - Friday, July 31, 2009 4:08 PM -
0 Votes
Pass query between SQL and Teradata
set the data access mode to: sql command.Answered | 2 Replies | 5828 Views | Created by NSG12 - Thursday, February 26, 2009 5:06 PM | Last reply by Duane Douglas - Friday, February 27, 2009 7:19 AM -
0 Votes
Cannot load teradata extension
I have installed .net data provider for Teradata.Answered | 6 Replies | 6273 Views | Created by BIRam - Friday, April 16, 2010 1:19 PM | Last reply by BIRam - Wednesday, April 21, 2010 8:42 AM -
1 Votes
I suceed to install SQL Server 2008 Mangement Studio WIndow7 & connect to an external server, but not for my local Server
In addition, to display the SQL Server information under the SQL Server Configuration Manager, please try to restart the Windows Management Instrumentation in ...Answered | 14 Replies | 7708 Views | Created by CuriousPeople - Sunday, December 26, 2010 8:31 PM | Last reply by CuriousPeople - Thursday, December 30, 2010 1:48 AM -
0 Votes
How can i moved .mdf local database to SQL server in vb.net
--Method 1 for Attaching USE master; GO CREATE DATABASE MyAdventureWorks ON (FILENAME = 'C:\MySQLServer\AdventureWorks2012_Data.mdf'), (FILENAME = ...Answered | 3 Replies | 3133 Views | Created by Manthanpl93 - Saturday, September 28, 2013 1:38 PM | Last reply by SaravanaC - Saturday, September 28, 2013 5:24 PM -
0 Votes
can I use a networked SQL Server instance without SQL on my local machine
Hello jnc, It's quite enough to have one central SQL Server running in your network.Answered | 4 Replies | 774 Views | Created by jnc - Thursday, October 10, 2013 4:23 PM | Last reply by jnc - Thursday, October 10, 2013 4:45 PM - Items 1 to 20 of 4114939 Next ›
No announcements