Schadenfreude-Mei (5/24/2012)

---

Robert Davis (5/23/2012)

---

I laughed very hard at the replies here, but if we're posting serious answers now, I think the OP should start with this post by Paul Randal:...

GilaMonster (5/23/2012)

---

dwain.c (5/22/2012)

---

Stefan Krzywicki (5/22/2012)

---

Many should format it all at once,...

Here you go: all possible 3-bit values in one simple query:

SELECT '000'

UNION

SELECT '001'

UNION

SELECT '010'

UNION

SELECT '011'

UNION

SELECT '100'

UNION

SELECT '101'

UNION

SELECT '110'

UNION

SELECT '111';

khorkh888 (5/23/2012)

---

Dear All,

Finally I make it also !!. The initial problem is due to the long sting. I just make a unicode Text. Now everthing is...

Gianluca Sartori (5/22/2012)

---

OK, since I'm back to posting on The Thread, I think I'll share this one with you.

Lately I've been working a lot as a SQL Server trainer and...

Very nice question, definately learned something.

Got it wrong, as I say "begin transaction" I immediately thought "rollback everything". Apparently not 🙂

Write a SQL query to the Excel file instead of just selecting it in the dropdown menu.

The sheet represents the table in the FROM clause of the SELECT query. There...

I have no idea.

Well, these were more actual questions than the first ones 😀

And he even put some thought in it. (Incorrectly, but it's the gestion that matters).

Or Bing!

(or even Yahoo if you must)

Do the links give any problems when you try to read the sheet with SSIS?

Hidden rows/columns shouldn't give a problem.

Error handling:

Debugging and Error Handling with SSIS Packages

Do you bump into a specific error?

Is the Access database really located in the "C:\test\" folder? (or whatever location it is in reality)

I don't know a lot about log shipping, but I can't see the future either...

http://www.sqlservercentral.com/Forums/Topic1303857-391-1.aspx

Don't sort in the dataflow but use ORDER BY in your queries.

You're welcome.

Sort Data for the Merge and Merge Join Transformations