Sathish Kumar. Rajaram (4/15/2013)

---

Hi,

I am a newbie currently trying handson on desinging SSIS and Star schema.

I have 2 tables Location (LocID, LocName) and Center (CenterID, CenterName, LocID). I have designed...

rka (4/14/2013)

---

Someone from my company's strategy has said that the Data Warehouse model needs to be:

- Atomic

- 3rd NF

- Relational

But I disagree. I always considered DW models to be:

- Dimensional

-...

Looks like a homework question, but lookup UNION and UNION ALL in books online.

http://msdn.microsoft.com/en-US/library/ms180026(v=sql.105).aspx

HTH,

Rob

demin99 (3/25/2013)

---

Hi

Iam trying to access Sharepoint data from SSIS. Iam not able to use the sharepoint adapters because I don't have enough privileges to install on my client...

I guess you could create a...

astrid 69000 (3/15/2013)

---

hi,

i have another question (or two) 🙂

1) i want the mdx to always return the data from yesterday without choosing the data, can someone please tell me how...

Mackers (3/14/2013)

---

A member is one thing - one product or the sum/avg of a set of products

You need to define your set as a set as below - a set...

I'm sure there must be a better way, but I did get this to work by:

MEMBER [Measures].[Yearly Adv Req] AS

(

Ancestor( [Date].[Calendar].CurrentMember, [Date].[Calendar].[Year]...

Just a couple of ideas:

For naming conventions I go with the suggestions in Jamie Thomson's blog: http://consultingblogs.emc.com/jamiethomson/archive/2006/01/05/SSIS_3A00_-Suggested-Best-Practices-and-naming-conventions.aspx

You might also want to have some type of standards for auditing/logging fields on...

Reading this thread: http://www.sqlservercentral.com/Forums/Topic836951-146-1.aspx,

the packages are stored in the [font="Courier New"]sysdtspackages90[/font] in the msdb database. You can take the xml and store it in a .dtsx file and have...

Just off the top...

chess-288252 (2/25/2013)

---

Hi,

I was wondering what do you guys use to map the data flow in ETL. I am looking at the field level flow of data. By this, I mean...

You can't use the T-SQL in SSIS until you get it working in SSMS (as I'm sure you know). I don't have the DDL for your tables, but double...

Apparently not.

Let me restate to see if I understand:

It sounds like you're asking if you can use SSIS to take data from your source and transform/convert it into a flat file....