Viewing 15 posts - 4,591 through 4,605 (of 7,191 total)
Maybe the CODEPOINT function will work - something like this:
CODEPOINT(ACCOUNTNAME) == 2 ? "Blank" : ACCOUNTNAME
John
April 4, 2012 at 4:47 am
SSIS expression language doesn't allow "CASE", but it does have an equivalent - the "?" operator. Search for "SSIS expression conditional" or something similar and you should find the...
April 4, 2012 at 4:12 am
Animal Magic is right. However, doing this is just a kludge. What you should do, if it is in your power, is add a unique constraint on BackOffice(UserID,BackOfficeID)....
March 29, 2012 at 9:13 am
Animal Magic (3/29/2012)
What are you trying to achieve? Do...
March 29, 2012 at 8:51 am
Two times the user Bob? Surely you'll get a Bob and a Robert? Now, how are you going to decide which one of those to choose if you...
March 29, 2012 at 8:29 am
The CASE expression will stop evaluating conditions as soon as it finds one that is true. If you want the other conditions to be evaluated every time, you need...
March 29, 2012 at 7:58 am
Make sure that the CreateDeploymentUtility property is set to True. Right-click on the project in Solution Explorer and choose Properties, and go to the Deployment Utility page.
John
March 28, 2012 at 6:44 am
No, don't use a loop. Here's something to get you started, although it's not the full solution. Make sure you understand the code - have a read of...
March 28, 2012 at 3:24 am
You need to forget about FILEPROPERTY because it only works for the current database. You can use sp_spaceused '[TableName]' to get the details for each individual table. That...
March 27, 2012 at 4:09 am
I'm sorry, but you've totally lost me. You complain that it only works if the database has a filegroup (which, incidentally, all databases do), and then you say you...
March 27, 2012 at 1:43 am
Yes, FILEPROPERTY. From Books Online: "Returns the specified file name property value when a file name in the current database and a property name are specified. Returns NULL for...
March 26, 2012 at 8:29 am
Does the account that you are using to make the linked server connection have access to the database in question?
John
March 26, 2012 at 7:56 am
As far as I know, SSMS is a client tool and therefore doesn't require a licence, whereas Integration Services is part of the server product and therefore does. So...
March 26, 2012 at 6:37 am
Do you have the remote server set up as a linked server? Your syntax won't work if you don't. Another thing you could consider is to use Integration...
March 26, 2012 at 6:20 am
It depends... of course. If you don't have anything else running on the server, I'd start with 8GB for SQL Server and 2GB for the operating system.
John
March 23, 2012 at 6:38 am
Viewing 15 posts - 4,591 through 4,605 (of 7,191 total)