If you are trying to using kerberos (Windows) authentication then you will definately need to set up Trusted Delegation for the Report Server (i.e. when a user connects to the...

hi leafsword,

to be honest I think we ended up changing a couple of things - the combination of which resolved the issue.

That said - I do have a few questions...

any ideas anyone? .........

Hi All,

Hopefully someone can help point me in the right direction. Let me just start by saying I am a complete newbie when it comes to scripting a task...

I done the MCITP which was quite good but I did find at the time there was a bit of a gap between what the book/course teaches you and what...

FAO tskelly:

If your finding the standard SCD component of SQL slow, have a look...

ah ok.

Well learnt something new today.:-)

Puzzling.

But I thought you could use comments in OLE DB source components as it would basically execute as a T-SQL command?!

I still have comments in my statement (see...

sackmeister / DaRube

When I first looked at calling packages - it's pretty straight forward. specify if it's stored in SQL or on the file system.

That simplistic view has it's...

depends

as previously said - need more info, but Union ALL sounds like what you want.

Update:

For those interested I resolved the issue, bit it's a little bit of a mystry as to why it was an issue.

I decided to try and strip out all the...

that read like you haven't yet set up the 'dbo.transactions_' table.

this is need so that you configure the adapter. It servers 2 purposes. 1- it provides an actual table...

no problem - credit where credits due! 🙂

Hi again Luke,

Something else I've just tried is to setup another DNS record to point to the report server (as we have other RS that use DNS records like LiveRS.myDomain.net)

still...

Hi Luke,

to answer your questions....

- the machine is NOT in the public domain. It's on a private company network, using CompanyName.net for the domain name.

- There aren't any firewalls between...