In the Edition Upgrade wizard, can you select radio button to choose a free edition?

Upgrade to...

Do the tables have some sort of ID (like an identity)?

If they do, you could write a delete statement using a modulo operator that keeps only 1/5th of the rows...

OK. If you put a data viewer right before you write to the destination, does the data look normal?

When the flat file is created, can you double check the encoding...

What is the encoding of the flat file? ANSI, UTF-8 or unicode?...

kbnyny (4/16/2014)

---

Sorry Brandie, I did not make myself clear enough. I can change the data type but the problem is when I do change it to anything beside Unicode...

kbnyny (4/16/2014)

---

I have created a SSIS package to generate an XML output file. The package run without any errors. The problem I am having is when I go to open...

Since profiler is deprecated and to be fully replaced with Extended Events, you can be...

The package itself will not take that much space.

It all depends on what the ssis package is doing exactly.

Without more info, we're just guessing here.

Is it possible tempdb used a lot of space? (is tempdb stored on the c drive?)

How are you sure the space issue is linked to the job?

What does the job do?

Are your databases stored on the C: drive?

Easy one, thanks!

gbritton1 (4/15/2014)

---

Actually its not so much that but the difference between an Execute SQL...

Interesting question, thanks.

shafirmubarak (4/15/2014)

---

Thanks for your quick response.

I would like to import as it is. I dont want to ignore the rows which has null GUID.

It's acutally child records which may sometimes...

What is "User" in your expression?

Regarding the empty GUIDS, what is the exact error...