There was an article posted recently about capturing the full text of the error message. It involved setting the error to log to the SQL error log and then retrieving...

Take a look at,

http://www.sqldts.com/default.aspx?103

Looping, Importing and Archiving

How can I check if a file exists?

You really have two paths to achieve this.

1) use a Data driven query. This way you supply T-SQL statments for each of the actions (INSERT/UPDATE/Etc...) and the data transformation is...

Have you run aspnet_regiis.exe to register ASP.Net with IIS?

How about this?

select fk_assid,
CASE WHEN sum(datediff(n,wt_starttime,wt_stoptime)) IS NULL THEN '0' 
ELSE sum(datediff(n,wt_starttime,isnull(wt_stoptime,getdate()))) 
END as 'timespent',
SUM(CASE WHEN datediff(d, CONVERT(varchar(15), GetDate(), 106), CONVERT(varchar(15), wt_starttime, 106)) = 0 
THEN datediff(n,wt_starttime,isnull(wt_stoptime,getdate()))
ELSE '0' END) ...

If you run the stored procedure without any parameters it will return everything since midnight. If you want to change that just alter the line after the "IF @dteMinStart IS...

Look up sp_executeSQL in Books Online.

Here's what we have for our status check. This is used to check on 80+ packages, of which about a dozen run on an hourly basis, the rest run overnight.

It...

Firstly, what error is the package failing with?

Second, why not just trigger the scheduled job from your ASP page using sp_start_job?

Another quick way to check space usage for columns is to look at the length field in EM's table design screen.

Good solution.

Funnily enough, after working on something else for a day, I came back to this and knocked up a similar query. Amazing what a clear head can do

Are you able to, or have you, logged in locally on the server(not via Remote Desktop) using the SQL account? Try running the package manually like this and see if...

Ahhh ... yes ... DTS in all it's glory.

When I'm trying to track down a pesky problem I do the following.

Turn on DTS package logging.

Set each task to fail package...

One option is to use some logic to check the source columns before you concatenate them.

Eg:

If DTSSource("Col009") is null

DTSDestination("CLO") = DTSSource("Col010")

elseif DTSSource("Col010") is null

DTSDestination("CLO") = DTSSource("Col009")

The only real way to get this to work is by using workflow scripts.

Take a look at this article,

http://www.sqldts.com/default.aspx?218