it has been modified as below

declare @qry as nvarchar(3000)

set @qry= 'insert into [bulkdata].[dbo].gpsdata ([REGISTRATIONNO],[UNIT_NO] ,[LATITUDE],[LONGITUDE],[ALTITUDE],[SPEED] ,[LAT_METER],[LON_METER],[SATELLITE],[GPS_DATETIME],[DIRECTION],[COMMUNICATION_CONTROL],[MESSAGE_NUMBER],[GPS_COMMUNICATION],[UNIT_MODE],[TXN_REASON],[ODOMETER],[IGNITION],[DOOR_SENSOR],[SHOCK_SENSOR],[DISTRESS_ALERT],[OILPRESSURE_SENSOR],[ENGINE_TEMP],[GPS_VOLTAGE],[BACKUP_VOLTAGE],[SIREN],[ALARM_ARMED],[GPSPOWER_STATUS],[HOOD_LOCK],[INTERNAL_LIGHTS],[BLINKER],[STD_IMMOBILIZER],[LOCATION],[BaseStationName],[Location_Speed]

,[analog1],[analog2],[door_lock],[reed_switch],[tag_id],[volume],[logic_state],[gps_valid],[gps_connected],[software_version],[Geo_Boundary],[trailer_tag_updatetime],[trailer_id],[driver_tag_updatetime])

...

Applied sp_executesql and got the solution

Many thanks to Mark and Wilfred, both of u replied within minutes of each other, But the moment I receied Mark's reply I tried out and IT WORKED.

Infact it...

thanks samanta

thank you, works

The above post helped me too

Many a doubts related to truncate and delete statements got clarified.

Thanks for the article