Yes, any time a piece of data could be the child of more than one parent, you have to have an indicator of which parent it goes to.

Ideally, getting just...

Is the sp also a hog when you execute from within SQL console?

Has it processed successfully? Process FULL.

are you able to connect to the source of the linked tables? By that I mean, skip Access and go to where the linked-to-Access tables actually live. ...

I do think it's better for the industry in general to let the "me, too, I wanna be in IT and make big money" crowd washout. It's not worth...

Jeff Moden (2/5/2012)

---

quynh012012 (1/6/2012)

---

quynh012012 (1/3/2012)

---

Hi,

I do not agreed with you. Any way, your points of view make me thinking about some thing for my project.

Pls try to keep posting. Tks...

If you were compiling census data, then, sure, maybe demo data goes in the fact table, but it seems to me that you are using it to filter, in which...

Not sure I understand the problem with users / report / table, but, it seems that you have appropriately defined the level of granularity in your cube.

If you simply browse...

Dim sLastName As String = Dts.Variables("LastName").Value.ToString

Capt. Sigerson (2/3/2012)

---

Hello all,

I have a couple of questions related to a project I'm on:

1. I've got a working SSIS package that opens a CSV file, uploads it into...

Access 97 is back in time somewhat, so not sure this will work for you, but for getting Excel info in, we are using Native OLEDB\Microsoft Office 12.0 Access Database...

great, glad to hear it!! We use Windows integrated security, so life is really easy for me so long as I don't accidentally encrypt a package.

Since you say you are new to SSIS, I want to make sure that you have first created the connection mgr successfully?

Also, are you able to connect to whatever sources...

My thought is that the options are laid out for you in this thread. Creating a custom component would be my choice given your stated requirements/limitations, if it MUST...

Thank you! that worked!