Viewing 15 posts - 6,646 through 6,660 (of 13,876 total)
Sean Lange (9/26/2016)
September 26, 2016 at 1:07 pm
ah0996 (9/26/2016)
I have C# script that reads last modified date of file. Script works perfectly fine while running manually from package. However, when I deploy the script/package to SQL job....
September 26, 2016 at 12:51 pm
dallas13 (9/26/2016)
I have so many excel files coming that I need to load to sql and create automated process.
I dont want to convert them to csv or txt file format...
September 26, 2016 at 10:30 am
24 by 7 logic
Please describe what you mean by this.
September 26, 2016 at 8:51 am
Well, you can at least connect to it from SSDT.
Choose Tools/SQL Server/New Query and then expand the 'local' node to select the connection you are interested in.
When I did this...
September 25, 2016 at 5:32 pm
OK, this is a start
You have a comma after the declaration of @nFY_ST_QUESTION_DTL_TABLE_ID. Should be a semicolon.
You have a mismatch between begins and ends.
Having an IF and then another IF...
September 23, 2016 at 11:19 am
Telling us that you are "getting errors" without telling is what the errors are is most unhelpful ... are we supposed to guess? Please post them.
September 23, 2016 at 10:49 am
lcarrethers (9/23/2016)
September 23, 2016 at 9:45 am
Something along these lines?
DECLARE @StartTime1 TIME = '17:41:00.0000000';
DECLARE @StartTime2 DATETIME = '2016-09-22 17:41:14.810';
if @StartTime1 = TimeFromParts(datepart(hh,@StartTime2),datepart(n,@starttime2),0,0,0)
select 'Times match'
else
select 'Times do not match';
September 22, 2016 at 6:23 pm
jwiesman (9/22/2016)
Hi.
First off, thank-you for helping.
Your 2nd to the last reply got truncated..... There was no link... it was just:
You might find...
September 22, 2016 at 5:02 pm
jwiesman (9/22/2016)
Your last comment confuses me.
I gave you my environment (Data Flow Task / OLE DB Source / SQL Command text)
I gave you the code I ran ( exec sp_paceused)
I...
September 22, 2016 at 1:36 pm
Anyone in the mood for a quick code tidy-up?
September 22, 2016 at 12:57 pm
nilknarf (9/22/2016)
sorry I meant to delete that once I added the txt file.
I see no text file.
September 22, 2016 at 12:54 pm
ScottPletcher (9/22/2016)
I view it differently, since I prefer a code-based solution to a gui-based solution.
+1
September 22, 2016 at 10:59 am
Viewing 15 posts - 6,646 through 6,660 (of 13,876 total)