Validation warning.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Validation warning.

Validation warning.

Rate Topic

Display Mode

Topic Options

Author

Message

Bhuvnesh

Posted Monday, October 06, 2008 11:30 PM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

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----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #581519

Wandrag

Posted Monday, October 06, 2008 11:51 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, May 09, 2013 2:08 AM
Points: 505, Visits: 961

bhuvnesh.dogra (10/6/2008)

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

Bhuvnesh

Posted Tuesday, October 07, 2008 12:21 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

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----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #581532

Wandrag

Posted Tuesday, October 07, 2008 12:33 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, May 09, 2013 2:08 AM
Points: 505, Visits: 961

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

Bhuvnesh

Posted Tuesday, October 07, 2008 5:02 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

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----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #581671

« Prev Topic | Next Topic »

Permissions