Michael L John (1/6/2016)

---

Ed Wagner (1/6/2016)

---

Sean Lange (1/6/2016)

---

Ed Wagner (1/6/2016)

---

Brandie Tarvin (1/6/2016)

---

Sean Lange (1/6/2016)

---

Wow. I rarely have to deal with user issues but I was just on a phone call...

Alvin Ramard (1/6/2016)

---

Jeff Moden (1/6/2016)

---

Brandie Tarvin (1/6/2016)

---

djj (1/5/2016)

---

There all over the internet.:-P...

Sean Lange (1/6/2016)

---

Wow. I rarely have to deal with user issues but I was just on a phone call with one of our own people having an issue with our...

sql_only (1/6/2016)

---

Phil Parkin (1/6/2016)

---

sql_only (1/6/2016)

---

Yes you're right.

I have had to...

sql_only (1/6/2016)

---

Yes you're right.

I have had to settle with 2...

Hugo Kornelis (1/6/2016)

---

... in most scenarios.

If you have a database that has a very high amount of table allocations and deallocations, you can...

Might as well use (19,16) or (19,17) – same space occupied on disk (ref. here).

bpowers (1/5/2016)

---

Ok I have two separate data flow tasks setup and can manually fire them off to populate the flat file. How do I set this up to run the...

antonio_scp125 (1/5/2016)

---

SSCertifiable thanks for your response! You're right and I didn't explain very well the situation.

Every time that a record are insert in the table, the flag New_Player be equal...

Please bear in mind that I have no idea about your data. I do not know what your contracts are. I don't know what 'players'...

This construct

t.ticket_date BETWEEN @SearchFromTicketDate AND @SearchToTicketDate + ' 23:59:59:997')

Should be written like this, to completely avoid any problems with fractions:

t.ticket_date >= @SearchFromTicketDate AND t.ticket_date < (@SearchToTicketDate + 1 day))

What is your connection string?

antonio_scp125 (1/5/2016)

---

In a Data Mart I have a table with information about Players (Dimension Player). And It have the following attributes:

•Name (nvarchar(250))

•Dt_Contract (date)

•New_Player (int)

•DT_Execution (datetime)

The New_Player is a...

bpowers (1/5/2016)

---

We received verification that the data can be submitted with all the Header data then the Detail data, as such:

Header 06721

Header 05482

Header 04263

Detail 06721

Detail 05482

Detail 05482

Detail 04263

Etc...

Not sure if...

You could try using FINDSTRING() instead.

FINDSTRING(@[$Package::StateExcludeNames], [State], 1) == 0

where [State] is the data column and

$Package::StateExcludeNames is a...