Hi all,

Could anyone help me with issues I'm having with the reverse scenario - I'm trying to create an SSIS package to write from SQL 2008 TO an Excel xlsb...

Never mind, got it. I was trying to do it through the table properties, but doing in the properties for the group item worked.

I'd be much happier if that were the case, too, but sadly the client is external to the company and can't be given direct access to the SQL data.

Thanks for that, Dan. I've had another quick chat with the client, and what he's doing is as follows: taking the excel sheet generated in SSRS, running a macro to...

Awesome, worked like a charm! Thanks!

To be fair, the person who was doing the mindless drudgework recently left the company (I suspect the leaving might be connected to the drudgery!), which is why the question...

I think I might be in love with SQL Server Agent. 😀

What used to take one of my colleagues a full day of work - keying in sales figures, manually...

Thanks for all the assistance with this, guys. If anyone is in a similar situation, this link provides a nice step-by-step walkthrough on how to set up an SSIS package...

Out of curiosity, does DTS also allow for this, or is it something which has to happen through SSIS?

GSquared (6/17/2008)

---

If you do go with the SSIS idea, it will be easy enough to set up, so long as the data is in a standardized format. Have the...

I eventually got there in a roundabout way. A little more Googling led me to try something which hadn't occurred to me - disabling anonymous access within Directory Security on...

Thanks for that. Don't suppose you can help with the other problem, I'm still having no joy at all in getting that part going? 🙂

One (hopefully) final question: everything was working perfectly when I was testing it locally, it was grabbing the user name from my computer and using it where I wanted it...

It's going quite well thus far, I'm able to enter data into the DB, and I've got my date field being auto-filled by an insert trigger, and it's all working...

Solved! Primary Key (or lack thereof) was indeed the issue. Thanks for your speedy help!