Thanks all

Thank you for your tips.

I will check into it.

Thanks all, I read the article, and changes the default schema to dbo for the login.

My question is now when a login created what is its default schema, I...

Do you know if any service pack of SQL 2008 fix these ?

Thanks

Thanks, it works after I rtrim the table column,

Also see this article may be helpful.

http://consultingblogs.emc.com/kristianwedberg/archive/2006/02/22/2955.aspx

Thanks, I think I identified the column is a char(30) named allocationType.

It caused the mistmatch, although the data look exactly the same from input and table.

The value is not a...

Thank you, I got it.

sunilreddy (1/23/2012)

---

In the Master package, set 'Disable EventHandlers' property to 'True'. so it stops tracking the logs in Master Package.Now you'll get only the logs of child packages as you...

This is not working,

I want to return Org, orgUnitID that has the max count of orgUnitID

andersg98 (1/13/2012)

---

isn't it more efficient to process the load all in the SSIS pipeline?

if you are just calling stored procedures from the SSIS package then you might as...

In the derived columns I also try this:

TRIM(PerNo) == "" || ISNULL(PerNo) ? 0 : (DT_I4)TRIM(PerNo)

it converts OK, and I see the data viewer has 0 values, why when it...

I tried it to convert it to null in a derived columns, it converted successfully,

but when inserting into database, it gives error: the data balue cannot be converted fro...

Evil Kraig F (1/11/2012)

---

sqlfriends (1/11/2012)

---

Thanks, so I would like confirm: only if there are Null character in the flat file , the return nulls will work, correct?

My thought...

Thanks, so I would like confirm: only if there are Null character in the flat file , the return nulls will work, correct?

My thought ealrier is blank...

Wow, that is very good article that helps me about handling null values.

But I need to spend some time to study it. and try on my database.

I may check back.

Thanks...