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: Monday, July 14, 2014 4:48 AM
Points: 2,834, Visits: 3,950
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 Monday, October 6, 2008 11:51 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, July 14, 2014 6:53 AM
Points: 550, Visits: 1,061
bhuvnesh.dogra (10/6/2008)
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



If I understand it correctly you have the following:
Source MS access with a text data type which size is 100,
Destination is a SQL table, and the field size is 60...

So you're trying to load 100 characters into a place holder of 60...?
The job won't fail, but you will lose 40% of the qstn_code's data.
To prevent this - change the data size of your destination field to 100.

Or don't I understand the question here?
Post #581525
Posted Tuesday, October 7, 2008 12:21 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 14, 2014 4:48 AM
Points: 2,834, Visits: 3,950
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 12:33 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, July 14, 2014 6:53 AM
Points: 550, Visits: 1,061
How do you pull the data?
1. Do you use a query in the task to extract the data - maybe you have a where clause that causes you to select no records - that's why you don't see any data in the preview window,and no data is migrated/copied
2. If it's a straight copy - make use that a.) you point to the correct table (with data in), b.) that the source table definitely have data in it.

The reason why you don't see any data in the preview window is, is the fact that there are no data in source.
So make sure that you do have data in the source tables, and if you use a query that the query is correct.
Post #581536
Posted Tuesday, October 7, 2008 5:02 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 14, 2014 4:48 AM
Points: 2,834, Visits: 3,950
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