Not sure what you mean. There's no equivalent 'empty integer' - just either values or NULLs.

+1

Does the c:\SSIS folder exist on the server?

azdeji (9/11/2013)

---

Below is the sample XML code which produces empty strings but to ssis they are null values -

<from></from>

And I try adding default values but they still showed...

azdeji (9/11/2013)

---

For the string data type, the XML source adapter converts incoming empty (zero length) strings to NULL. This means there's no way tell if the fields was present with...

I can see why they would embed the selection SQL at demos and presentations - keeps everything in one place & helps things flow more easily.

But in all the places...

You could use a 'numbers' table to do this (1,2,3,4,5,6,7,8,9,...).

Join to...

Koen Verbeeck (9/5/2013)

---

Tim Mitchell (9/5/2013)

---

You won't find that information in the package itself. If you have logging set up on the package, the logging information will give you that...

That error message does not make any sense to me - are you sure that you have copied it correctly?

Mr. Kapsicum (9/6/2013)

---

Thanks for acknowledging my problem.

In a nutshell, i want a Script for my script task that delete all files...

Sqlraider (9/6/2013)

---

I know very little about SSIS, so bear with me.

I have a SSIS package that inserts records into a 'staging' table from a CSV file (loading one CSV file...

I'll give the same advice I give all Excel importers:

Use CSV files if you can instead - you will find that it all works better.

Restarting the SSIS server would definitely do the job, if everything is configured correctly.

So there must be something in there which is not quite right ...

sqlfriends (9/4/2013)

---

You are right, although I have some reason but I think maybe I should keep it consistent.

A derived question, U use dt_numeric precision 38, scale 1, when I export...

dchapman 44037 (9/3/2013)

---

I manually run reports now in the following manner:

Run two different sql scripts that pull data from yesterdays date, I right click on results and save results as...

I think you've cracked it. False and "False" are quite different things - in the eyes of SSIS at least.