Phil Parkin

Forum Replies Created

Viewing 15 posts - 3,871 through 3,885 (of 13,877 total)

RE: Need a distinct result set

oradbguru - Thursday, November 15, 2018 8:34 AM
Hello, I have the below data stored in a temp table:
I need to...

November 15, 2018 at 8:43 am

#2013684
RE: Recreating SSISDB

tmmutsetse - Thursday, November 15, 2018 6:13 AM
Thank you,the guy didn't know about all that and he just restored without encrytption keys.I...

November 15, 2018 at 6:40 am

#2013642
RE: Recreating SSISDB

tmmutsetse - Thursday, November 15, 2018 3:35 AM
Hi
Is it possible to drop and recreate SSISDB database.My collegue restored SSISDB to a new...

November 15, 2018 at 5:31 am

#2013626
RE: Script task as Source in data flow

VoldemarG - Wednesday, November 14, 2018 8:19 AM
in what case/situation may i want to use Scripting task as source in data flow?
Why/when...

November 14, 2018 at 9:01 am

#2013482
RE: Select Into as Number and Date rather than Text

An example. Replace this
'07-11-18'
with this
CAST('20181107' as DATE)
(Using YYYYMMDD as your date format removes any D/M/Y M/D/Y ambiguity and is an ISO standard format.)

November 14, 2018 at 5:09 am

#2013413
RE: SQL Server Execute Permission for SSRS login

srajeevan1989 - Tuesday, November 13, 2018 8:37 AM
Hi,
Recently when the application team did a SSRS Report deployment and the report was not...

November 13, 2018 at 8:50 am

#2013334
RE: Replacing string in text file with another string

Jeff Moden - Tuesday, November 13, 2018 7:37 AM
If you have a huge file, what does the System.IO.File.ReadAllText do to memory...

November 13, 2018 at 8:12 am

#2013327
RE: Replacing string in text file with another string

If the files are not huge (ie, they will confortably fit into RAM), you can use the technique here.

November 12, 2018 at 2:06 pm

#2013271
RE: Replacing string in text file with another string

VoldemarG - Monday, November 12, 2018 10:34 AM
I need to replace all occurrences of 'ABCD' in .txt file with 'EFGH'.
Is it possible...

November 12, 2018 at 10:38 am

#2013244
RE: SSIS security issue?

Rick-153145 - Friday, November 9, 2018 10:17 AM
Hi,
The setup:
SQL 2014 Enterprise Standalone install on node of cluster (BizTalk etc)
SQL 2014 Running SSIS...

November 9, 2018 at 11:39 am

#2013003
RE: SSIS Toolbox Different on 2 Servers

homebrew01 - Thursday, November 8, 2018 1:39 PM
CozyRoc wouldn't need to reside on the server running the SSIS package ?
Cozyroc needs to...

November 9, 2018 at 5:34 am

#2012943
RE: SSIS Toolbox Different on 2 Servers

homebrew01 - Thursday, November 8, 2018 9:48 AM
Phil Parkin - Wednesday, November 7, 2018 8:22 AM

November 8, 2018 at 10:43 am

#2012879
RE: CozyRoc SFTP

tmmutsetse - Thursday, November 8, 2018 3:38 AM
Hi Experts,
I want to pull files from a remote site to my local folder.I downloaded...

November 8, 2018 at 5:16 am

#2012795
RE: T-SQL Decommenter Part I

An interesting approach, with quite a lot of time invested in it!
I come at this from a different angle. All of my source code is contained in several...

November 8, 2018 at 5:11 am

#2012793
RE: Audit Log for changes to SSAS cubes

JustJay - Wednesday, November 7, 2018 1:20 PM
Our auditors want to see a yearly list of everything that has changes about how...

November 7, 2018 at 2:47 pm

#2012762

Viewing 15 posts - 3,871 through 3,885 (of 13,877 total)