Viewing 15 posts - 61 through 75 (of 311 total)
(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...
March 10, 2011 at 6:19 am
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...
March 10, 2011 at 3:22 am
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...
March 10, 2011 at 2:38 am
Use LTRIM or RTRIM for left and right spaces on string in T-SQL
March 1, 2011 at 4:23 am
Excellent.
I've clearly spent too long programming 😀
March 1, 2011 at 4:15 am
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...
March 1, 2011 at 3:30 am
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, ...
March 1, 2011 at 2:48 am
good article and good tip for addining files without the need to do a full backup and restore.
March 1, 2011 at 2:32 am
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] = ?...
January 27, 2011 at 1:51 pm
Julian Kuiters (2/9/2006)
<a href="http://www.juliankuiters.id.au/article.php/ssis-lookup-with-range">SSIS...
January 27, 2011 at 5:02 am
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...
January 21, 2011 at 2:11 am
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...
January 20, 2011 at 10:08 am
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...
January 20, 2011 at 4:21 am
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...
January 19, 2011 at 8:25 am
No problem, pleased you resolved the issue.
January 19, 2011 at 3:06 am
Viewing 15 posts - 61 through 75 (of 311 total)