kwoznica (11/26/2012)

---

Ok well I was able to get it to work.

In Flat File Connection Manager Editor, Under General, I set the Format to Ragged Right and Header Row Delimeter...

I would...

I would say the purpose of Thanksgiving should be to COUNT() your many blessing; but it has turned into STUFF() your belly.

Happy Thanksgiving,

Rob

kamal_ece (11/21/2012)

---

Lets say Employee dimension. If I have 3 sources having 3 Employee tables, when building a cube can I build one customer dimension? However, if I take traditional approach...

Are you saying that you have four seperate worksheets? I'm really not following...

imran 60091 (11/20/2012)

---

Just wanted to clarify if these 2 are treated the same in terms of licensing.

SQL Server Standard Edition does not include partitioning and enterprise edition does.

Is that to...

mohmad.shaik 7313 (11/20/2012)

---

hai,

can anybody tell me how to load the excel with diff columns

ie i have global , region, cluster, market

what i need is want to...

Please don't post the same question in multiple forums; it just splinters the responses.

See my reply at: http://www.sqlservercentral.com/Forums/Topic1386751-17-1.aspx

Rob

kamal_ece (11/20/2012)

---

Hi,

Is it mandatory to have a data warehouse in dimensional model to build a SSAS cubes above?

I'm trying to see if there is any scope to address few reporting...

var05 (11/19/2012)

---

Hi All,

I have to load data from one server to another server on daily basis using SSIS Package.

I have only one table to be populated from Source ->destination. But...

alroyswain (11/18/2012)

---

Hi,

I'm using an MDX statement to fill a listbox with available dates:

Current statement is

SELECT

NON EMPTY [Period].[Period by Financial Year].[Period] on COLUMNS

FROM [TESTCUBE]

This outputs data and dates, I...

blom0344 (11/17/2012)

---

I spend a week coming to grips with SSAS , being accustomed to Cognos DMR (Dimensionally Modelled Relational).

The first 3 days I was impressed, then things slowly started to...

tinnusqlserver (11/16/2012)

---

I have an ssis package which loads 1.2 million records of data from oracle into SQL SERVER 2008R2(with 32 GB RAM) dataware house table once every week. (truncating and...

Not working how? What's the error message? We can't see your system, so it's hard to give help without more information. Did you take...

Can't you just do a [font="Courier New"]SELECT TOP 100 *[/font] from the Excel source?

Or alternatively, take a look at: http://geekepisodes.com/sqlbi/2010/ssis-skipping-rows-and-columns-in-excel/

HTH,

Rob