| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | I have several SSIS packages that import data from files. I am having
trouble reliably determining whether a file is in use. I am working...
Everett Music
|
03-24-2010 07:24 AM
Todd C  | 3 | 782 |
| | | Giving the following senerio.
A wireless phone company Sprints has an application that tracks the
transactions.
A transaction can consist 1 phone...
always a Newbie
|
03-24-2010 06:18 AM
Mark Fitzgerald | 2 | 790 |
| | | Hiya,
So I am in SQL Server Business Intelligence Development Studio 2008. I
have a Foreach file enumerator and a file connection that points to...
ChrisW
|
03-24-2010 06:13 AM
Mark Fitzgerald | 1 | 499 |
| | | Poznan - ETL/Reporting Developer
For our international project we are looking for a developer
with ETL and/or reporting experience.
The desired...
Pawel Debski
|
02-05-2010 11:39 AM
Pawel Debski | 0 | 860 |
| | | 許多性能問題和安全性您的計算機*成惡意病毒，最好的辦法對付，這是得到承認和防病毒在計算機上安裝更新
...
antivirus gratis
|
02-02-2010 06:19 PM
antivirus gratis | 0 | 493 |
| | | Muchos problemas de rendimiento y seguridad de tu computador son causados por
virus maliciosos, la mejor forma de combatir esto es tener instalado...
antivirus gratis
|
01-29-2010 07:39 AM
antivirus gratis | 0 | 649 |
| | | Hi,
I am a sql developer, i am new to Warehouse. can any one help me in
making me understand as what this is how is this differnt to normal sql...
KSC
|
01-25-2010 07:41 PM
Todd C | 1 | 540 |
| | | Good morning
I am creating our first cube in our relational data warehouse. We are just
learning SASS and will not be moving this to SASS for a...
Omid Golban
|
01-25-2010 07:37 PM
Todd C | 1 | 379 |
| | | Would you use a date data type for a date column inside a dimension? Or would
you use a string (possibly CHAR(10))?
A date data type can be converted...
Omid Golban
|
01-25-2010 07:32 PM
Todd C | 1 | 399 |
| | | Consider a simplified Policy fact table with following columns:
CustomerKey
... bunch of other keys
PolicyMonthlyPremium
At the time a policy is...
Omid Golban
|
01-19-2010 11:43 AM
Omid Golban | 2 | 375 |
| | | Many computer problems are caused by viruses and malware on your computer.
The best and easiest way to correct this is to use a recognized antivirus...
antivirus gratis
|
01-15-2010 05:48 PM
antivirus gratis | 0 | 402 |
| | | On Fri, 12 Jan 2007 14:11:04 -0800,
labsRcoolcommunitynospan (AT) discussions (DOT) microsoft.com wrote:
You will need to setup the driver and DSN...
Darren Gosbell [MVP]
|
12-30-2009 03:21 PM
MOOOOVE | 1 | 526 |
| | | I have three tables.
Table 1 - Customers:
CustomerID
CustomerName
Table 2 - Products:
ProductID
ProductName
Table 3 - Prices:
ewm
|
12-30-2009 01:46 PM
ewm | 2 | 559 |
| | | Apologies for cross-postings. Please send to interested colleagues and
students
-- CALL FOR PAPERS - Deadline for submissions: 19 February 2010 ...
natty2006@gmail.com
|
11-25-2009 06:15 AM
natty2006@gmail.com | 0 | 533 |
| | | Apologies for cross-postings. Please send to interested colleagues
and students
-- CALL FOR PAPERS - Deadline for submissions: 19 February 2010...
natty2006@gmail.com
|
11-25-2009 06:05 AM
natty2006@gmail.com | 0 | 435 |
| | | I am looking around for an good existing proc to build a dates table. Have
looked in project REAL and did not see one there. Anyone know where I...
Doyle
|
11-24-2009 06:58 AM
Harald | 3 | 511 |
| | | We at Nob Hill Software are working on a new query tool:
http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut
You can read all about it on...
Mia
|
11-18-2009 07:21 AM
Mia | 0 | 393 |
| | | More than anything, its a generic interface to your data. Any data.
If it can be shown in a tabular format, we can work with it. (six
months of...
Mia
|
11-17-2009 09:06 AM
Mia | 0 | 424 |
| | | The following system error occurred: .
This appears regularly on reports. It does not seem to be connected to
whether the report returns a lot of...
Nick Large
|
11-06-2009 11:19 AM
Ovidio Guerra | 21 | 1,354 |
| | | Dear all,
I try to make a connection to my SQL Server Analysis Services Server with
SQL Server Management Studio , but I get the message:
TITLE:...
Edgar
|
10-06-2009 06:00 AM
Edgar | 6 | 693 |
| | | I can't find a forum that can answer this Excel 2007 delima.
I have a workbook that has 5 worksheets. Sheet 1 is linked to one of our SQL
tables...
tg112001 via SQLMonster.com
|
09-08-2009 10:51 PM
Todd C | 1 | 491 |
| | | Hi,
Hope this is the right forum for this kind of design questions...
I design a data mart for an inventory system. I need "most" facts...
Jerome
|
09-07-2009 12:18 AM
Jerome | 0 | 412 |
| | | I have a very large database in ms sql (30tb) and want to extract (somehow)
data for just one client in order to make a small comapct version that we...
peter
|
09-01-2009 02:41 PM
peter | 0 | 438 |
| | | I'm new to Analysis Services, and had a basic MDX Question. Here's
the (simplified) structure of my cube:
1 Fact - Pendings
* Count
* Offer ID
1...
Pang Diddles
|
08-31-2009 12:25 PM
Pang Diddles | 0 | 434 |
| | | Hi All,
I've been working on a cluster design (n+1) for server consolidation on a
service environment. One node will host a single sql server...
Ada
|
08-19-2009 09:50 AM
Ada | 0 | 619 |
| | | Apologies for cross-postings. Please send to interested colleagues and
students
-- CALL FOR PAPERS - Deadline for submissions (2nd Call): 21...
natty2006@gmail.com
|
08-10-2009 09:40 AM
natty2006@gmail.com | 0 | 459 |
| | | I have a performance issue with SSAS.
My fact table has many columns (over 500) and it's my active fact table at
the moment. However, I only care...
Panos Stavroulis.
|
08-08-2009 08:22 PM
RickNZ | 1 | 490 |
| | | Hello,
looking into Management Data Warehouse report results i get
FT_IFTS_SCHEDULER_IDLE_WAIT (22 %)
What is that counter means ?
Please...
Tal Bar-Or
|
07-29-2009 01:53 PM
Russell Fields | 1 | 594 |
| | | I am not an SSAS expert but I have inherited some SSAS servers . .
I have some cubes which can not refresh due to new column values in the
data, I...
Snake
|
07-28-2009 05:41 PM
Snake | 0 | 680 |
| | | "Kumar" wrote:
If you are interested in accellarating a SQL Server Data Warehouse
deployment, particularly if you have several disparate data...
RM09
|
07-21-2009 12:09 PM
RM09 | 0 | 498 |
| | | Apologies for cross-postings. Please send to interested colleagues and
students
-- CALL FOR PAPERS - Deadline for submissions (extension): 31...
natty2006@gmail.com
|
07-21-2009 03:54 AM
natty2006@gmail.com | 0 | 426 |
| | | Hi, I wrote a couple of packages for SQL 2008, I'm trying to write Scripts
(task) in SSIS, but I get an error since there is no Pre-compile option It...
Carlos A.
|
07-20-2009 11:10 AM
Carlos A. | 0 | 461 |
| | | There is an option in the Analysis Manager to "Process the Database".
I would like to know if there is a way to call this function from the
command...
Rob
|
07-17-2009 09:18 AM
Rob | 0 | 474 |
| | | I am new to SQL Server, and am in the process of moving up from
Microsoft Access to Server Server.
In Access I have an import routine that uses a...
aliciap1214
|
07-14-2009 12:25 PM
aliciap1214 | 0 | 422 |
| | |
Rich Lawson
|
07-05-2009 10:26 PM
Rich Lawson | 0 | 687 |
| | | Hi,
Microsoft SQL Server Analysis Services Designer Version 9.00.4035.00
Microsoft SQL Server Analysis Services Version 9.00.1399.06
In the 'Data...
Paul
|
07-01-2009 05:50 AM
Paul | 0 | 434 |
| | | Hi,
I am Newbie in SSIS .Can any tell me is there any we can Read Data From
Mainframe Sequential Files on MVS/0S390 IN SSIS to SQL Server.At Present...
Venkata
|
06-16-2009 11:05 PM
Venkata | 0 | 446 |
| | | Hello,
I have some AS2008 cubes that I've created and deployed to the web via
OWC. I can see these cubes through IE 7 but not through IE 6.
In...
clemts
|
06-13-2009 11:17 AM
CK | 1 | 464 |
| | | I have a quite large DWH table (SQL 2005) with approximately
800.000.000 records. Somewhere in the ETL proces (SSIS) I need to
delete about...
Joost
|
06-12-2009 02:02 AM
Paul Wehland | 2 | 418 |
| | | Hi,
Please let me know if you have any openings for our Teradata DBA.
Tarun Senior Teradata DBA
Availability Immediate
Relocation Open
Visa...
Raad
|
05-21-2009 12:45 PM
Raad | 0 | 408 |
| | | NEW 1000 Watt Halogen Work Light w/stand Workshop pair
Price:$29.99
Image: http://bestdeallocator.info/image.php?id=B001JI49OA
Best deal:...
Aragon@ray.com
|
05-20-2009 10:42 PM
Aragon@ray.com | 0 | 466 |
| | | We have a dimension that is used in one fact table. We would like to use the
same dimension for another fact table. The issue is that we need to...
Owen J.
|
05-20-2009 08:26 AM
TC | 2 | 467 |
| | | I'm having a problem with our enterprise data warehouse that I hope someone
can assist me with. Here is how security is currently configured, and...
TC
|
05-19-2009 11:30 PM
TC | 0 | 428 |
| | | Greetings,
I'm having an issue with our data warehouse. Every night it is refreshed
with data from our production environment, and then more SSIS...
Justin Biggs
|
05-13-2009 02:45 PM
Russell Fields | 1 | 426 |
| | | Hi, I'm new in the Warehouse world. I have a cube, I created this cube from
a table from sql server database, in this cube, I need create a KPI...
Juan Carlos Juarez
|
05-07-2009 04:56 PM
Juan Carlos Juarez | 0 | 409 |
| | | My cube processes with no errors, the table it's being built from is
populated. I have 5 measures - the first one is visible and correct. The
rest...
db2nd
|
04-30-2009 03:00 PM
db2nd | 0 | 373 |
| | | Palladian Consulting is seeking 2 SQL Programmer Analysts V Data
Warehouse for a 6 month contract in New York, NY
Required Experience, Skills,...
Robin
|
04-29-2009 01:26 PM
Robin | 0 | 341 |
| | | We are preparing to roll out our BI portal that makes use of Performance
Point. We need to put together a good local dev environment and I...
Joe H
|
04-29-2009 10:11 AM
Joe H | 0 | 392 |
| | | I keep getting the following message each time I attempt to run a Data
Profiling Task; see below.
I can not find another post anywhere were another...
Glen At MOU VA
|
04-20-2009 03:26 PM
Glen At MOU VA | 0 | 329 |
| | | How do I store the nodes of a tree-structure i an table, so it's easy to show
the tree in a windows-program ?
I'm thinking about fwd- and...
ravno
|
04-10-2009 06:11 PM
ravno | 0 | 324 |
