(Doh! School boy error)

Keon, Well done! It appears I had the Force Execution result set to failure! I can only assume it's something I've done in testing...

no - nothing starting Error:

I haven't configured a result set, as nothing should be returned and I dont believe i set the task to fail regarldless of result, but I...

no. SSIS reports

Progress: Executing query "EXECUTE [etl].[up_time_dim_build] @p_start_date =". - 100 percent complete

Task SQLT - etl up_time_dim_build failed

.

thats it. The stored procedure however, was executed and...

Use LTRIM or RTRIM for left and right spaces on string in T-SQL

Excellent.

I've clearly spent too long programming 😀

I can't see anything wrong with your vb script (not a VB expert mind, but it looks simple enough). have you tried to copy the file, rather than move...

couple of questions / comments

from what I can see, SP4 is a 'Release To Manufactures' version, so to quote MS - may not be fully ready for genereal use.

Secondly, ...

good article and good tip for addining files without the need to do a full backup and restore.

ok - i've resolved the first issue of mathing the keys, by changing my look up SQL

select *

from

(select * from [dbo].[location_dim]) as refTable

where [refTable].[location] = ?...

Julian Kuiters (2/9/2006)

---

Sound similar to something I wanted to do a long time ago. I quickly knocked up an example today, so here's an article I wrote for you:

<a href="http://www.juliankuiters.id.au/article.php/ssis-lookup-with-range">SSIS...

well,

to a large extent, I've got the choice, with few little restrictions on what I choose to do - the only limiting factors really are potentially data related.

I'm moving...

Paul

sorry to bother you again - this is a performance question - but related to my original post.

When creating a stored procedure, an the execution plans is created...

HI all,

I appreciate this is an old post now but hopefully one of you might know if it's possible or not.

In a nut shell, we run cargo operation systems and...

Jack Corbett (11/11/2005)

---

I liked the article as it was concise and gave good tips for where to start. Is anyone out there using the SQLH2 tool available from MIcrosoft. I...

No problem, pleased you resolved the issue.