Sean Lange (9/26/2016)

---

The absolute best solution would be stop naming tables _2008 etc. Add in a transaction year or similar as a column in the table and this is no...

ah0996 (9/26/2016)

---

Hi,

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....

dallas13 (9/26/2016)

---

Hello,

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...

Please describe what you mean by this.

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...

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...

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.

lcarrethers (9/23/2016)

---

We have a job that sends out a pdf once a week and every now and then we get this error message. I have tried to rerun the...

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';

jwiesman (9/22/2016)

---

Phil,

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...

jwiesman (9/22/2016)

---

Phil,

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...

You might find this helpful.

Anyone in the mood for a quick code tidy-up?

I see no text file.

+1