xlsx(office 2007), will support upto 4000 characters sql-->xls(x)-->sql (import /export),

earlier versions will support till 256 chars, it was one of the issue,

I just tried exporting from SS 2008 --> office...

daz...,

Thanks, now you answered my qtn :-);-)

I will send one more email...cheers

Sam,

Thats best approach,

Alaternatively, you can download 64bit oledb drivers for excel and ms access from msoft site, available from recently.

use "Send Mail task" for sending mails or you can use ActiveX script task too

for correcting error in ActiveX script task, you have to enter the entrypoint property

refer attached...

Hi Da-Zero / Phil Parkin,

Thanks for...

using system.io

read full line in a while loop and take what ever lengh you wanted from that using left function.

please use fully qualified name , means, use group name with domain too, like ABCGRP@domain.com instead ABCGRP.

We are using so many group emails , no issues, if you are...

you can capture the error message with system variable ...System::ErrorDescrition

This variable will hold the actual error message when any error occured.

Not sure, will this code is useful to you, however you can avoid looping using below code...

declare @strSQL varchar(1000)

set @strSQL =''

select @strSQL = @strSQL+COALESCE( Case

...

First let us know below details.

1. how you are activating/running package means, are u using sql job or commandline command or autosys or esp or maestro etc

2. are ur source...

Hi

As the file becomes dynamic now, you need to create structure to hold data before DFT task,

Please refer...Rafael articles on the same...

http://www.rafael-salas.com/2006/12/import-header-line-tables-_116683388696570741.html

and

http://www.rafael-salas.com/2008/03/ssis-and-dynamic-excel-destinations_01.html

cold_blue,

use expression as "your file name_Date_Time.xls" (e.g, "Report_20100707_1230.xls) on ExcelFileath property of the excel connection manager

and also set DelayValidation property to true.

RB

priya__ (7/6/2010)

Now there is a little more into this problem, now can I remove duplicates for that account num range before account number changes.....even if it is not in order...

...

Phil Parkin (7/6/2010)

If you take the time to read through the entire...

you can do....

1. take distinct records into temptable.

2. truncate original table

3. store temptable data into original table.

RB