Smendle

Forum Replies Created

Viewing 15 posts - 16 through 30 (of 156 total)

RE: SSIS EXPRESSION HELP NEEDED WITH SYNTAX - HOW TO REPLACE A VALUE IN A STRING

mw_sql_developer - Wednesday, September 5, 2018 11:31 AM
Team:
Please look at the attached. So the file name ( in the expression output ) ...

September 5, 2018 at 11:45 am

#2004559
RE: SQL Migration

Sue_H - Tuesday, September 4, 2018 2:11 PM
Andrew.weckermann - Friday, August 31, 2018 3:08 AM

September 5, 2018 at 7:02 am

#2004490
RE: Connection Manager in SSIS 2017 Package NOT Saving the Password

Sean Perkins - Thursday, August 30, 2018 3:50 PM
We're using Visual Studio 15.7.2 and using SSIS on SQL 2017 (14.0.3029.16).
We built a...

September 4, 2018 at 2:40 pm

#2004436
RE: SSIS Package run from Visual Studio but fails from SQL Server Agent with the Error: Exception has been thrown by the target of an Invocation.

kashyap4007 - Tuesday, September 4, 2018 12:22 PM
Srikanth,
Permission is not the issue because I am able to run other packages and I...

September 4, 2018 at 12:37 pm

#2004420
RE: SSIS Package run from Visual Studio but fails from SQL Server Agent with the Error: Exception has been thrown by the target of an Invocation.

kashyap4007 - Tuesday, September 4, 2018 11:07 AM
HI,
I have an SSIS Package which goes to a website using http connection and gets...

September 4, 2018 at 12:05 pm

#2004406
RE: Backups - AlwaysON Availabilty Groups

aledavsanort - Tuesday, January 23, 2018 10:22 AM
Perry Whittle - Tuesday, January 23, 2018 8:37 AM

February 19, 2018 at 1:12 pm

#1980335
RE: Column value into number of rows

Jason A. Long - Tuesday, June 20, 2017 10:38 PM
Smendle - Tuesday, June 20, 2017 10:08 PM

June 20, 2017 at 11:05 pm

#1947489
RE: Column value into number of rows

Jason A. Long - Tuesday, June 20, 2017 5:37 PM
Smendle - Tuesday, June 20, 2017 1:20 PM

June 20, 2017 at 10:08 pm

#1947486
RE: Column value into number of rows

carlos.rincon - Friday, June 16, 2017 5:44 AM
Hi everyone 🙂
I'm having this issue and any help will be really appreciated.
I'm simplifying the...

June 20, 2017 at 1:20 pm

#1947459
RE: Need Suggestions on Best way to Query Data

+x
bmg002 - Monday, June 12, 2017 2:21 PM
Based on your description (I didn't look at your excel files), what you are asking for...

June 20, 2017 at 12:31 pm

#1947443
RE: How does this code convert records to a single row?

Bill Talada - Monday, June 19, 2017 10:00 AM
It is a horrible technique but gets the job done. It loops through each...

June 20, 2017 at 10:54 am

#1947424
RE: How do you work with multiple developers on same DB

mark 4643 (10/19/2016)
Hi All
Our dev team is growing. We use red-gate toolbox, so we have schema compare, data compare and source control. for the past few years we have used...

October 24, 2016 at 9:39 am

#1908408
RE: Split String On Delimiter

Luis is a master at showing set based solutions and if you plan on using SQL for any length of time, I would understand why those solutions are preferable over...

October 14, 2016 at 7:14 am

#1906566
RE: Using SP in UDF

Alaster07 (10/12/2016)
Correct me if I am wrong, but I am unable to use NEWID() and RAND() functions in UDFs.
You are correct. My Apologies as penance I offer this as...

October 12, 2016 at 2:25 pm

#1906203
RE: Using SP in UDF

Alaster07 (10/12/2016)
I am trying to create a function that will generate a random datetime value. Due to being unable to use NEWID() and RAND() in UDFs, I created two...

October 12, 2016 at 1:33 pm

#1906195

Viewing 15 posts - 16 through 30 (of 156 total)