Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Validation warning. Expand / Collapse
Author
Message
Posted Monday, October 6, 2008 11:30 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 3:57 AM
Points: 2,840, Visits: 3,971
hi

i my DTS package i m getting

Warning 1 Validation 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.dtsx 0 0

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
Post #581519
Posted Tuesday, October 7, 2008 12:21 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 3:57 AM
Points: 2,840, Visits: 3,971
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
Post #581532
Posted Tuesday, October 7, 2008 5:02 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 3:57 AM
Points: 2,840, Visits: 3,971
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
Post #581671
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse