October 6, 2008 at 11:30 pm
hi
i my DTS package i m getting
Warning1Validation warning. Data Flow Task 1: QUESTION [1692]:
Truncation may occur due to inserting data from
data flow column "question_code" with a length of 100 to database column "qstn_code" with a length of 60.
SSIS_DataDump_Event 1.dtsx00
column description
IN Sql table : qstn_code nvarchar(60)
In Ms Access : question_code (Data type : TEXT)
Please suggest
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 7, 2008 at 12:21 am
u r right ...i resolved that problem
but can u tell me If Preview option in Dts components doesn't show records what does that mean ???
MY DTS is running success fully but data is not migrated ??
Pleasee help
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 7, 2008 at 5:02 am
now i m getting this error
[GROUP_ITEM_DETAIL [962]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "DestinationConnectionOLEDB" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
[Connection manager "DestinationConnectionOLEDB"] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040154. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".
i have checked mi MS Access connection but still getting it
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply