Eirikur Eiriksson (11/6/2014)

---

occasional sql (11/6/2014)

---

I want to be able to return the rows from a table that have been updated since a specific time. My query returns results in less...

Easy one, thanks.

Jeff Moden (11/6/2014)

---

Greg Edwards-268690 (11/6/2014)

---

Gazareth (11/6/2014)

---

Ed Wagner (11/4/2014)

---

I don't want to condemn...

Phil Parkin (11/6/2014)

---

Ells (11/6/2014)

---

If they are 30 different structured files going to 20 different structured tables then as Phil said there is no magic wand for this in SSIS.

However there...

The problem is that only the wizard has this issue, but SSIS...

TomThomson (11/6/2014)

---

Good question.

It raises an issue about the quality of this wizard: why on earth doesn't it read metadata for the target table and set lengths accordingly? It...

Also provide table DDL and the CREATE INDEX statement and the SELECT query as well.

Also, which version of Excel are you using? 32-bit or 64-bit?

Why would you restart it?

I didn't notice at first why the import would fail. After all, 150 characters fit perfectly in a 200 character-wide column.

Then I remember the default for the flat file connection...

Adam Sandler (11/5/2014)

---

Thanks - I would need the configuration manager to get the web address for this wouldn't I.

Would BIDS be the way to go ? If they have installed...

The installation of Office (be it 32-bit or 64-bit) has...

Can you explain a bit more what you are trying to achieve?

Btw, your sample data has different IDs and all the other columns are the same.

ALTER LOGIN [Domain\username] DISABLE;

Create a Login

Red means that there is an error (or at least should be).

Check the output window...