you'd have to set up a new data source to run sql queries

Oops! forgot the environment is SQL Reporting Services 2000, Visual C# 1.1

I'm not real familiar with SMB either.  But i think you could just truncate your message when you call the transmission procedure.

-- @Message the message you want to send

-- @headerlen...

oops left off a bunch of those pesky quote marks

objCMD.CommandText = objCMD.CommandText & "@message= "" " + DTSGlobalVariables("Path").Value + """"

Hmmm, truthfully I don't use it much.  Instead I rely on one of the queries in Step 4 above to handle those for me.

Agreed, if your programmer wants to refer to the row that contains 'apple' then he should use that in his where clause.  What is he doing that he thinks he...

change the expression

  objCMD.CommandText = objCMD.CommandText & "@message=   DTSGlobalVariables("Path").Value "

to look like

  objCMD.CommandText = objCMD.CommandText & "@message=  " + DTSGlobalVariables("Path").Value

When you create your table you can specify a default value for the column

create table mystuff ( bob varchar (50) Default 'Stuff' )

so when there would otherwise be a Null...

When you let the application make its best guess on the field sizes and types it only looks at the first few rows.  So its not unusual to get data...

it sounds like you are looking for all the words that contain 'Hello' if thats the case change your where clause to look like

WHERE word like '%' + 'hello' + '%'

this...

Change the structure of the IF statement so that the rest of the processing is only done when the file exists.  Note that the MoveNext and Path assignment are moved...

Sorry Steve, I haven't had an opportunity to explore SSIS yet.

change the code from the example to look something like this inside the Try portion of the routine:

' DTS Varialbe "Destination" is a path to write the...

is there a way for the subreport to jam a value into the main report?

Make a table something like:

create table TimeLog(

EventDT datetime not null,

StartStop varchar(5) not null,

AppName varchar(25) not null,

Info varchar(200) null

)

Then at the start of the process you want to time:

insert...