InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 13:21:12 GMT20http://www.sqlservercentral.com/Forums/Topic581519-148-1.aspxnow 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 Tue, 07 Oct 2008 05:02:39 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic581519-148-1.aspxHow 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/copied2. 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.Tue, 07 Oct 2008 00:33:42 GMTWandraghttp://www.sqlservercentral.com/Forums/Topic581519-148-1.aspxu r right ...i resolved that problembut 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 helpTue, 07 Oct 2008 00:21:05 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic581519-148-1.aspx[quote][b]bhuvnesh.dogra (10/6/2008)[/b][hr]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 [/quote]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?Mon, 06 Oct 2008 23:51:04 GMTWandraghttp://www.sqlservercentral.com/Forums/Topic581519-148-1.aspxhi 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 Mon, 06 Oct 2008 23:30:35 GMTBhuvnesh