Hi

You can add this send mail component in Event handlers, where you can specify onfailure of the task, perform the action. It could be sending an email alert, updating...

Hi

I guess this is the problem with data type.

When u define the flat file connection manager, in the Advance tab, you define the columns , data types and lenght of...

Hi

Can you please post more details about the requirement so that i can give a try

Regards

Bindu

Hi

In SSIS FTP Task, we don't have file operation "File Exists". Instead you can set the Maximum error count at package to a huge number so that if the file...

Hi

When you are trying to export table data to excel file, you have to use Execute SQL Query task to generate the excel file definition.

I think you are trying to...

Hi

I had faced the same problem. There is a limitation with SSIS. You can not use For each loop inside another for each loop to loop through some configuration table...

Hi

Here is the code to execute SSIS package from t-sql

Declare @result int,

@cmd nvarchar(4000)

exec xp_fileexist 'c:\file1.txt', @result output

IF (@result = 1) --if file exists exec ssis package

begin...

Hi

We can use case statement to edit the pivot output.

The actual data in the table is as follows:

siteiddatedescription ...

Hi

I could find one solution. we can use CASE statement to modify the final pivot output

select siteid,WeekEnding05252008,WeekEnding05182008,

(case WeekEnding05112008

when '2008-05-11 00:00:00.000' then '2008-05-12 00:00:00.000'

else WeekEnding05112008

end) as WeekEnding05112008

from

(select siteid,datedescription,datevalue from site

)...

Hi

I guess its compatibility issue. That can be resolved by executing the stmt given below

EXEC sp_dbcmptlevel , 90;

Pass the database name on which you are trying to...

I did further investigation on this. Here is my approach

select * from site

1WeekEnding052520082008-05-25 00:00:00.000

2WeekEnding052520082008-05-25 00:00:00.000

1WeekEnding051820082008-05-18 00:00:00.000

2WeekEnding051820082008-05-18 00:00:00.000

1WeekEnding051120082008-05-11 00:00:00.000

2WeekEnding051120082008-05-11 00:00:00.000

Use pivot to get the table in pivot format

select siteid,WeekEnding05252008,WeekEnding05182008,WeekEnding05112008

from

(select siteid,datedescription,datevalue from...

Hi

You can install the xpsmtp80.dll and use this for sending mail from SQL Server 2000.

For further details please check the url given below

http://www.sqldev.net/xp/xpsmtp.htm

Hi

You can use Pivot transformation in SSIS to achieve this

Thanks for the help !!!

I will surely post the solution if i get any

Thanks for your reply.

I did the samething but it doesnot work.

This would work if we have only one folder to be polled at each time.

But my requirement is we can...