Hi Emma,

sorry but it doesn't work. if I use your syntax i'm receiving

'Incorrect syntax near '@comp_failed' probably because of the set keyword missing.

if I add the set I'm getting...

thanks a lot

I found the solution

SELECT

type_of_due = CASE

WHEN datediff(day, date1, getdate()) <=30 then 'Normal 30'

WHEN datediff(day,...

I created this select statement, that is returning the values that I need. Only thing remaining is grouping

SELECT

CASE

WHEN datediff(day,...

Thank a lot to both of you. Both solution work. Still Klaas-Jan I don't know if I really need the group option in your select statement. It's working also without...

Thank's a lot.

Apparently is has to do something with the cursor location.

I changed the code to this

set cn = Server.CreateObject("ADODB.Connection")

set cmd = Server.CreateObject("ADODB.Command")

set objrs = Server.CreateObject("ADODB.Recordset")

cn.CursorLocation = adUseClient ' Uncomment this line...

set cmd = Server.CreateObject("ADODB.Command")

cmd.ActiveConnection = "Provider=SQLOLEDB;Server=local;Database=INTRA;UID=sa;PWD="

cmd.CommandText = "sp_inventory_Class_click"

cmd.CommandType = 4

cmd.Parameters.Append cmd.CreateParameter("@clickclass",adChar,adParamInput,2, Label)

cmd.Parameters.Append cmd.CreateParameter("@countnr",adInteger,adParamOutput)

set objrs = cmd.Execute

response.write cmd.parameters("@countnr")

I found the solution:

Function Main()

if DTSSource("COPY") <> "1" then

Main = DTSTransformStat_SkipInsert

...

Thanks!

I was using where supplierid = null. 🙁

Durug

I tryed the same statement and I got this error when I tryed in QA before posting this question

String or binary data would be truncated.

The statement has been terminated.

So...

Thank you guys for your time. I will try tomorrow to see what can I do with it (my sql statements are pretty long to be added in the URL...

I found here a topic on the issue that I have:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q252987

When you execute a DTS Package from an ASP page, the package executes in the security context of...

Yes! The dtspkg is there. If the package and the asp file is on the same machine (X or Y) everything works well. The problem is only when I split...

Thanks a lot!!!