yes my transaction log gets full

so i need to take backup and truncate it

please give me sql script for that

file format means.. it is a excel file everyday but data is changing its position everyday..

so how can i find out the proper data from that file...

is there any thing...

how many Execute SQL Task are needed as i have mentioned steps can you plz let me know how i need to go..

i'm newbie please help

AFTER LOOKUP I TOOK OLEDB DESTINATION FOR REST MAPPING LIKE THIS>..http://social.microsoft.com/Forums/getfile/19170/

I THERE ANY NEED OF UPDATE QUERY ???

i have company id in flatfile for evry company.. but id is not there in table..

in table only name and price is there

how can i compare id or i need...

can you provide me example link i'm newbie plz help

hi..

i want to insert 'price' into price column of my table 'mytemptable' and that price i'm taking from flate file..

in flat file i have company and price like this...

company price

abc...

ohh right lastly some where it is refereeing old column..

but it is giving output like '50265539.0600'

i don't want last '00' just want output as '50265539.06'

i have used (DT_DECIMAL,2)NewColumn

Thanks all 🙂

Hi i just need to list out the the name and region of countries in the regions containing 'India', 'Iran'.

from table bbc(name, region, area, population, gdp)

name region area population...

hi

i have added dataset into my ssrs report SP but now..

problem is

only 'PreviousNAV' field is coming ...

because

my SP having select queries like this..

SELECT ISNULL(NAV,0) PreviousNAV

...

hi I want to take value of date i.e '8/26/2011' , and value of NAV i.e '93737452.52'

and want to insert into table i'm using 'excel source ' to take excel...

hi ,

my excel file having more than one sheets

and

I don't know how can i convert that file into csv.

I don't know how can i do mapping in ssis...