August 14, 2007 at 3:09 am
Hi All,
I am in process of transfering data from Sybase to Sql Server using SSIS 2005
have taken a Data Flow Task in Control Flow tab
In Data flow tab, I have taken one Ole DB Source and One OLe DB Destination
For the source, I am using Sybase Adaptive Server Anywhere Provider 8.0
For Destination, I am using Sql Server 2005 database
In Ole Db Source Editor ,
For OLe Db Connection Manager, I choose Sybase Connection
For Data access mode, I choose Table or View
For Name of the table or the view, I choose a table by name Table1( it lists all the tables from Sybase database)
When i click on preview button or Columns link, I get the following Error
Error at Data Flow Task [OLE DB Source [1]]: An OLE DB error has occurred. Error code: 0x80040E21.
Error at Data Flow Task [OLE DB Source [1]]: Unable to retrieve column information from the data source. Make sure your target table in the database is available.
------------------------------
ADDITIONAL INFORMATION:
Exception from HRESULT: 0xC020204A (Microsoft.SqlServer.DTSPipelineWrap)
Please help me out.
Thanks in Advance
Srinivas
October 8, 2007 at 5:03 am
For simple queries I've found that setting the AlwaysUseDefaulCodePage Custom Property of the OLE DB Source control to True overcomes this.
October 17, 2007 at 4:54 pm
Incredible! I've been stuck on this exact problem for 6 months. Thank you so much for your help!!!
Ryan
February 27, 2009 at 10:30 am
i have the same problem as above but here both my source and destination are sql server 2005 db. my package is for incremental load was running fine for few months but all of sudden it is giving my this error.
[OLE DB Destination [921]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x8007000E.
[OLE DB Destination [921]] Error: Unable to retrieve column information from the data source. Make sure your target table in the database is available.
[DTS.Pipeline] Error: component "OLE DB Destination" (921) failed the pre-execute phase and returned error code 0xC020204A.
i also tried setting the AlwaysUseDefaulCodePage Custom Property of the OLE DB Source control to True. also tired the same for the destination but then it gives the following error
[DTS.Pipeline] Error: The Data Flow task failed to create a required thread and cannot begin running. The usually occurs when there is an out-of-memory state. .
[DTS.Pipeline] Error: The Data Flow task engine failed at startup because it cannot create one or more required threads.
the package uses a lookup transformation. i have tried checking the "enable memory restriction" and increases hte buffer size but still of no use.
Please help me.
March 23, 2009 at 1:31 am
This is awesome. Past one week, I was looking for solution for this problem.
Setting the AlwaysUseDefaulCodePage to true is working fine.
:-)Thanks a lot
Bala
February 4, 2010 at 10:31 pm
Its Simple & It works great 🙂 !!
I was getting the following error for one data Flow Task in my Package:
Error: Data Flow task failed to create a required thread and cannot begin running. The usually occurs when there is an out-of-memory state.
Solution: I set the Custom Property AlwaysUseDefaultCodePage to True for one Data Destination in the same component
Thanks
June 1, 2011 at 11:36 pm
I still get this error
I passing exec AdventureWorks..xxp_ExportObjects_To_File_1 'AdventureWorks' , 'dbo' , 'xxp_GetAllObjects' from parrameter which is dynemic and it return create proc script
any one help me out?
October 3, 2011 at 3:37 pm
use below command
SET FMTONLY OFF
SET NOCOUNT ON
exec storeproc name
November 17, 2011 at 2:16 pm
THANK YOU!!!!
Adding SET FMTONLY OFF and SET NOCOUNT ON solved this problem for me on result sets!
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply