Adding to my confusion is the fact that changing the package in VS and importing it to SSMS/SSIS does not seem to guarantee the correct version will execute with SQL...

I'm still not sure why this is happening (other dates in the table are being extracted without any problem), however I'll outline here what I did to fix it in...

I live in a dead zone: last year I drove 2 hours to El Paso for a SQL Saturday, in September I drove 600 miles to Denver for theirs. I'm...

I really appreciate all the work that presenters put into their presentations. I hope that someday I live somewhere where I can take advantage of events like SQL Saturday, etc....

Thank You Mike, that was it!

The other have told you how to parse it. That's good because I just want to rant a bit and I know none of it...

I have found that this XML.Value code will get me the first 4 of the 6 pieces of data I need:

DECLARE @x xml

SET @x = '<datetime1>2014-08-14T04:00:00</datetime1><float1>2.000000000000000e+000</float1><float2>4.190000000000000e+002</float2><float3>1.600000000000000e+001</float3><float4>8.110000000000000e+002</float4><sql_variant1 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:sqltypes="http://schemas.microsoft.com/sqlserver/2004/sqltypes" xsi:type="sqltypes:float">1.800000000000000e+001</sql_variant1><sql_variant2 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"...

For about 10 years earlier in my career, I worked for a consulting company in the Philadelphia area. We had close to 100 staff members, very few of whom knew...

I have used the window function ROW_NUMBER...

That's a reasonable question, but it might be instructive to pharse it a little differently: If you are looking to be a programmer, do you need education or do you...

The problem was resolved. This database is on a DR server, which was the only one that had not been restarted. Until now. Data transfers were halted, DR...

The remote login = the job owner of both jobs.

Both queries ran?!

Yes, I can look at error logs. One error I see is Logon Error:18456 Severity:14 State:11.

When I queried sys.dm_os_ring_buffers I see 0x6FD and 0x139F. I understand the...

Part Time. I returned to the world of IT after a very long hiatus. Working part time during whatever hours I see fit has allowed me to balance work and...

Thanks!

Stewart "Arturius" Campbell (4/22/2015)

---

Good question, thanks Mark

alicesql (4/22/2015)

---

I need some help understanding this. When a table is created, the structure is defined. But no data exists in the table until...