February 13, 2007 at 2:49 pm
Can you post the T-SQL code from your SQL task?
Tim Mitchell
TimMitchell.net | @tmitch.net | Tyleris.com
ETL Best Practices
February 13, 2007 at 2:57 pm
I am trying to delete existing records from table employee with following SQL statement:
Truncate table dbo.employee
February 13, 2007 at 3:40 pm
Just delete the records from the table instead:
DELETE FROM dbo.employee
Tim Mitchell
TimMitchell.net | @tmitch.net | Tyleris.com
ETL Best Practices
February 13, 2007 at 3:58 pm
Thank you very much for quick response.
Actually, I tried DELETE as well. I tried different SQL statements. None of the SQL statement works. Neither Update.
I think that there is some thing wrong with my setting. Control flow would not allow any SQL statement to execute.
I installed SQL Server on Win 2003 operating system ( have Win 2003 SP 1) last week. Then I installed SQL Server 2005 SP1. Then I installed hot fix 918222. Windows update gave my message to install Visual Studio 2005 SP1. But this installation fails. My gutt feeling is that I am missing some setting in my whole environment.
January 18, 2008 at 9:56 am
did you get a resolution to your problem? i have a very similar situation.
April 30, 2009 at 10:54 am
Did you ever get a resolution to this problem? I am having the very same problem.
May 4, 2009 at 12:39 pm
Ever get this resolved? If so, what did you do?
May 25, 2009 at 6:56 am
I am having the same issue and found this link: http://support.microsoft.com/kb/918038
I decided to post it here, it may help others :hehe:
Viewing 8 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply