| Thread | Last Post | Replies |
|
| How to reinstall the Business Intelligence Project in VS 2005? | 27 Feb 2008 16:05 GMT | 3 |
after I install the VS 2008, my business intelligence project under VS 2005
was missing.
Is it possible to reinstall the Business Intelligence project under VS2008?
How?
|
| HELP! - 8060 limit/select statement | 22 Feb 2008 13:06 GMT | 3 |
I want to know if it's possible to make a select statement that brings only
the records with a number of bytes of less than 8060
so, imagine I have a table with 10 records, and two of those ten records
have more than 8060 bytes, so, if I do this:
|
| Speed issue with a query on a large Dataset (Help needed) | 16 Feb 2008 16:58 GMT | 3 |
I have a Staging table with 29401560 records in it. No Indexes on this table
as it is the table loaded from my SSIS. I am performing an update on it using
the following query.
Update t1
|
| SSIS Question | 16 Feb 2008 16:55 GMT | 4 |
Hi,
Is there any way I can copy multiple tables using any controls in SSIS ?
Thanks.
|
| Newbie question | 12 Feb 2008 22:30 GMT | 7 |
I am interested in building a DW for my company. As usual, we have 4
different systems which holds different applications. I would like to know
what is the first step of buidling the DW? Retrieve the columns / data that
we need? Any good link to view?
|
| Moving from OLTP to OLAP sample | 12 Feb 2008 22:29 GMT | 2 |
Where do I find some example like
How to move (ETL) the AnventureWorks OLTP database into AdventureWorksDW
All the examples start with the exsisting DW and I would like to know how to
do it myself?
|
| Exporting Data from Rich Text Fields? | 12 Feb 2008 22:24 GMT | 1 |
I have an SQL 2000 database (used by a CRM package), and the field that
contains what we call 'History' is a Rich Text Field.
It basically starts like this: {\rtf1\ansi\deff0{\fonttbl{\f0\fnil\fcharset0
Tahoma;} [more follows here]. If I cut and paste this into a text document,
|
| Help! - DTS/Job Task (SQL Server 2000) | 12 Feb 2008 22:22 GMT | 8 |
I have this situation, I have a DTS package consisting of a series of data
transformations and data transfers from our server to remote servers. If I
execute the DTS from the Data Transformation Services --> Local Packages, it
runs smoothly without any problems. But, when I ...
|
| How many fact tables allowed per cube? | 11 Feb 2008 14:59 GMT | 3 |
Can an OLAP cube contain more than one fact table?
|
| Row of data interchaged automatically when import from MS xl 2003 | 08 Feb 2008 10:51 GMT | 9 |
I import MS Excel 2003 spread sheet in MS SQL Server 2000 through MS SQL
Server 2000 Enterprise Manager. In excel two sheets (sheet1 and sheet2) of
data is there. I imported first sheet data in first time in relevant table of
database and done second sheet of data in next time. ...
|
| dimensional modeling of magazine subscriptions | 07 Feb 2008 12:55 GMT | 1 |
could anyone point me to approaches on how to model a magazine subscription
business?
tia,
gigel
|
| Newbie design question | 01 Feb 2008 03:31 GMT | 4 |
I am new to the dw and I have a stupid question.
Our company has a Consultant assigned to each Customer. When I design the
Dimension tables, how do i determine if i need two tables, one for
Consultant and one for Customer or just simply add the Consultant Name into
|
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread