February 13, 2007 at 11:55 am
I am very new with SQL 2005. I am trying to create my first SSIS package through BI. I want to accomplish simple thing. I want to delete records from existing table, and then I want to populate this table with records from a SQL 2000 database.
If I just import table records from SQL 2000 to SQL 2005 database. It works fine. But when I try to delete existing records, then I get error:
Error: 0xC0010018 at Execute SQL Task 1: Error loading a task. The contact information for the task is "Execute SQL Task; Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1". This happens when loading a task fails.
Even with error, it does get data. But it never deleted existing records. I am struggling with it since a couple of days.
February 13, 2007 at 2:49 pm
Can you post the T-SQL code from your SQL task?
Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | 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, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | 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 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply