Smendle

Forum Replies Created

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

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
RE: split string by number of characters

djj (10/3/2016)
I used the link Luis presented and have it working. The size of each string varies greatly but the needed split is around 2000 characters.
So, I modified to...

October 12, 2016 at 9:22 am

#1906155
RE: SQL Server Call/ SSIS to REST API Web Service (Workday) - (Not Weather API)

venkyzrocks (9/26/2016)
Hi All,
I'm looking to call a web service (REST API/SOAP) doesn't matter through SSIS/Stored procedure. SSIS does have a web service call but it only accepts simple WSDL files...

September 28, 2016 at 7:01 am

#1903618
RE: How do I initialise a sql variable to 0 in stored-procedure ?

thank you both for the clarification....

September 24, 2016 at 8:39 am

#1902968

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