Thanks for the reply.

This query give result as:

Yr, Qtr, Sales, Difference

2009,4, $$, $$

I would like to see:

Y09Q4 Sales, Y08Q4Sales, Difference

Did you figure out how SSIC can be use to import email attachment data ? I get email everyday with xls attachment which needs to be imported into SQL table.

Thanks

DateAdd(hh,1,GetDate()) work fine

Thanks for all your help

Jeff,

I used GetUtcDate() function but it did not return the correct date/time. I need to retrive Eastern Time.

Thanks

Jeff,

I'm only storing $ symbol in field (varchar) for reporting.  There will not be any calculation.

Thanks

Jeff,

Field is define as Varchar Datatype

Thanks

Thanks,

I figure it out

David,

Part of my stored procedure inserts data from staging table to main table.  When entering data into main table is it possible to add "$" symbol for one of the...

David,

I did added the "Delete From Staging_CSVDump" line at the end of procedure.

I will look into online help for job creation.

Thanks

David,

Here is my storedProcedure. 

CREATE PROCEDURE CSVDump

AS

 --Bulk Insert Into staging table

Bulk Insert Staging_CSVDump

From "C:\CSV.txt"

With

 (

  FIELDTERMINATOR = ',',

  ROWTERMINATOR = '\N'

&nbsp

--Update main table

UPDATE tblMain

SET Prize = Staging_CSVDump.Prize,

   ...

1-OrderNo from the text file will join with OrderNo field in table

2-If the text file does't have a corresponding row in table, we will just ignore it.  Text file will...

David,

I have table "tblCSVDataUpdate" which needs to be update twice a day from "C:\CSV\CSVUpdate.txt" file

tblCSVDataUpdate has following fields:

OrderNo

Prize

Quantity

CustNo

ProductID

From CSV file i only need to update:

Prize and Quantity

This is what i...

David,

What is staging table ? Can you give me an example ?

Thanks

David,

I did not try seeting the column sort order.  Since the requirment change.

Now i need to update value in table from CSV file data...insted of inserting data as new value.

Prasad,

Thanks for the response.

I actully need to update my table with CSV data...twice a day. 

I don't think there is a Bulk Update....any other way to work around this ?...