Thanks for the suggestion RB.

My source is a flat file that has one row that does not conform to the numeric requirement of the database field. I'll keep working on a solution. Thanks...

bt, this part worked perfectly. Thanks for helping me to get this set up!

On the second part, it has been a while since I've used SSIS and I never...

I tried to make a new derived column for the zip codes using this:

(ISNUMERIC([ZIP]) = 1 ? [ZIP]: "")

but it did not work.

Thank you for responding bt. This is just what I was looking for. When can I put it in SSIS to take effect? I have a data...

I've compared the output of the querys and for some reason, sometimes the query just gives up part way through. If I keep executing the query, it will eventually give...

Hi Henrico, thanks for responding.

It does work without the variable but I still get the same issue. 68 rows returned sometimes and 38 rows returned other times.

Henrico Bekker (6/8/2010)

---

no need...

Hi WayneS,

Thanks for responding. The changes that you suggested also worked but as before, I get different results each time I run this query. The first time, 68...

Thanks for all the replies. I'll try these solutions.

I also found that choosing tasks --> generate scripts and choosing the option to script data, keys, constraints, etc allows me...

Seperate development and production domains.

The problem was in all my trial and error, I had defined variables 2 and 3 twice. For some reason the msgbox was reading the second ones but the email...

Thanks for responding.

The challenge is that I can not connect from one server to the other.

Right now I use a two step process to export the data to a flat...

Thanks for that divyanth,

The error output change allowed the success.

Very exciting!

divyanth (5/14/2010)

---

Definitely, the string value should be inserted between double quotes and try this

(DT_DBDATE)(DT_STR,10,1252)(YearE == "00" ? "" : ((DT_STR,4,1252)YearE...

Wayne,

Thanks for responding. Your suggestions were correct because now SSIS allows me to hit ok to save the expression whereas before it did not.

Unfortunately, it still chokes when it...

I came up with this as an if but it isn't working right now.

([YearE]== '00' ? NULL :(DT_DATE)

...