Hi Ross,

I am working on one machine , my web server is on other machin and SQLServer  is on different machine . I am putting excel file on webserver.

Yuvraj

Hi,

I think yes, because When I try to execute same DTS in Enterprise manager then it works.

When I am trying to execute the same DTS from ASP it faills,  how can I identify...

Hi Ross,

Yes DTS executed successfully from DTS designer and I am using enterprise manager from my pc to access SQL. I have SQLserver2000 client installed on my pc.

Yuvraj

hi,

I tried with  the code given in site mentioned by you but unfortunately that code also not working properly with me. I have two stpes in my DTS.First step is...

hi ross,

I don't have execute rights on xp_cmdshell. is there any other way to execute DTs thro ASP.?

Hi,

with help of single select statement I don't think so it is possible . but u do this by using some programing logic like this

--CREATE TABLE FOR JUST STORING...

Hi,

you can any one of these two sp to send mail but for this outlook should be installed on your server.sometimes you can face some problem in outlook also.

Run your query and...

If you want to concatnte the two columns the first you should convert it into the string either by using cast or convert functions then use regular "+" operator to concaenatet...

I think U can use case statement here to combine two queries in one.

Hi Orkei,

I think whereever u got the value as '01/01/1900'. you might have inserted blank value('') in database.When u try to insert blank value ('') in a column of Data type...

I think varchar(255) will be the maximum possible length allowed in BCC.

Thanks

yuvraj

Gr8 explnations  Kenneth.

Hey Rajiv,

 u will get it very clear with following query.It's same as above but slight change.

SELECT MIN(CASE Description WHEN 'Tiering' THEN Value ELSE NULL END) AS Tiering,

 MIN(CASE Description WHEN 'Strategic...

Select Account,

Case when Account = 'Cr' Then Amount End   Dramt ,

Case When Account = 'Dr' Then Amount End Cramt

from [TableName ]

UNION

Select...

Mike u r right but this is round about way not a direct  , I was expecting direct way from SQL server but I think it is not there. Any way...