I set up my Excel connections using OLE DB for MS Office Access 12.0 and set Extended Properties to Excel 12.0

We found out that the Excel connection is too flakey...

For me, user interaction requires forms with directions and field validations. Which I would build using a tool suited to that purpose. I never trust the users. It...

Duran (1/24/2012)

---

Hello,

Thanks for getting back, I understand that there is a duplicate key and it needs removing, the problem is I am not sure how to do that, or where...

we have a couple BI tools inhouse:

Targit and Tableau

I'm not a user of them so can't tell you much about them but maybe worth a look.

Duran (1/23/2012)

---

Hello, I hope someone with more experience can help me. I am working my way through the 70-448 MS Press study guide and I am adding a dimension to...

Never good to go back and explain why something isn't possible, but, you might have to. I will hope for your sake that the info you seek is...

Sounds like someone gave you lousy requirements!

In my opinion, if there is no column in which to check the criteria, you cannot use that criteria.

That said, not knowing where your...

Your package will need to send the variables with each run, if that's the question?

mine are set as configurations and they are on the SetValues tab of the job step....

exactly my suggestion for whenever Access seems to not be working well anymore. Access tends to be corruptible. Best you can do is copy your objects out of...

vba transfers quite well to vsa.

You could copy and paste your vba into the script component and edit there.

Since ssis script component is crap for debug, I generally...

Tiz the problem with our work - No One Way to do anything.

Interesting, tho, if you can capture input at run time. Could be a major PITA...

My previous employer was a hard sell on dw so I whipped up "serve yourself reporting" so I could get the confusing-to-the-users terms out of there and they could focus...

some of the components are grumpier than others. Generally clicking something else and going back to the desired state works. Merge Join has typically been the one I...

Sometimes it's just better to have those intermediary objects. I mostly do it for audit purposes but sometimes it's the path of least resistance to providing the correct and...

Probably you can store it in a variable.