IA64 Teradata OLE-DB Or ODBC
Sep 5, 2006
I have a 32 bit development/playbox SQL 2005 SSIS that can see and run 32 bit OLE DB drivers from Teradata. Granted I have the same issues as others where a table or a view would work and not a query or a variable query. The alternative is to use Linked Server and OPENQUERY.
But our real development box is a 64 bit IA 64 using 64 bit SQL 2005. Non of the Teradata.com drivers would work/show up in the dropdown box of the Connection Manager since they are 32 bit. One option is to use the 64 bit Teradata ODBC drivers and then use the .Net ODBC connection instead. Linked server doesn't work either because the SQL 2005 is 64 bit and it is looking for 64 bit drivers.
Has anyone have any experience with 64 bit SQL 2005 and Teradata?
Looked at other 3rd party vendors such as ETI but their documentation excludes IA 64 (Itanium).
Planning to try again using the 64 bit ODBC and .Net Adapter but I'm interested to hear if someone (MSFT & NCR) would have a real solution for 64 bit.
Thanks
Anatole
View 4 Replies
ADVERTISEMENT
Dec 12, 2006
We've run into an issue running against the SQL Native Client ODBC driver (version 2005.90.2047.0) on Windows 2003 Server (Itanium). The "INFO: ODBC 64-Bit API Changes in MDAC 2.7" article (http://support.microsoft.com/kb/298678) doesn't say that the returned value for SQL_ATTR_CONCURRENCY changed to a 64-bit value, but if you request this attribute from the SQL Native Client driver, a 64-bit value is returned. The ODBC spec still indicates that SQL_ATTR_CONCURRENCY is a SQLUINTEGER value, which is 32-bit, even on a 64-bit platform.
This is easy to see by using the ODBC Test utility in the Windows SDK for ia64, "C:Program FilesMicrosoft SDKBinWin64ia64odbcte32.exe". If you connect to the SQL Server driver and then simply call SQLGetStmtAttr(SQL_ATTR_CONCURRENCY), you'll see that the *StringLengthPtr argument returns 8 bytes, when it should only return 4.
Note that we've also seen the same behavior with SQL_ATTR_ROW_BIND_TYPE as well as other statement attributes defined to return SQLUINTEGER values.
Has anyone else run into this?
Thanks,
Chris
View 3 Replies
View Related
Nov 4, 2007
Dear,
I have application create by MsAccess
and connect with Sql Server 2000 in x86
and now we transfer system to
HP rx3600 Intel Itanium
- Install Windows 2003 Server Enterprise (for Itanium)
- Install Sql Server 2005 Standard Edition (IA64)
and now we try to create ODBC connection
from client for testing.
But we can't not done it.
Anybody can tell us
how to create connection to sqlserver 2005 (ia64)
Regards,
Tee+
View 1 Replies
View Related
Jun 27, 2006
My Desktop OS is Windows XP Prof. Edition with SP2.
Which executable(X84 / X64 / IA64 ) is compatible with XP Pro SP2 ?
View 3 Replies
View Related
Aug 15, 2007
I have Two Dell dual Itanium 64 with 16 Gb of Ram each Running a default and a named instance of SQL. The Issue is that I have a bottleneck somewhere and noticed that the memory usage for sqlservr.exe is never over 120000k. I have adjusted till I'm blue in the face to get this memory to expand. My question is does this sound reasonable? Or I should look at other possible bottlenecks?
View 1 Replies
View Related
Dec 21, 2006
Dear all
I am running Itanium server 64Bit on cluster Mode with Sql Server 2000 Sp4 64 BIT ia version ported.
the itanimum has a 8gb of ram and 4 Processors.
it has one instance and 3 databases.
users connected about 200 Users.
But the processor load is going about 100% in itanium where in xeon about 30% only on the same databses
The database i copied from Xeon based server and ported on the itaminum server.
In normal Xeon server takes 2 Minutes for indexing . In itanimum it is taking more than 4 Hours for the same table.
Is any one can help with what sort of SP_configure script is advisible and best practices for itanumum server.
Plesae give me some best practices
thanks in advances
regards
Tamilvel
tamilve
IT head
View 2 Replies
View Related
Jan 24, 2008
Ok Here is the story with hopefully all the details.
I had a single node cluster Itanium server running W2k3 IA 64 Ent. SP2 with 2 x sql2000 ent sp4 and 1 sql2005 sp1 instances installed and a clustered file share.
All is well with them.
I attempted to add an additional node to my cluster which started out fine but when I tried to run the sql2000 setup to add this node, there are no warning or errors. Its a silent failure.
I tried many different scenarios but the results are the same. I evicted the node and then tried to run the setup on the evicted node. The setup ran without error. I tried to run setup on my single node cluster and it fails in the same manner. I read and read and from the sqlstp.log this is what I find. Does anyone have a clue what is wrong? i have check all my permissions but I can't put my finger on what it could be.Help Help.
1
<Func Name='InitDataFolder'
<EndFunc Name='InitDataFolder' Return='0' GetLastError='18'>
<Func Name='DetectComputers'>
1
<Func Name='DetectVersionOnMachine'>
NYCTDB04 D:SQL Server ENT 2000 - 64 BitSetupIA64inn 1
<Func Name='InsertVersionRecord'>
NYCTDB04 MSSQLSERVER 0 8.00.760 1033 0 3 1804890536 Enterprise Edition (64-bit) 2099209 1 NYCTDB41 0 1
<EndFunc Name='InsertVersionRecord' Return='0' GetLastError='183'>
<Func Name='InsertVersionRecord'>
NYCTDB04 BIZTALK 1 9.00.2047.00 1033 0 -1 -1 (64-bit) 133124 0 0 1
<EndFunc Name='InsertVersionRecord' Return='0' GetLastError='183'>
<Func Name='InsertVersionRecord'>
NYCTDB04 MYOFFICE 2 8.00.760 1033 0 3 1804890536 Enterprise Edition (64-bit) 2230280 1 NYCTDB42 0 1
<EndFunc Name='InsertVersionRecord' Return='0' GetLastError='183'>
<Func Name='InsertVersionRecord'>
NYCTDB04 SHARED_TEMP 3 8.00.760 1033 0 3 1804890536 Enterprise Edition (64-bit) 2230276 0 0 1
<EndFunc Name='InsertVersionRecord' Return='0' GetLastError='183'>
<EndFunc Name='DetectVersionOnMachine' Return='0' GetLastError='183'>
<Func Name='InsertComputerNameRecord'>
NYCTDB04 0 50010 539101189
<EndFunc Name='InsertComputerNameRecord' Return='0' GetLastError='183'>
<EndFunc Name='DetectComputers' Return='0' GetLastError='0'>
<Func Name='DetectIpResources'>
<Func Name='InsertIpResourceRecord'>
_sql$IpResources 0 144.210.119.64 255.255.255.224 Public
<EndFunc Name='InsertIpResourceRecord' Return='0' GetLastError='183'>
<EndFunc Name='DetectIpResources' Return='0' GetLastError='183'>
<Func Name='DetectGroupResources'>
<Func Name='EnumerateGroupResources'>
SQL 2000 Shared Group(NYCTDB41) NYCTDB04 Disk Q: 0
<Func Name='GetDiskResourceLetters'>
SQL 2000 Shared Group(NYCTDB41) Disk V 0
<Func Name='InsertDiskResourceRecord'>
Disk V 0 V SQL 2000 Shared Group(NYCTDB41)
<EndFunc Name='InsertDiskResourceRecord' Return='0' GetLastError='183'>
<EndFunc Name='GetDiskResourceLetters' Return='0' GetLastError='183'>
<Func Name='GetDiskResourceLetters'>
SQL 2000 Shared Group(NYCTDB41) Disk W 1
<Func Name='InsertDiskResourceRecord'>
Disk W 1 W SQL 2000 Shared Group(NYCTDB41)
<EndFunc Name='InsertDiskResourceRecord' Return='0' GetLastError='183'>
<EndFunc Name='GetDiskResourceLetters' Return='0' GetLastError='183'>
<Func Name='GetVSInfo'>
SQL 2000 Shared Group(NYCTDB41) NYCTDB04 0
<Func Name='EnumVSIPResources'>
NYCTDB41
<Func Name='InsertIpResourceRecord'>
NYCTDB41 0 144.210.119.88 255.255.255.224 Public
<EndFunc Name='InsertIpResourceRecord' Return='0' GetLastError='183'>
<EndFunc Name='EnumVSIPResources' Return='0' GetLastError='183'>
<Func Name='EnumVSResourceOwners'>
NYCTDB41
<Func Name='InsertVSNodeInfoRecord'>
NYCTDB41 NYCTDB04
<EndFunc Name='InsertVSNodeInfoRecord' Return='0' GetLastError='183'>
<EndFunc Name='EnumVSResourceOwners' Return='0' GetLastError='183'>
<Func Name='InsertVSInfoRecord'>
SQL 2000 Shared Group(NYCTDB41) 0 NYCTDB41 MSSQLSERVER 1 D:Program FilesMicrosoft SQL Server V:Program FilesMicrosoft SQL Server ipgnasharedsql.service ipgnasharedsql.service
<EndFunc Name='InsertVSInfoRecord' Return='0' GetLastError='183'>
<EndFunc Name='GetVSInfo' Return='0' GetLastError='183'>
<Func Name='InsertGroupResourceRecord'>
SQL 2000 Shared Group(NYCTDB41) 0 0 NYCTDB04
<EndFunc Name='InsertGroupResourceRecord' Return='0' GetLastError='183'>
<EndFunc Name='EnumerateGroupResources' Return='0' GetLastError='183'>
<Func Name='EnumerateGroupResources'>
Cluster Group NYCTDB04 Disk Q: 1
<Func Name='GetDiskResourceLetters'>
Cluster Group Disk Q: 0
<Func Name='InsertDiskResourceRecord'>
Disk Q: 0 Q Cluster Group
<EndFunc Name='InsertDiskResourceRecord' Return='0' GetLastError='183'>
<EndFunc Name='GetDiskResourceLetters' Return='0' GetLastError='183'>
<Func Name='InsertGroupResourceRecord'>
Cluster Group 1 1 NYCTDB04
<EndFunc Name='InsertGroupResourceRecord' Return='0' GetLastError='183'>
<EndFunc Name='EnumerateGroupResources' Return='0' GetLastError='183'>
<Func Name='EnumerateGroupResources'>
SQL 2005 Biztalk Group(NYCTDB40) NYCTDB04 Disk Q: 2
<Func Name='GetDiskResourceLetters'>
SQL 2005 Biztalk Group(NYCTDB40) Disk T 0
<Func Name='InsertDiskResourceRecord'>
Disk T 0 T SQL 2005 Biztalk Group(NYCTDB40)
<EndFunc Name='InsertDiskResourceRecord' Return='0' GetLastError='183'>
<EndFunc Name='GetDiskResourceLetters' Return='0' GetLastError='183'>
<Func Name='GetDiskResourceLetters'>
SQL 2005 Biztalk Group(NYCTDB40) Disk U 1
<Func Name='InsertDiskResourceRecord'>
Disk U 1 U SQL 2005 Biztalk Group(NYCTDB40)
<EndFunc Name='InsertDiskResourceRecord' Return='0' GetLastError='183'>
<EndFunc Name='GetDiskResourceLetters' Return='0' GetLastError='183'>
<Func Name='GetVSInfo'>
SQL 2005 Biztalk Group(NYCTDB40) NYCTDB04 2
<Func Name='EnumVSIPResources'>
NYCTDB40
<Func Name='InsertIpResourceRecord'>
NYCTDB40 0 144.210.119.90 255.255.255.224 Public
<EndFunc Name='InsertIpResourceRecord' Return='0' GetLastError='183'>
<EndFunc Name='EnumVSIPResources' Return='0' GetLastError='183'>
<Func Name='EnumVSResourceOwners'>
NYCTDB40
<Func Name='InsertVSNodeInfoRecord'>
NYCTDB40 NYCTDB04
<EndFunc Name='InsertVSNodeInfoRecord' Return='0' GetLastError='183'>
<EndFunc Name='EnumVSResourceOwners' Return='0' GetLastError='183'>
<EndFunc Name='GetVSInfo' Return='1168' GetLastError='203'>
<EndFunc Name='EnumerateGroupResources' Return='1168' GetLastError='183'>
<EndFunc Name='DetectGroupResources' Return='1168' GetLastError='183'>
<EndFunc Name='PerformDetections' Return='1168' GetLastError='0'>
View 1 Replies
View Related
Mar 21, 2007
Hi, I have the option of buying MS SQL Server 2005 Standard Edition IA64 with 5 CLT part number 228-04025, however will it work on the following spec server;
2.8Ghz P4
1Gb Ram
120Gbide hard drive
running Windows 2003 standard edition
If it helps you can call me on +44 (0) 1285 644091 or simon@310k.co.uk
Thanks
Simon
View 5 Replies
View Related
Jul 14, 2006
Just an FYI for those scheduling SSIS packages on 64bit Itaniums.
This came to light when using a 32 bit OLEDB driver on a 64bit Itanium.
When manually executing the package on the server through SQL Management
Studio, we got the expected results. However, when we scheduled the
package as a job, it failed every time. The error was:
"The AcquireConnection method call to the connection manager 'ConnectionName' failed with error code 0xC0202009€?.
We tried everything to fix this, but nothing worked. Finally we found
that when manually running the package, SQL Management Studio was calling the
32bit version of dtexec.exe, while the Agent calls the 64bit version of
dtexec.exe. The fix is to not use the "SQL Server Integration
Services Package" type in the job step, but use "Operating system
(CmdExec)" type. Then in the command box, call the 32bit (x86)
version of dtexec.exe.
Example:
C:Program Files (x86)Microsoft SQL Server90DTSBinnDTExec.exe /DTS
"File SystemSSIS Packages[PackageName]" /SERVER [SQLSERVERNAME]
/DECRYPT [password] /MAXCONCURRENT " -1 " /CHECKPOINTING OFF
/REPORTING V
View 1 Replies
View Related
Jan 4, 2008
Hi,
I want to install SQL server 2005 trial version from Microsoft, How do I know which excecutable to tale from these below?
Self-extracting executables:
X86 Executable
X64 Executable
IA64 Executable
Thanks
View 6 Replies
View Related
Aug 30, 2007
Hi, pls can anyone help me out with this? I'm installing SQL2005 SP2 over an Itanium machine with W2003 SP2 but it keeps on failing on those features. Client components got installed with no problems. I've installed SQL2005-SP2 over x86 and x64 (not Itanium) machines many times before successfuly. I've been investigating this issue for several days with no luck so I'm a bit clueless at the moment. As I'm using Administrator account I think it is not file permission related.
Summary says "Unable to install Windows Installer MSP file".
let me know if further info is nedeed.
Many thanks.
View 3 Replies
View Related
Jun 19, 2008
Hi,
I am trying to query Teradata tables from SQL Server 2005 using SSIS that will populate a table in SS 2005. I have been able to test the connection successfully. I choose the Query option b.c the tables in Teradata are over 100 million records and I don't want to copy those tables locally.
I am able to enter my query and parse it. I can even preview the query and see the results. A very simple query:
select distinct acc_yr
from d4574fdp.clm_dim
But when I try and execute the query, I get the following error message:
quote:
TITLE: SQL Server Import and Export Wizard
------------------------------
Could not connect source component.
Error 0xc0202009: Source - Query [1]: An OLE DB error has occurred. Error code: 0x80040E21.
An OLE DB record is available. Source: "OLE DB Provider for Teradata" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
------------------------------
ADDITIONAL INFORMATION:
Exception from HRESULT: 0xC0202009 (Microsoft.SqlServer.DTSPipelineWrap)
------------------------------
BUTTONS:
OK
------------------------------
I have the latest OLE DB Provider for Teradata installed. Is there some security setting that needs to be set? Any help would be greatly appreciated.
Thank You.
View 2 Replies
View Related
Nov 30, 2006
Does anyone know if/how SSIS works with Teradata?
View 1 Replies
View Related
Oct 13, 2006
Is anyone out there using SSRS with a Teradata data source?
R
View 22 Replies
View Related
Nov 8, 2007
Wether I'm trying to access a datapump task in an imported package in SSIS, or in 2000 enterprise manager
they crash once created. I can not alter or redo mappings or anything else.
After enterprise manager churns for 5-10 min it crashes.
SSIS partially crashes: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. After this I can no longer click on anything and have to end task on Visual studio.
I can do a disconnected edit on the package in enterprise manager and alter the statement, but as far as I know you can't really change much as far as mappings back in there.
This also means that my 2000 packages have been limited to 1 teradata pump per package.
This happened on my laptop, 2 coworker's desktops, and now that i've migrated to a new high end developer box it's happening on it also.
Any feedback/ideas?
View 1 Replies
View Related
Jan 14, 2008
I'm trying to convert old DTS packages over to SSIS and also create new SSIS packages that use teradata as a warehouse source for many different departments.
So far i've tried what I can find here on the forums:
using special syntax and wrapping the sql command in an alias/variable name
Methods i've tried:
using an ODBC connection string that works just fine in VB for pulling data. - test connection succeeds but when I select data reader source I get:
Error at Data Flow Task [DataReader Source[185]]: Cannot acquire a managed connection from the run-time connection manager
Using an OLE DB connection where I get the standard error many have gotten and I tried the listed use special syntax and wrapping the sql command in an alias/variable name from :
MSDN
Error at Data Flow Task [Source - Testing]: An OLE DB error has occurred. Error code: 0x80040E21. An OLE DB record is available. Source: "OLE DB Provider for Teradata" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
Currently i'm testing/trying this on a very simple view that produces 2 columns and 173 rows of string data.
I have not tried the .net provider and am reluctant to accept that as the only solution if it works as it would involve permissions issues and red tape here at the bank and is a less user-friendly solution for my dev team.
Any ideas?
Driver version on my machine and likely the other 5 that would need this to work:
3.03.00.01 12/17/2003
View 1 Replies
View Related
Nov 21, 2006
Hi,
How do I connect from SSIS to TeraData database. Is there any OLEDB providers available for evaluation.
If any of the experiences can be shared on this, it would be greatly helpful.
Thanks,
S Suresh
View 1 Replies
View Related
Aug 7, 2007
I want to add a step to an SSIS package to passthrough native Teradata sql statements so that they can be executed on Teradata. Does anyone know if I can use an "Execute SQL Task" to accomplish this? It should be very similar to passing native Oracle SQL to an Oracle server.
View 6 Replies
View Related
Feb 22, 2005
I've been informed that our data feed systems are going to be shut down and that our data will be residing in Teradata V2R5 databases. I was wondering if anyone knows if you can get connectivity to a Teradata server via Linked Server in the Security folder of SQL Server Enterprise Manager? If no then; Is it possible through a DTS package? Thanks for the info...
View 2 Replies
View Related
Feb 24, 2004
I am extracting data from an SQLServer database to load into Teradata using DTS. The performance is abysmal. The same data in a text file loads quickly via multiload. I can move the data to other DBMSs via DTS quickly as well. Is there some way for me to improve the elapsed time/performance while using DTS? If not, what is the best way to move data from SQLServer into Teradata?
View 1 Replies
View Related
Jul 29, 2013
Still having a problem with my SQL WHERE clause…
I have three variables on an Excel form that connects to a Teradata database. The first variable is a date format (DateworkedF and DateworkedT) the other two are text fields. (StatusX and ErrorTypeX)
I want to be able to search on any or all of these fields. (If the field is blank return all values)
Query = "SEL SRN_ACCT_NUM, QUEUE_NAME, ERROR_TYPE, SUB_ERROR_TYPE, DATE_WORKED, MONTH_WORKED, DATE_APPLICATION_RECEIVED, ASSOC_WORKED, ACCT_ID, STATUS, COMMENTS, REVIEWED_IND, REVIEWED_AGENT, LOAD_DT " & _
"FROM UD402.JD_MCP_MASTER WHERE " & _
"(DATE_WORKED >= #" & DateworkedF & "# Or #" & DateworkedF & "# IS NULL)" & _
"AND (DATE_WORKED <= #" & DateworkedT & "# Or #" & DateworkedT & "# IS NULL)" & _
"AND (STATUS = '" & StatusX & "' OR '" & StatusX & "' IS NULL)" & _
"AND (ERROR_TYPE = '" & ErrorTypeX & "' or '" & ErrorTypeX & "' IS NULL);"
View 5 Replies
View Related
Sep 17, 2007
I am trying to set up the Linked 2005 Server to Teradata v2r5, and have got most of the way there. My problem is that using both methods (OPENQUERY and SELECT with 4-part naming string) seems to submit only the SELECT * part to Teradata with the rest of the SQL waiting until the data is all pulled back to SQL Server. This is a problem when working with big tables! It puts a huge strain on the network, and also runs me out of temp space in Teradata. Is there a way to get ALL the SQL passed to Teradata? I am looking to create a Report Model for Report Builder or Pro-Clarity. I have a dummy SQL Server 2005 database set up with views of the Teradata tables through the Linked Server. Any help would be greatly appreciated!
View 1 Replies
View Related
Jun 16, 2006
I recently installed the Teradata .NET data provider and I am trying to use named parameters and multi-value parameters in my SQL. I am finding information on this topic hard to come by.
In order to get parameters to work do I need to write my own Teradata data extension from scratch, expand an existing data extension to work with Teradata, or can I simple edit my .config files to point to a generic extension wrapper already existing?
Thanks!
View 3 Replies
View Related
Oct 24, 2006
Hi!
I'm using SQL Server 2005 Enterprise on a Win2003 x64. I want to connect to a Teradata 2.6, but there are no x64 ODBC- or OLE-DB-drivers for Teradata yet. So, only OLE-DB can't be used as the 32-Bit OLE-DB-driver for Teradata is not visible e.g. if you want to create a linked-server-connection. One workaround would be to use "OLE-DB for ODBC", but this OLE-DB is also not available on my system.
Does anybody know a way to connect SQL 2005 x64 to Teradata or to get "OLE-DB for ODBC" up and running???
There is an entry to a similar issue (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=699116&SiteID=1) where the workaround "use 64Bit-ODBC with .net ODBC" (?) puzzles me!
Thanks
B.G.
View 7 Replies
View Related
Dec 27, 2006
Does anyone have any experience setting up paramters when using a Teradata data source? I am specifically looking for how to set up dates and multi-select drop down boxes as parameters. Using a fixed query against Teradata using SSRS is straight forward and is working well. Parameters, not so much.
R
View 1 Replies
View Related
Oct 10, 2007
Anyone know where I can find these drivers?
View 3 Replies
View Related
Nov 17, 2006
Hi All,
Please let me know whether we can use Teradata as Source in SSIS (Target is SQL Server 2005). ie. Do we have oledb driver for NCR Teradata to connect to it. Our SSIS will be hosted in 64 bit SQL, but for development we use 32 bit.
Any inputs is really appreciated.
Regards, kart
View 7 Replies
View Related
May 5, 2008
Hello!
I've created a data source that uses the OLE DB Provider for Teradata to connect to an existing Teradata database. Works fine.
I then use this data source within my project to create a Data Source View. Again, all works well.
However, the final step - creating a Report Model, bombs out in the wizard at the Completing the Wizard step with the following error: "[NCR][Teradata Database] Syntax error, expected something like a name between the 'SET' keyword and the 'TRANSACTION' keyword." (I elected for the wizard to only create entities for all tables, and create attributes).
If I try to create a Model manually, I get the following error when trying to build: "The Entity '<EntityName>' does not have any IdentifyingAttributes. Entity must have at least one IdentifyingAttribute."
Still fairly new to SSRS, so I'm hoping the issue is just a loose nut behind the keyboard Does anyone know what I'm doing wrong in trying to set this up?
Thanks in advance!
View 1 Replies
View Related
Jun 9, 2015
I am fetching large amount of data from teradata to sql server using linked server. I am facing below query:
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.)
View 0 Replies
View Related
Feb 10, 2008
Hi
I have a problem to connect to TeraData from SSIS.
I have the TeraData client (Query Man) that I connect to the TeraData using ODBC connection. When I connect with Query Man I can see the objects (views) of the correct scheme. However, when I try to connect with SSIS using the same ODBC connection €“ I don€™t see the objects of the specific scheme. The way that I connect to TeraData using SSIS is creating DS connection (with odbc) and then I create DSV €“ where this is the point that I can see lots of other schemes objects, but not the scheme€™s objects that I can see in the Query Man.
Can anyone assist?
Thanks,
Mario
View 5 Replies
View Related
Nov 21, 2005
I am trying to use SSIS to pull data from teradata to SQL2005.
View 19 Replies
View Related
Jun 9, 2015
I am fetching large amount of data from teradata to sql server using linked server. I am facing below query:
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.)
View 0 Replies
View Related
Jun 8, 2015
I have an SSIS package that successfully runs a Teradata connection query. However, when I schedule the job to run in the SQL Server Agent I get the following error:
Executed as user: SERVER_NAMEAdministrator. Microsoft (R) SQL Server Execute Package Utility Version 11.0.2100.60 for 64-bit Copyright (C) Microsoft Corporation.
All rights reserved.   Started: 7:53:26 AM Error: 2015-06-08 07:53:26.78    Code: 0x00000216    Source: Package1 Connection manager "Teradata"
[Code] ....
Why would a connection work in SSIS but not in a scheduled SQL Server Agent job?
View 2 Replies
View Related
