This is the important part:

"The Microsoft Office Access database engine cannot open or write to the file ''. It is already opened exclusively by another user, or you need permission...

Hi,

Can you try first a shorter export, like 10 rows. Does it work ?

It looks like the package you are trying to execute is in specific user sub-folder and the "NETWORK SERVICE" account doesn't have permissions to this folder. Try moving the package...

SSIS.COM (10/12/2010)

---

I am trying to import excel files into SQL Server 2008. But I get the following error.

"The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with...

Mike-1076638 (10/10/2010)

---

10gb file can be sorted and you do not have to buy new hardware

Microsoft is promoting the idea that doing everything the memory is great. It does definitely...

If you can use third-party solutions, check the commercial CozyRoc Data Flow Task Plus. It can modify the SSIS data flow metadata at runtime, dynamically including / excluding columns. You...

pwalter83 (10/5/2010)

---

Hello Friends,

I want to run the 64 bit SSIS package from the SQL job agent. I understand I need to select 'Operating System (CmdExec)' as the Job 'Type'. ...

The type of parsing you are looking for is very complicated and not trivial. If you can use third-party solutions, check the commercial CozyRoc Address Parse component. It provides exactly...

jani_shirish (9/21/2010)

---

Thanks For your help i have achive this

I have one PC with sql 2000 and is Running fine on that

Thanks A lot

I have question

I in...

You have...

When you open ActiveX Script Task dialog and go to the place where you entered the script, there is a property right under...

What did...

What is the exact error message?

I have...

You have to determine which function is not found. Start commenting code until you find which is the failing piece.