Phil Parkin

Forum Replies Created

Viewing 15 posts - 6,766 through 6,780 (of 13,877 total)

RE: Are the posted questions getting worse?

Steve Thompson-454462 (8/26/2016)
Grant Fritchey (8/25/2016)
Eirikur Eiriksson (8/25/2016)
Taking my girls (7 & 9) to New York this weekend, does anyone have a suggestion on what to do there for their age?
😎
The...

August 26, 2016 at 8:05 am

#1897807
RE: Service Pack 2 Installation Failure from 12.1.4457.0

Verify DefaultData key under the instance hive points to a valid directory.
Have you done this?

August 25, 2016 at 5:00 pm

#1897683
RE: Are the posted questions getting worse?

GilaMonster (8/25/2016)
Grant Fritchey (8/25/2016)
GilaMonster (8/25/2016)
If you were to attend a keynote presentation on "New features of SQL 2016", would you prefer brief demos of each new feature? Just discussion, along...

August 25, 2016 at 2:08 pm

#1897654
RE: How to prevent disabled Sites in CRM from showing in SSAS and SSRS

kevin_nikolai (8/25/2016)
Hi Phil, I used the section:
Data Warehousing »
Integration Services »
How to prevent disabled Sites in CRM from showing in SSAS and SSRS
So I was looking...

August 25, 2016 at 2:04 pm

#1897650
RE: CALCULATING DELAY SECONDS

JALLYKAMOZE (8/25/2016)
J Livingston SQL (8/25/2016)
I asked a similar question on one of your earlier posts.....
for example
"ProgramFirstday" = 1
"ContractDetailFirstDay" = 7
how do you determine whether this is 6 day delay...

August 25, 2016 at 12:51 pm

#1897609
RE: Are the posted questions getting worse?

Luis Cazares (8/25/2016)
Are you serious? I think they're perfect. They're great to identify cheaters from people that actually know what they're talking about.
I couldn't get past the 3rd question, it's...

August 25, 2016 at 12:32 pm

#1897601
RE: CALCULATING DELAY SECONDS

When you are entering SQL code in a post, please surround it with code="sql" IFCodes to improve its display.

August 25, 2016 at 10:31 am

#1897556
RE: Create Unique identifier from text

Alvin Ramard (8/25/2016)
Phil, do we currently have a full moon? :w00t:
A very ordinary moon currently, it would seem 🙂

August 25, 2016 at 10:18 am

#1897543
RE: Create Unique identifier from text

What have you tried so far?
What problems did you encounter?

August 25, 2016 at 9:39 am

#1897509
RE: Microsoft access database engine cannot open or write file

komal145 (8/25/2016)
Please see the pacakge hierachy. Let me know if i can cahnge anything with copying? As the move file should be locked but copying of file should work fine....

August 25, 2016 at 9:35 am

#1897507
RE: which service account? UNC path

inevercheckthis2002 (8/25/2016)
The goal is to have an SSIS package run from a SQL Server Agent job access an Excel spreadsheet over a UNC path.
Which credential will need permission to read...

August 25, 2016 at 6:20 am

#1897449
RE: Microsoft access database engine cannot open or write file

komal145 (8/24/2016)
Mine are xlsb files and they require retain same connection , as i am trying to load 2 xlsb files in foreach loop ...each file load process has...

August 24, 2016 at 5:09 pm

#1897353
RE: Microsoft access database engine cannot open or write file

komal145 (8/24/2016)
It runs fine with all the SQL agent owner when i diable to task which copies the file to a archive folder. This can be done in Dev...

August 24, 2016 at 4:36 pm

#1897351
RE: Microsoft access database engine cannot open or write file

komal145 (8/24/2016)
I am trying to load the excel file from variable in for each loop and load the file to a table. It runs fine in the BIDS / VS...

August 24, 2016 at 2:02 pm

#1897318
RE: Job to Back Up DB structures only

This way I can rebuild the DB from the .sql file and reprocess the data in case of disaster recovery.
This sounds very much like the long-winded equivalent of restoring a...

August 24, 2016 at 10:18 am

#1897246

Viewing 15 posts - 6,766 through 6,780 (of 13,877 total)