Thanks!

It seems our ETL Server is not on UTC time. Some deployed packages seem to be loading UTC and some Local after the morning ETL loads. Our DBA suspects its...

Sorry Phil.

My questions are:

1. Why would I get Load_Dte as local time when run from Desktop and UTC when run from server?
2. How can I ensure that Load_Dte fed by...

I think you nailed it Drew! Thank you for both references.

Thanks Drew! I'll have a look.

Spoke too soon.
Looking at the result set:

Row 11 should have 'Y' since previous Temp was 'VENT'.
and
Row 22 should have 'Y' since previous Temp was 'VENT'.

Jason! This worked perfectly! Thanks so much!

Interesting. Server time is UTC +1. Just noticed that. Africa?

Jack Corbett (5/8/2015)

---

Vertigo44 (5/7/2015)

---

ROW,NOTE_ID, NOTE_SERIAL_NUM, NOTE_STATUS

1, 366834292, 333040947, 8

2, 366834292, 333054601, 2

3, 367096281, 333293527, 2

4, 367096281, 333282008, 8

5, 368005352, 111111111, 2

6, 369005341, 111111100, 8

I need from this subquery...

pietlinden (5/7/2015)

---

Oh, c'mon... you've been around here long enough to know how to post data. Here's the table/inserts:

CREATE TABLE t1 (

n INT PRIMARY KEY,

note_ID INT,

Note_Serial_Num INT,

NoteStatus TINYINT);

INSERT INTO t1...

5 was just a made up number. I actually need all columns up until the last two in the after file. Thanks for your help on this!

Hi Jeff,

See attached. I only included the file headers in the file as I think that's all your really need to see what is taking place. If the FF connection...

Yes, I just stepped into this environment not too long ago but apparently this has been happening with the vendor for over 2 years now. Its been brought up but...

Oh yes that might have been helpful!

So we have 5 columns that we will always want from that file. That is fixed. However as you know if the flat file...

Sorry Phil. No.

I found a possible solution to dynamic flat file columns using...

http://ssisdfs.codeplex.com/

and a script task component. I am going to try to implement it and see if...

I would like to get started with these...

DML:

http://www.sqlservercentral.com/stairway/75773/

Advanced T-SQL:

http://www.sqlservercentral.com/stairway/104497/

The only thing I could not determine is which version of SQL Server Express I should install and...