Viewing 15 posts - 1,021 through 1,035 (of 4,272 total)
sunny.tjk (10/5/2011)
When DTS compared to SSIS, which tool is the best with respect to performance? I was told that DTS performs much better if you are just moving data from...
October 5, 2011 at 3:59 pm
I'm guessing that the field value is null or nothing, are you sure there is a value in the field at that point?
CEWII
October 4, 2011 at 1:50 pm
What line is producing the error?
I'm guessing here:
sqlCmd.Parameters("@ContactID").Value = Row.ContactID
OR
If (reader("FirstName").ToString() <> Row.FirstName) Then
You might need to test for DBNull, using a command like:
If dataRow.Item("BlockSize") Is DBNull.Value Then
I chopped that...
October 4, 2011 at 1:43 pm
I think the idea is that the tools will let you develop for any edition but you can't actually run them on the server unless the features are supported by...
October 4, 2011 at 1:02 pm
Ah, excellent point.. But the answer is still the same..
CEWII
October 4, 2011 at 1:00 pm
Are you sure it isn't just docked in a weird position? I agree it can't be disabled, but it can be moved around. I keep mine docked and...
October 4, 2011 at 12:59 pm
Hm, odd, on my databases I see a sys.sp_addrolemember but not a dbo.
the way sp_ sprocs are supposed to work is that if it doesn't find a local version it...
October 4, 2011 at 12:56 pm
You should be able to create it in a new resource group without removing the existing server. I agree you can't add SSAS to the existing group from the install,...
October 4, 2011 at 12:48 pm
My experience tends to indicate that BIDS will run the component even if it is a higher edition. Not sure I can prove that.
But will fail when you try...
October 4, 2011 at 12:42 pm
Without some extra tools (which I can't name) it isn't possible. Unless you created a lot of variables that are scoped wrong this is really just an inconvenience. Sorry...
October 4, 2011 at 12:37 pm
Phil is right on track, you have to have SOMETHING the same between the file and the database to match against. If you don't have a matching field it...
October 4, 2011 at 12:33 pm
sqlstar2011 (10/3/2011)
an extra clustered ssas would require an extra license. thats what i was told.
That depends a lot on the config, but a separated database and SSAS still requires an...
October 4, 2011 at 12:31 pm
I might be mistaken but those system sprocs are stored in a special system database now (as of 2005) and master before in 2000 and before. You not finding...
October 3, 2011 at 4:02 pm
Perry Whittle (10/3/2011)
just out of interest, what do you have against a clustered instance of analysis services?
I was just thinking this myself..
As for scripting out the logins, you want to...
October 3, 2011 at 3:59 pm
To be honest I think your approach is probably not the best.
For big database I can definitely see it, but for smaller databases I generally break then up manually, meaning...
October 3, 2011 at 3:55 pm
Viewing 15 posts - 1,021 through 1,035 (of 4,272 total)