Did you set the Run64BitRuntime property of the project to false?

An off-topic question: why don't you load the Excel directly in the database, instead of dumping it in a flat file first?

I don't have a quick answer for you - query compiling is not really my strong suit - but I can recommend you this books you can download for free...

Wouldn't this be mentioned in the documentation material of double-take?

You can download it from their site.

I already got it from the first two replies, which...

For some reason, the += acts as a = when you use a function...

vijaymadh (2/9/2012)

---

Because that is not required, I know that the problem is in where statemenet, we are using too many optional parameters and they are causing problem. We have fixed...

shahid_jambagi (2/8/2012)

---

goto start --> click select SQL server management studio

log windows is pop up

Server type is by default

server name is by default...

Drew Gillson (2/8/2012)

---

I just experienced this issue, and although I was not able to get SSIS to talk to an Excel file directly on my 64-bit Windows Server OS (ACE...

That setting specifies the maximum amount.

It does not garantuee that SQL Server will effictively take that amount of RAM.

Try a combination with the minimum amount of memory.

So you post only a part of the query, no details about the server itself and what is running on that server, no table definitions, no information on indexes, no...

Linda Robinson (2/8/2012)

---

This time when I opened SSMS, sysdtslog90 is there! I really did try Refresh.

If I click on the package and select Execute Package logging works. It doesn't,...

Linda Robinson (2/8/2012)

---

I've made some progress. 🙂 I ran the package in debug mode and it created the sysdtslog90 table. It does not display in Management Studio, but I can...

No problem, glad to help.

I hope everything goes smoothly from now on.

That really is straight forward 😀