September 15, 2008 at 7:56 am
OK, so I have not gotten an answer to this. Can someone tell me how to add data to a table that has 5 columns that are not null and the first one has identity 1,1. I must keep the master table as it is.
Thank you
LadyDee
September 15, 2008 at 12:51 pm
INSERT ?
Perhaps you have left out some vital information.
September 15, 2008 at 2:41 pm
I have a table on our server, I have over 300 tables from our manufacturer's. I am using DTS to copy date from my server to the web server. The colum I am having aproblems with is
[PRODUCT_PKEY] [bigint] IDENTITY(1,1) NOT NULL,
[PRODUCTS_FKEY] [bigint] NOT NULL,
[added_at] [datetime] NOT NULL,
[updated_at] [datetime] NOT NULL,
[nvarchar](300) NOT NULL,
[name] [nvarchar](255) NULL,
[active] [bit] NULL,
[DATECREATED] [nvarchar](255) NULL,
[DATEMODIFIED] [nvarchar](255) NULL,
[keywords] [varchar](4000) NULL,
[chargeShipping] [bit] NULL,
[taxable] [bit] NULL,
[Manufacturer] [varchar](300) NULL,
[Manufacturer_ID] [bigint] NULL,
[deleted] [bit] NULL,
[discountable] [bit] NULL,
[onSale] [bit] NULL,
[wasIs] [bit] NULL,
[suppressSwatches] [bit] NULL,
[salesRank] [bit] NULL,
[CATEGORYCODE] [varchar](50) NULL,
[ChangeDateTime] [datetime] NULL,
[DateDeactivated] [datetime] NULL,
[MPN] [varchar](255) NULL,
[Yahoo_Name] [varchar](500) NULL,
[price] [numeric](18, 2) NULL,
[cost] [numeric](18, 2) NULL,
[Yahoo_Code] [varchar](255) NULL,
[ship_weight] [numeric](18, 2) NULL,
[carton_dimensions] [varchar](255) NULL,
[shipping_cost] [numeric](18, 2) NULL,
[shipping_price] [numeric](18, 2) NULL,
[shipping_rate] [numeric](18, 2) NULL,
[availability] [varchar](255) NULL,
[depth] [numeric](18, 2) NULL,
[height] [numeric](18, 2) NULL,
[length] [numeric](18, 2) NULL,
[weight] [numeric](18, 2) NULL,
[overall_dimensions] [varchar](255) NULL,
[out_of_stock] [bit] NULL,
[UPC] [varchar](255) NULL,
[Materials] [varchar](255) NULL,
[gender_id] [int] NULL,
[age_range_id] [int] NULL,
[artist_designer] [varchar](255) NULL,
[green_certified] [bit] NULL,
[made_in_id] [varchar](50) NULL,
[quick_ship] [bit] NULL,
[department_id] [int] NULL,
[product_type_id] [int] NULL,
[ISBN] [varchar](50) NULL,
[ASIN_Amazon_Number] [varchar](255) NULL,
[Collection] [varchar](255) NULL,
[Changed_By] [varchar](255) NULL,)
let say I want to insert
[PRODUCT_PKEY] [bigint] IDENTITY(1,1) NOT NULL,
[Manufacturer] [nvarchar](300) NULL,
[name] [nvarchar](255) NULL,
[MPN] [nvarchar](255) NULL,
[UPC] [nvarchar](255) NULL,
[cost] [numeric](18, 2) NULL,
[price] [numeric](18, 2) NULL,
[materials] [nvarchar](255) NULL,
[depth] [numeric](18, 2) NULL,
[height] [numeric](18, 2) NULL,
[weight] [numeric](18, 2) NULL,
[ship_weight] [numeric](18, 2) NULL
I am running into a problem witb the PRODUCT_PKEY.
Any suggestions:
Thank you
LadyDee
September 15, 2008 at 8:52 pm
Need to insert the identity column in the table?
SET IDENTITY_INSERT dbo.TableName ON
INSERT INTO dbo.TableName.....
SET IDENTITY_INSERT dbo.TableName OFF
September 16, 2008 at 8:31 am
Can this be done within the DTS? If not can you point me in the direction to see how this is done.
LadyDee
September 16, 2008 at 8:45 am
Yes it can, that's just a standard sql script. Create an sql script task (sorry, don't know the exact name) and put the code in there. That'll work just fine.
September 16, 2008 at 8:55 am
I was trying to use the following script and got an error after adding what you suggested:
SET IDENTITY_INSERT [Etilize].dbo.[Master Table] ON
insert into [Etilize].dbo.[Master Table] select * from [Darlene].dbo.[Abco]
SET IDENTITY_INSERT [Etilize].dbo.[Master Table] OFF
I recieved the following error:
Msg 213, Level 16, State 1, Line 2
Insert Error: Column name or number of supplied values does not match table definition.
Ladydee
September 16, 2008 at 9:13 am
You must list the columns you want to insert both in the insert statement and in the select.
INSERT INTO dbo.Table (Col1, Col2, Coln) Select Col1, Col2, Coln FROM dbo.Table2
September 16, 2008 at 9:30 am
I was trying to write the code rather then use DTS, when trying to use DTS, I do not see how you can do an edit unless you write the code.
Thank you
Ladydee
September 16, 2008 at 9:55 am
I'm going to suggest a different method for doing this in DTS. Remy's suggestion will work if you put the INSERT statement in an Execute SQL task. I suggest you use a Transform Data task.
Select Transform Data task from the task menu and click on the source connection then the destination connection. Open the properties of the task and select the Abco table on the Source tab.
Select the Master table on the Destination tab. The column transformations will be mapped automatically. On the Options tab, check the "Enable identity insert" box in the "SQL Server" section. Click "OK".
That should do it. Please post any specific problems you have.
Greg
September 16, 2008 at 10:32 am
I received the following from doing this, I used the DTS, from the data I want to copy to the table I want to copy it to, put a check in identify and received the following:
Operation stopped...
- Initializing Data Flow Task (Success)
- Initializing Connections (Success)
- Setting SQL Command (Success)
- Setting Source Connection (Success)
- Setting Destination Connection (Success)
- Validating (Success)
Messages
* Warning 0x80047076: Data Flow Task 1: The output column "Product_ID" (23) on output "OLE DB Source Output" (11) and component "Source - Abco" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
* Warning 0x80047076: Data Flow Task 1: The output column "creationdate" (29) on output "OLE DB Source Output" (11) and component "Source - Abco" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
* Warning 0x80047076: Data Flow Task 1: The output column "lastupdated" (32) on output "OLE DB Source Output" (11) and component "Source - Abco" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
* Warning 0x80047076: Data Flow Task 1: The output column "kind of code" (35) on output "OLE DB Source Output" (11) and component "Source - Abco" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
* Warning 0x80047076: Data Flow Task 1: The output column "long" (44) on output "OLE DB Source Output" (11) and component "Source - Abco" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
* Warning 0x80047076: Data Flow Task 1: The output column "short" (47) on output "OLE DB Source Output" (11) and component "Source - Abco" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
* Warning 0x80047076: Data Flow Task 1: The output column "basic" (50) on output "OLE DB Source Output" (11) and component "Source - Abco" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
* Warning 0x80047076: Data Flow Task 1: The output column "image" (53) on output "OLE DB Source Output" (11) and component "Source - Abco" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
* Warning 0x80047076: Data Flow Task 1: The output column "accessoryproductid" (56) on output "OLE DB Source Output" (11) and component "Source - Abco" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
- Prepare for Execute (Success)
- Pre-execute (Success)
- Executing (Success)
- Copying to [dbo].[Master Table] (Error)
Messages
* Error 0xc0202009: Data Flow Task 1: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Unspecified error".
(SQL Server Import and Export Wizard)
* Error 0xc020901c: Data Flow Task 1: There was an error with input column "code" (156) on input "Destination Input" (71). The column status returned was: "The value violated the integrity constraints for the column.".
(SQL Server Import and Export Wizard)
* Error 0xc0209029: Data Flow Task 1: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "Destination Input" (71)" failed because error code 0xC020907D occurred, and the error row disposition on "input "Destination Input" (71)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
(SQL Server Import and Export Wizard)
* Error 0xc0047022: Data Flow Task 1: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Destination - Master Table" (58) failed with error code 0xC0209029 while processing input "Destination Input" (71). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
(SQL Server Import and Export Wizard)
- Post-execute (Success)
Messages
* Information 0x402090df: Data Flow Task 1: The final commit for the data insertion in "component "Destination - Master Table" (58)" has started.
(SQL Server Import and Export Wizard)
* Information 0x402090e0: Data Flow Task 1: The final commit for the data insertion in "component "Destination - Master Table" (58)" has ended.
(SQL Server Import and Export Wizard)
* Information 0x4004300b: Data Flow Task 1: "component "Destination - Master Table" (58)" wrote 0 rows.
(SQL Server Import and Export Wizard)
Thank you
LadyDee
September 16, 2008 at 10:53 am
It looks like you're using the Import/Export Wizard rather than a package, right? And you're running it in SQL 2005 Mangement Studio?
The error indicates that the input column named STATUS violates the integrity constraint for the column in the destination table. Is there a foreign key on the column in the destination table?
It would be easier to help if you post the schema of the source table and the destination table including table names and all the columns.
Greg
September 16, 2008 at 10:59 am
I used the DTS and put a check in the identy box and got the following, should I savee the package:
Operation stopped...
- Initializing Data Flow Task (Success)
- Initializing Connections (Success)
- Setting SQL Command (Success)
- Setting Source Connection (Success)
- Setting Destination Connection (Success)
- Validating (Success)
Messages
* Warning 0x80047076: Data Flow Task 1: The output column "Product_ID" (23) on output "OLE DB Source Output" (11) and component "Source - Abco" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
* Warning 0x80047076: Data Flow Task 1: The output column "creationdate" (29) on output "OLE DB Source Output" (11) and component "Source - Abco" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
* Warning 0x80047076: Data Flow Task 1: The output column "lastupdated" (32) on output "OLE DB Source Output" (11) and component "Source - Abco" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
* Warning 0x80047076: Data Flow Task 1: The output column "kind of code" (35) on output "OLE DB Source Output" (11) and component "Source - Abco" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
* Warning 0x80047076: Data Flow Task 1: The output column "long" (44) on output "OLE DB Source Output" (11) and component "Source - Abco" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
* Warning 0x80047076: Data Flow Task 1: The output column "short" (47) on output "OLE DB Source Output" (11) and component "Source - Abco" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
* Warning 0x80047076: Data Flow Task 1: The output column "basic" (50) on output "OLE DB Source Output" (11) and component "Source - Abco" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
* Warning 0x80047076: Data Flow Task 1: The output column "image" (53) on output "OLE DB Source Output" (11) and component "Source - Abco" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
* Warning 0x80047076: Data Flow Task 1: The output column "accessoryproductid" (56) on output "OLE DB Source Output" (11) and component "Source - Abco" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
- Prepare for Execute (Success)
- Pre-execute (Success)
- Executing (Success)
- Copying to [dbo].[Master Table] (Error)
Messages
* Error 0xc0202009: Data Flow Task 1: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Unspecified error".
(SQL Server Import and Export Wizard)
* Error 0xc020901c: Data Flow Task 1: There was an error with input column "code" (156) on input "Destination Input" (71). The column status returned was: "The value violated the integrity constraints for the column.".
(SQL Server Import and Export Wizard)
* Error 0xc0209029: Data Flow Task 1: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "Destination Input" (71)" failed because error code 0xC020907D occurred, and the error row disposition on "input "Destination Input" (71)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
(SQL Server Import and Export Wizard)
* Error 0xc0047022: Data Flow Task 1: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Destination - Master Table" (58) failed with error code 0xC0209029 while processing input "Destination Input" (71). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
(SQL Server Import and Export Wizard)
- Post-execute (Success)
Messages
* Information 0x402090df: Data Flow Task 1: The final commit for the data insertion in "component "Destination - Master Table" (58)" has started.
(SQL Server Import and Export Wizard)
* Information 0x402090e0: Data Flow Task 1: The final commit for the data insertion in "component "Destination - Master Table" (58)" has ended.
(SQL Server Import and Export Wizard)
* Information 0x4004300b: Data Flow Task 1: "component "Destination - Master Table" (58)" wrote 0 rows.
(SQL Server Import and Export Wizard)
Thank you
LadyDee
September 16, 2008 at 11:00 am
I am getting the followingOperation stopped...
- Initializing Data Flow Task (Success)
- Initializing Connections (Success)
- Setting SQL Command (Success)
- Setting Source Connection (Success)
- Setting Destination Connection (Success)
- Validating (Success)
Messages
* Warning 0x80047076: Data Flow Task 1: The output column "Product_ID" (23) on output "OLE DB Source Output" (11) and component "Source - Abco" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
* Warning 0x80047076: Data Flow Task 1: The output column "creationdate" (29) on output "OLE DB Source Output" (11) and component "Source - Abco" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
* Warning 0x80047076: Data Flow Task 1: The output column "lastupdated" (32) on output "OLE DB Source Output" (11) and component "Source - Abco" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
* Warning 0x80047076: Data Flow Task 1: The output column "kind of code" (35) on output "OLE DB Source Output" (11) and component "Source - Abco" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
* Warning 0x80047076: Data Flow Task 1: The output column "long" (44) on output "OLE DB Source Output" (11) and component "Source - Abco" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
* Warning 0x80047076: Data Flow Task 1: The output column "short" (47) on output "OLE DB Source Output" (11) and component "Source - Abco" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
* Warning 0x80047076: Data Flow Task 1: The output column "basic" (50) on output "OLE DB Source Output" (11) and component "Source - Abco" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
* Warning 0x80047076: Data Flow Task 1: The output column "image" (53) on output "OLE DB Source Output" (11) and component "Source - Abco" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
* Warning 0x80047076: Data Flow Task 1: The output column "accessoryproductid" (56) on output "OLE DB Source Output" (11) and component "Source - Abco" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
- Prepare for Execute (Success)
- Pre-execute (Success)
- Executing (Success)
- Copying to [dbo].[Master Table] (Error)
Messages
* Error 0xc0202009: Data Flow Task 1: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Unspecified error".
(SQL Server Import and Export Wizard)
* Error 0xc020901c: Data Flow Task 1: There was an error with input column "code" (156) on input "Destination Input" (71). The column status returned was: "The value violated the integrity constraints for the column.".
(SQL Server Import and Export Wizard)
* Error 0xc0209029: Data Flow Task 1: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "Destination Input" (71)" failed because error code 0xC020907D occurred, and the error row disposition on "input "Destination Input" (71)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
(SQL Server Import and Export Wizard)
* Error 0xc0047022: Data Flow Task 1: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Destination - Master Table" (58) failed with error code 0xC0209029 while processing input "Destination Input" (71). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
(SQL Server Import and Export Wizard)
- Post-execute (Success)
Messages
* Information 0x402090df: Data Flow Task 1: The final commit for the data insertion in "component "Destination - Master Table" (58)" has started.
(SQL Server Import and Export Wizard)
* Information 0x402090e0: Data Flow Task 1: The final commit for the data insertion in "component "Destination - Master Table" (58)" has ended.
(SQL Server Import and Export Wizard)
* Information 0x4004300b: Data Flow Task 1: "component "Destination - Master Table" (58)" wrote 0 rows.
(SQL Server Import and Export Wizard)
LadyDee
September 16, 2008 at 11:03 am
I am getting the following:
Operation stopped...
- Initializing Data Flow Task (Success)
- Initializing Connections (Success)
- Setting SQL Command (Success)
- Setting Source Connection (Success)
- Setting Destination Connection (Success)
- Validating (Success)
Messages
* Warning 0x80047076: Data Flow Task 1: The output column "Product_ID" (23) on output "OLE DB Source Output" (11) and component "Source - Abco" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
* Warning 0x80047076: Data Flow Task 1: The output column "creationdate" (29) on output "OLE DB Source Output" (11) and component "Source - Abco" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
* Warning 0x80047076: Data Flow Task 1: The output column "lastupdated" (32) on output "OLE DB Source Output" (11) and component "Source - Abco" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
* Warning 0x80047076: Data Flow Task 1: The output column "kind of code" (35) on output "OLE DB Source Output" (11) and component "Source - Abco" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
* Warning 0x80047076: Data Flow Task 1: The output column "long" (44) on output "OLE DB Source Output" (11) and component "Source - Abco" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
* Warning 0x80047076: Data Flow Task 1: The output column "short" (47) on output "OLE DB Source Output" (11) and component "Source - Abco" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
* Warning 0x80047076: Data Flow Task 1: The output column "basic" (50) on output "OLE DB Source Output" (11) and component "Source - Abco" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
* Warning 0x80047076: Data Flow Task 1: The output column "image" (53) on output "OLE DB Source Output" (11) and component "Source - Abco" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
* Warning 0x80047076: Data Flow Task 1: The output column "accessoryproductid" (56) on output "OLE DB Source Output" (11) and component "Source - Abco" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
- Prepare for Execute (Success)
- Pre-execute (Success)
- Executing (Success)
- Copying to [dbo].[Master Table] (Error)
Messages
* Error 0xc0202009: Data Flow Task 1: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Unspecified error".
(SQL Server Import and Export Wizard)
* Error 0xc020901c: Data Flow Task 1: There was an error with input column "code" (156) on input "Destination Input" (71). The column status returned was: "The value violated the integrity constraints for the column.".
(SQL Server Import and Export Wizard)
* Error 0xc0209029: Data Flow Task 1: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "Destination Input" (71)" failed because error code 0xC020907D occurred, and the error row disposition on "input "Destination Input" (71)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
(SQL Server Import and Export Wizard)
* Error 0xc0047022: Data Flow Task 1: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Destination - Master Table" (58) failed with error code 0xC0209029 while processing input "Destination Input" (71). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
(SQL Server Import and Export Wizard)
- Post-execute (Success)
Messages
* Information 0x402090df: Data Flow Task 1: The final commit for the data insertion in "component "Destination - Master Table" (58)" has started.
(SQL Server Import and Export Wizard)
* Information 0x402090e0: Data Flow Task 1: The final commit for the data insertion in "component "Destination - Master Table" (58)" has ended.
(SQL Server Import and Export Wizard)
* Information 0x4004300b: Data Flow Task 1: "component "Destination - Master Table" (58)" wrote 0 rows.
(SQL Server Import and Export Wizard)
Ladydee
Viewing 15 posts - 1 through 15 (of 22 total)
You must be logged in to reply to this topic. Login to reply