For the moment there's only the Evaluation Edition.

(Or the Developer's edition if you have a MSDN subscription)

The official launch of SQL Server is April 1st 2012, so you have to...

What makes you think SSIS has a memory leak?

No special connection managers or providers? No script tasks or something like that?

Has anything changed on the server?

What does the package do? What are the tasks/components/connection managers used?

BIDS itself is 32-bit, so that might pose a problem.

The Run64BitRuntime property is only used during runtime.

More info:

64 bit Considerations for Integration Services

I don't really use the filesystem, as I like the pro's about SQL Server storage:

* packages are secured by SQL Server

* when MSDB is included in the backup policy, SSIS...

Please do not crosspost. It wastes people's time and fragments replies.

Original topic with replies can be found here:

http://www.sqlservercentral.com/Forums/Topic1272434-391-1.aspx

I don't think the warning failed your package, but the fact that you load duplicates in your lookup can easily be avoided by writing a decent query.

Regarding the memory: either...

SSIS doesn't have metadata about OLE DB sources, so the only way you can get the sourcename is to populate a variable yourself.

Here you can find an explanation and a possible solution:

Claim DB Space After Deleting Records in Table - Reduce DB Space

And here you find some resources why you shouldn't...

What are your sources?

Nice one to start the week, thanks.

GSquared (3/23/2012)

---

Reminds me indirectly of one of my three bosses at a job a couple of years ago. He ended up compulsively disagreeing with me. A couple of...

<sarcasm>

Apparently some site where you can find forums where people will give you free advice instead of doing anything yourself...

<\sarcasm>

(boy, I'm bitter. It's Friday afternoon...

Gianluca Sartori (3/23/2012)

---

Koen Verbeeck (3/23/2012)

---

Brandie Tarvin (3/23/2012)

---

anthony.green (3/23/2012)

---

sorry, i think the sarcasum of the post was lost, few posts this morning which where so very very simple which could of...