Thanks Guys...for your feed back. I have requested data entry user to cleanup excel since they are entering time and string togather. Now, they will enter only time so I...

Sorry,, I wasnt very clear when i post the example.

Here is the excel example

ID, ApproximatTimeRun, Qnty, Amount

1, 10:00 AM Daily, 3, $20

2, 06:00 PM Daily, 4, $30

3, 02:00 AM...

The column is in Excel Spreadsheet and when I checked on by doing Format in excel it want give me exact the format type but if i convert to just...

Guys..My problem is little different and I am new to SSIS too.

I have excel file which I upload to my database via SSIS where i split the data for...

Andras...this is great. I appriciated for point me in right direction. Just got learn something new...

Thanks a Billion......:-P

Above solution is great but how about this... I am in middle of project and get stuck on how to add incremental..

Here is the detail.

MyTable:

Customer_Id, CustomerLineNo, CustomerName,

12, null,...

Bob -Thanks a million...it work...Awsome...I appriciated....The only thing i have to do is i have to tiwic a query littlebit and one single change and it worked perfectly...thanks a lot...

Thanx guys. Done it... It works

Thank You