June 18, 2014 at 6:48 am
i have this create this query
DECLARE
@SqlStmt NVARCHAR(max),
@WorkingAttributeTableName NVARCHAR(256)
IF OBJECT_ID('dbo.#_SSCIREAttributeData','U') IS NOT NULL
DROP TABLE dbo.#_SSCIREAttributeData
CREATE TABLE dbo.#_SSCIREAttributeData (
[PK_ID] [int] IDENTITY,
ComplexName [NVARCHAR] (128) NULL,
ComplexLegalName [NVARCHAR] (256) NULL,
ComplexCode [NVARCHAR] (128) NULL,
FundGroupName [NVARCHAR] (256) NULL,
FundGroupCode [NVARCHAR] (16) NULL,
FundName [NVARCHAR] (256) NULL,
FundLegalName [NVARCHAR] (256) NULL,
FundDisplayName1 [NVARCHAR] (256) NULL,
FundDisplayName2 [NVARCHAR] (256) NULL,
FundCode [NVARCHAR] (128) NULL,
LegalEntityCode [NVARCHAR] (128) NULL,
FiscalYearEnd [INT] NULL,
FiscalYearEndIsEOM [INT] NULL,
FiscalYearEndDay [INT] NULL,
CurrencyCode [NVARCHAR] (128) NULL,
CustodyCode [NVARCHAR] (128) NULL,
Active [BIT] NULL,
InceptionDate [DATETIME]NULL,
CloseDate [DATETIME] NULL,
FundTypes [TEXT] NULL,
AttributeNames [NVARCHAR] (128) NULL,
AttributeTypeNames [NVARCHAR] (128) NULL)
SELECT @WorkingAttributeTableName = ?
SELECT @SQLStmt = 'SELECT * INTO ' + @WorkingAttributeTableName + ' FROM dbo.#_SSCIREAttributeData' + CHAR(10)
SELECT @SQLStmt = @SQLStmt + 'ALTER TABLE ' + @WorkingAttributeTableName + ' ADD CONSTRAINT PK_AttributeData1 PRIMARY KEY (PK_ID)' + CHAR(10)
EXECUTE (@SQLStmt)
can i change this part
Active [BIT] NULL,
to a bool. im getting an error when trying to load data into my table and i think this causing the issue
June 18, 2014 at 6:51 am
A bit is a boolean, so I'm not sure what you are getting at.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 18, 2014 at 7:05 am
i thought so i just wanted to make sure
im getting this error and i have no idea why
[Attributtes Table [85]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
June 18, 2014 at 7:10 am
Any other errors in SSIS?
If you hardcode the value for @WorkingAttributeTableName, does it work?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 18, 2014 at 7:11 am
there was 2 more things on it below i here they are
[Attributtes Table [85]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "OLE DB Destination Input" (98)" failed because error code 0xC020907B occurred, and the error row disposition on "input "OLE DB Destination Input" (98)" 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.
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Attributtes Table" (85) failed with error code 0xC0209029 while processing input "OLE DB Destination Input" (98). 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.
June 18, 2014 at 7:15 am
How did you configure the OLE DB destination?
Anything special?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 18, 2014 at 7:19 am
no not really just connected to to the database. that seems find as it runs other stuff before it hits this and that all creates and loads data as expected
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply