i m new to this so i dnt know much abt all this stuff what is staging table how should i mention that i have imported directly into database...

yeah this sounds good i could load the data as it is as i dnt have any problem in dng that but how should i change all the column value...

hello im importing data from excel to sql server in which i m using ssis so to manipulate the column named invoce date with that i need to make changes...

i have an other error too it says expression is not valid ir out of memory error what does that mean

failed to set property expression on input column invoice...

i tried that but it shows me the same error can i use the select statement in expression or do i jus need to start from dateadd and sometime it...

i m getting eror when i m usinf in expression can i use this in expression od derived column ....

i get the expression is incomplete or invalid token or incomplete...

WHERE SHOULD I JUS APPLY THESE ...I M NEW TO THIS SO WHERE SHOULD I WRITE THIS ......I HAVE SOURCE IN WHICH THE COLUMN IS DATA IN THAT FORMAT SO...

i m new to sql server so i dnt know abt that could plz let me know how to use views in that case and the primary key...

thka valek i have jus gone through that it worked out i found out the error .....

i have done that but i cpuldnt find any problem any way how should i do that will u plz tell me my data in row 44870 is

"Customer...

i have hundreds of thousands of rows in flat files...so how could i check the broken row or incomplete row ..i could solve if it is at the end of...

hey thkz may be it works i shall try and let u know .....i have got an idea on that ... so you jus want me to insert...

hi atleast could u jus let me know

How will you check the locks on a table???plz atleast let me know this i did that n i got that

thkz a lot may it would be helpful 2 me thkz ...

so can i find any consultant who can write a stored according to my req.....culd plz say me that