Thank you very much for the replies,and i thought i gave reply for this ,the real problem is with my data ..

Most of the date fields have the dates like:...

I found it ,The document titled “Remove seconds from datetime SQL“ gave everything i need:

if anyone having the same issue this is the syntax:

SELECT Cast(Convert(varchar, GetDate(),105) as datetime)

Thank you

I got it by creating a stored procedure for the script and ran it in SSMS.

Anyways,my other question still remains which is how can i only get '2010-08-11' for the...

I wrote this to start the job at particular day of the month.i want the getdate() to be just '2010-08-11' with out the minutes and milli seconds .i couldn't do...

looks like i don't have to convert a string into datetime format while inserting the rows to another table,sql server will automatically do it.

but i have some empty string fields...

the only difference i can see in the syntax is ' '

but i have tried and got this:

The conversion of a char data type to a datetime data type resulted...

This is the error i got when excel is the source:

There was an error with output column "comments" (121) on output "OLE DB Source Output" (37). The column status returned...

how can i replace when i am using excel as import,so i have ignored the failure which ignored 2 rows.

can you tell me how i should replace...

I got an error trying to stop the windows service so i disabled it.

But when i make any change in BIDS package especially Source which is from an excel it...

searchfilterhost.exe (local service) is taking around 300,000 to 500,000 k memory .and devenv.exe which is BIDS is taking 26,000k when i am not making changes to BIDS ,but when i...

Thank you.

Then what exactly is causing the delay to even create a package in BIDS 2005 ,i am seeing all the delayed notifications from Microsoft(like Microsoft is busy and waiting...

Thank you ,i will try that.

Forgot to mention this,

I have sql server 2005 on my computer and recently i have installed sql server 2008 client tools.

sql 2008 has separate server and worked with 2008...

OK.

i don't know what is causing the problem,because i have changed all the input column datatypes using derived task ->advanced editor.

except the date column which is date data type in...

I don't see anything in advanced properties.

But when i searched the web for this error some one told that if the source column has more than 255 characters we will...