if you are doing this in Reporing services then i would be more inclined to do this in the report/dataset rather than changes,

you could write an expression either in the...

there are a number of things that you can do to speed up an SSIS package.

there is a great document here that outlines some of the main ones;

http://sqlcat.com/top10lists/archive/2008/10/01/top-10-sql-server-integration-services-best-practices.aspx

basically...

this sounds like a language/region issue not a collation issue.

check to see if these settings are the same on your new server as the old one

With a table that large, do you have any partitioning on it?

are the tables the same for each company?

rfr.ferrari (5/31/2011)

---

steveb. (5/31/2011)

---

Ninja's_RGR'us (5/31/2011)

---

Does it...

Sean Lange (5/31/2011)

---

That may be correct but the question still remains...why would you need to open a text file with 13M rows. It would take weeks just to scroll to...

Ninja's_RGR'us (5/31/2011)

---

Does it have a magic...

Trunacate only supports the three part naming of tables according to BOL.

you could try using, delete or run the command directly against the server

try using textmate to open it.

but as other have said, ...

Syed Jahanzaib Bin hassan (5/30/2011)

---

OS or Network Level rights depends on the SQL Server Service Account ,so you must have an access rights on the particular folder or drive on...

what account in SQL server running under?

it should be this account that needs access to the disk

Microsoft should have it.

are you certain that your OLE DB connection is using the correct server and database?

What i would do would be to create a simple SQL script task with hardcoded values

UPDATE...

you need to install the Excel driver on your machine