Viewing 15 posts - 3,076 through 3,090 (of 7,191 total)
Alex
You can use Package Configurations and pass in the variable value via the config file or table, or you can have the package fetch the value at runtime, for example...
September 2, 2015 at 7:08 am
I imagine you'll have to concatenate, something like this:
'*' + $Code + '*'
I don't use Powershell all that much so I'm afraid I don't know the exact syntax off the...
September 2, 2015 at 5:58 am
My guess is that the Get-QADGroup cmdlet detects the variable in the middle of the search string, whereas Get-ADGroup treats it as a literal. You'll need to find a...
September 2, 2015 at 5:27 am
Yes, certainly if you need to connect to multiple sources and destinations every time your package runs. My advice was based on my assumption that you only needed to...
September 2, 2015 at 5:23 am
Please will you post the contents of the SQLAGENT.OUT file, if there is one? If there isn't one, that's probably your problem - the SQL Server Agent account doesn't...
September 2, 2015 at 5:14 am
Alex
Yes, it's very easy to tie yourself in knots trying to escape your quotes with backslashes. I don't know whether it's an option for you, but I use 8.3...
September 2, 2015 at 5:11 am
I think the important thing is that backups are made to a specified location, and then backed up to tape as soon as possible. Your network admins would then...
September 2, 2015 at 4:49 am
Damian
For moving through from dev to test to live, use Package Configurations. I find it works best with a configuration file that you specify in your job. There's...
September 2, 2015 at 4:43 am
Another option, if you know in advance which files you need to process, is to get them all into an ADO result set and loop through them with a For...
August 28, 2015 at 4:14 am
If you will definitely only have one file or all files to process, have two separate tasks: one a loop, and the other a simple processing of the single file....
August 28, 2015 at 2:11 am
Use your favourite scripting language to find the path to the file. For example, in a simple command prompt, you can do it like this:
dir x:\MyTopLevelFolder\MyFile.ext /s
John
August 28, 2015 at 1:30 am
Your requirement isn't very clear, but if I understand correctly, you want something like this:
SELECT
PropertyID
,SUM(RentableSqFtTotal) RentableSqFtTotal
,COUNT(FloorNameID) NoofFloors
,SUM(GrossFloorSqFt) GrossFloorSqFt
,SUM(RentableSqFtTotal) - SUM(GrossFloorSqFt)
...
GROUP BY PropertyID
John
August 28, 2015 at 1:25 am
As part of the installation wizard, you will be given a list of processes that are running that will make a reboot necessary. You can stop those processes and...
August 28, 2015 at 1:15 am
Welsh Corgi (8/25/2015)
The Publisher Server is 2012 and the Subscriber is 2014. That might have something to do with the performance.
Yes, the Cardinality Estimator was significantly "improved" in 2014. ...
August 26, 2015 at 2:06 am
Viewing 15 posts - 3,076 through 3,090 (of 7,191 total)