Viewing 15 posts - 31 through 45 (of 535 total)
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...
September 18, 2012 at 5:05 am
Is this just within a single existing package or do you see the same behavior if you create a new package?
September 18, 2012 at 4:52 am
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...
September 18, 2012 at 4:24 am
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...
September 18, 2012 at 2:32 am
So you're trying to connect to a named instance without specifying the server name? Is that correct?
September 17, 2012 at 12:11 pm
Fair enough 🙂 Am sure your suggestion will sort the issue anyway
September 17, 2012 at 12:07 pm
Why don't you take the group numbers out of the insert text?
September 17, 2012 at 11:48 am
If there is no where/order by clause in your query then indexes are unlikely to help you.
September 17, 2012 at 9:52 am
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...
September 10, 2012 at 5:01 am
I would start by looking at what other jobs run at the same time.
September 4, 2012 at 2:34 pm
Create a view with only the 5 fields you want to be exposed. Give permissions to this view and not the base table
August 20, 2012 at 3:35 am
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 (
August 9, 2012 at 7:17 am
kapfundestanley (4/19/2012)
April 19, 2012 at 8:10 am
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 ...
March 29, 2012 at 9:06 am
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...
March 29, 2012 at 8:45 am
Viewing 15 posts - 31 through 45 (of 535 total)