Thanks dude...I will read this

Koen Verbeeck (8/23/2012)

---

When you use transactions in SSIS, MSDTC is used (Distributed Transaction Coordinator). Maybe you don't have permissions on that?

Or maybe the SQL Server instance doesn't allow distributed transactions?

An...

Hey, dude, that helps. Thanks a lot.

Same result....Actually not only one excel file, all excel stoped on 255th row....And i tried them under Windows Xp os, then everything is good....Seems only doesnt' work windows server 2003....

Phil...

Thank you so much, man! I will try to write a query based on this. I will let you know if this works or not.

Thanks a lot for your help. In my case, I just need first 5 rows to pivot to columns. I will try your query script. I'm not quite familiar about...

SQL King (2/19/2008)

---

By reading your replies, I can understand your problems. Here is two way to get out of this problem.

1. Do as what I have told you before.(OLE DB...

SQL King (2/19/2008)

---

How big is your database. I am assuming you are doing this just to do some development/testing for yourself? If that is the case, just an OLE db...

Thanks a lot for reply. The source database is a remote database, and I only have database access. I couldn't get any backup files from that database server. I am...

Thank you very much. Is it possible that I can do this peroidly? Like everyday 2:am in the morning? Thanks a lot.

Thanks a lot for the information. Could you give me some more details or reference paper about that ? I set up serveral linked server before, but seems for now...