Thank you for sharing the link.

My problem is solved by writing a split function and then used cursor to get the data. Thank you guys.

Suri

Attachement you sent me is in 2007 format, can you send me in .doc format if you don't mind otherwise i need to download conversion software

Suri

Avinash,

Please look at the attached documents. First document shows step by step instructions how this is happening. Second attachement is the source file that i am using to import.

To...

I looked at preview in dataflow task in my excel source, there it is showing correctly but when i look at the preview in sql destination task, it is showing...

I typed myself. I have already bulit-in package in production that talks to excel files only. Each excel file will have multiple tabs which is not possible in csv.

Thanks for...

I did converted into numeric in my derived column task as (DT_NUMERIC,7,4)([Third Party Discount]). Still no luck. I have to use 4 decimals, the one i showed you is only...

I need it in real time only.

Hi,

I am new to working on SSIS pacakges and do u have any step by step description how to work on file watcher task? My needs are, i need to...