October 28, 2011 at 10:28 am
I am getting following error
Operation stopped...
- Initializing Data Flow Task (Success)
- Initializing Connections (Success)
- Setting SQL Command (Success)
- Setting Source Connection (Success)
- Setting Destination Connection (Success)
- Validating (Success)
- Prepare for Execute (Stopped)
- Pre-execute (Stopped)
- Executing (Error)
Messages
Warning: Preparation SQL Task 1: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. (SQL Server Import and Export Wizard)
Warning: Preparation SQL Task 1: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. (SQL Server Import and Export Wizard)
Error 0xc002f210: Preparation SQL Task 1: Executing the query "CREATE TABLE `Shift` (
`ShiftID` Byte,
`Name` Lo..." failed with the following error: "Table 'Shift' already exists.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
(SQL Server Import and Export Wizard)
- Copying to `Shift` (Stopped)
- Post-execute (Stopped)
October 28, 2011 at 10:36 am
you are trying to create a table that already exists ('shift')
either check the table exists first, and drop the table before the create script, or bypass the create script all together.
Which option you chose depends on your business need for creating this table
October 28, 2011 at 10:41 am
Are you exporting to Excel or something like that?
If so, you'll need to start over with a blank file, or use the existing "table" (sheet) in the Excel file.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply