Viewing 8 posts - 1 through 8 (of 8 total)
Thanks for the response !
I was kind of hoping to accomplish it somehow via the FtpClientConnection Class within vb.net (within a Script Task in SSIS).
Within the FtpClientConnection Class...
January 19, 2011 at 1:21 pm
No other packages within the project...
April 26, 2009 at 10:55 am
I do not know if this will be helpful, but I had a problem with a timeout occurring. It caused the program to "hang".
Can you make the file smaller just to...
August 27, 2007 at 5:35 am
Yes, I posted this in the public forums as well... and yes erland sommarskog has responded to me as well...
He does not like the "quick fix" (and rightly so for the...
September 12, 2006 at 7:28 am
In the example I presented, if you comment out the first COMMIT TRANSACTION (in the trigger), then the stored procedure that is called by the trigger (EXEC prProcessOrder @OrderID) will...
September 12, 2006 at 6:54 am
Sorry for the confusion folks....
In the example above, I want the original insert statement to work...
insert into Orders select '1111','1/1/2006'
Even if the procedure called by the trigger fails....
EXEC prProcessOrder...
September 12, 2006 at 5:42 am
Jeff,
When I tested this it did appear to "work"... The sp that the trigger call fails, yet the original insert sticks... because of the Commit Transaction within the trigger appears too...
September 11, 2006 at 7:00 pm
As I understand it..., without the explicit "Commit Transaction" within the trigger, the row would not get inserted if prProcessOrder fails because if any action within the trigger fails, then...
September 11, 2006 at 3:07 pm
Viewing 8 posts - 1 through 8 (of 8 total)