DataFlow task completes only 50 percent and package execution completes.
I'm working in sql 2008(64bit machine). I have a data flow task in which I'm extracting data from ODBC source and loading into sql server . The problem is, activities inside data flow task are executed successfully and they are turned into green color but data flow task is still showing in yellow color And it shows package execution completed. Same package is working perfectly fine in sql 2005(32bit machine). I have set 64bitmachine property to "false" and even increased DefaultBufferSize and DefalutBufferMaxRows but still no luck. Please help me with this issue.
January 22nd, 2011 6:59pm

Hi, Then the problem is the colour of the DFT box when it completes? or the transaction doesn't commited?Vctor M. Snchez Garca (ES) (BI) Hope this help. Please vote if you find this posting was helpful. if this is an answer to your question, please mark it. http://bifase.blogspot.com | http://twitter.com/atharky
Free Windows Admin Tool Kit Click here and download it now
January 22nd, 2011 7:04pm

Hi, My driver is a 32bit driver and my machine is 64bit machine. Therefore I even set the property "Run64bitruntime = false" and increased DefaultBufferSize and DefaultBuggerMaxRows as suggested in one of the blog. but still no luck. Mamatha
January 29th, 2011 5:06pm

Hi, The DFT has any Script component inside? You must recompile it, if yes. The DFT does deletes or updates via OLEDB command or inserts? Check what's happening in SQL Server with SQL Profiler. It's possible that package keeps waiting until log operations are completed.Vctor M. Snchez Garca (ES) (BI) Hope this help. Please vote if you find this posting was helpful. if this is an answer to your question, please mark it. http://bifase.blogspot.com | http://twitter.com/atharky
Free Windows Admin Tool Kit Click here and download it now
January 29th, 2011 8:23pm

Hi, Thanks for your response. Problem is not with the color. I have other tasks to be completed after this data flow task, but control is not going to next task. Progress shows DataFlow task completed 50 percent and it is not becomming 100 percent at all. And overall package status is "package execution complete".Mamatha
January 29th, 2011 8:47pm

Hi, My driver is a 32bit driver and my machine is 64bit machine. Therefore I even set the property "Run64bitruntime = false" and increased DefaultBufferSize and DefaultBuggerMaxRows as suggested in one of the block. but still no luck.Mamatha
Free Windows Admin Tool Kit Click here and download it now
January 29th, 2011 8:53pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics