Yeah try Jasons suggestion. The dll it uses lives here \MIcrosoft SQL Server\100\DTS\Binn\DTS.dll (assuming 2k8)

If Jasons suggestion doesnt work you could try copying the DLL from someone elses machine...

Is this just within a single existing package or do you see the same behavior if you create a new package?

All that PK and FK will do for you is introduce data integrity. Depending on the source of the warehouse data the creator may already know that the data...

The hardest thing with SSRS expressions is the readability. The number of quotes, double quotes and brackets without any colour coding drives me insane.

The actual logic behind writing SSRS...

So you're trying to connect to a named instance without specifying the server name? Is that correct?

Fair enough 🙂 Am sure your suggestion will sort the issue anyway

Why don't you take the group numbers out of the insert text?

If there is no where/order by clause in your query then indexes are unlikely to help you.

Pretty sure you could use SQLTrace and audit the logon event. record it to a table and then use SSIS to output to whatever file format you like.

Although like...

I would start by looking at what other jobs run at the same time.

Create a view with only the 5 fields you want to be exposed. Give permissions to this view and not the base table

Following on from Lowells posts and thinking slightly outside the box you could always forget a SQL solution and maybe just use some freeware software like this one (

kapfundestanley (4/19/2012)

---

Thank you.I have msdb backups only for this year not for the period that I want.Why would I need backup covering the actual period?Is the information stored in the...

something like this will do the job if you dont need to return what appears to be a pseudo primary key on the backoffice table

SELECT ...

The question still stands. You are asking for everyone who is in office 711, which both Bob and Robert are.

What are you trying to achieve? Do you want...