KoldCoffee (5/17/2013)

---

opc.three.

This worked and it brings me a great deal of relief. Thank you.

I attempted to add the TypeGuessRows property to the excel source connection string hoping to...

Looks like a migration (without upgrade) is supported by taking the database with you:

http://technet.microsoft.com/en-us/library/ms143724(v=sql.100).aspx

Ok. Let us know how it goes.

As an aside, this is a discussion site, not just a Q&A site, so try to be patient with some tangents once in a...

So only changing the metadata on the Excel source with the Advanced Editor did not work for me this time. I had to go full boar and ended up altering...

Weird. Link works for me, still.

Kold Koffee. We're volunteers so the lack of a response within a few minutes ir even hours just means we may have had to do...

Post a sample of your Excel file, attached to this thread.

Doubtful on #3. The RDL format will be different too so you're looking at an RS Reports migration here too.

The engins upgrade itself is pretty safe. Start with running Upgrade...

You don't need to modify the registry, in fact I would discourage it so let's see if we can avoid it. If you modify the outputs for the Excel Source...

Check the outputs on your Excel Source Component. Hint: Solution III in the article I posted talks about it, as did David Webb earlier on this thread.

The whole post is a good read, but section "The solution part III" pertains to your issue specifically:

http://blogs.lessthandot.com/index.php/DataMgmt/ssis-1/what-s-the-deal-with

chandan_jha18 (5/16/2013)

---

opc.three (5/16/2013)

---

chandan_jha18 (5/16/2013)

---

As you posted, you have already fixed SQL Server and given it a range between which it an fly up or down.

I would suggest to collect some...

Robin35 (5/16/2013)

---

One application job has run from 3:30 AM to 5 AM today morning...we got the alert around...4:07 AM.

Not sure if its the reason...

Do i need to change the memory...

Are you on an Edition of SQL Server that has SQL Agent? In other words not SQL Express Edition?

If so, I would recommend you setup a SQL Agent Job to...

chandan_jha18 (5/16/2013)

---

As you posted, you have already fixed SQL Server and given it a range between which it an fly up or down.

I would suggest to collect some 'Available Memory'...