Description:
Microsoft's SQL Server and related products.
|
|
|
SSIS lookup across disparate servers / DBs
|
| |
Hey there, I need to do a lookup within SSIS, however I need to be able to reach across / join to two disparate servers / databases in my lookup. However, the SSIS Lookup object only has 1 “OLE DB Connection manager” connection at its disposal. E.g. SELECT dw.CountryKey, lir.CountryCode FROM DB1.dbo.Country lir... more »
|
|
|
Connectiviity error involving Sql Server
|
| |
This is the error I am getting: Connectivity error: [Microsoft] [ODBC SQL Server Driver] [SQL Server] Conversion failed when converting the varchar value '4/24/' to data type int. From [link] Posted via DevelopmentNow.com Groups... more »
|
|
|
self join returns unwanted rows
|
| |
SQL 2000 under W2K I don't know how to deal with reptetitive results from self-join, any pointers would be appreciated. I have an order table CREATE TABLE [dbo].[XXX]( [EMP_ID] [int] NOT NULL, [DRV_ID] [int] NOT NULL, [ORDER_ID] [int] NOT NULL, [SHIFT_ID] [int] NULL, [ORDER_TIME] [datetime] NULL,... more »
|
|
|
Column naming standard – general opinions
|
| |
Don't want to start a long-winded discussion, just seeking some general views. . . I was trained in SQL years ago and was encouraged to use lower-case letters with words separated for emphasis using the underscore character, for example: customer_num, employee_id, invoice_line, transaction_code... more »
|
|
|
Yellowfin dives into Partnership with Techwave in the Philippines
|
| |
Philippines, November 13, 2009 – leading Business intelligence (BI) firm, Yellowfin, today announced details of its exclusive distribution partnership with Techwave. The new alliance will see Techwave offer the Australian-developed BI solution to corporate and government clients as well as develop a larger reseller and partner community... more »
|
|
|
Backup to netwerkdrive
|
| |
Hi I'm running SQL-server 2005, and when I try to backup, I don't see any networkdrive, only C: is available. Any suggestions ? Tanx in advance ! D
|
|
|
|
