December 29, 2008 at 12:55 am
Hi,
I have been facing a strange problem in nmy ssis package since last week. The package has a data flow task which in turn executes an SP and directs the result set to a flat file. The SP actually contains a for XML statement and the XML generated is CAST to TEXT in the SP itself. However, when I execute this package, for a data volume of 50 MB it gets executed fine. But, however, for a larger data volume say 200 MB, the data flow task remains yellow forever. And every time after writing upto a certain file size (in this case it is 143 MB), the file write comes to a standstill. However, thuis problem is only occuring in my staging environment. When, in my development server, when I execute the package, it is getting executed fine for even 500 MB data.
What can be the possible reason for this? Can this be a tempdb issue or is it some package configuration issue? By the way, I have set the DefaultBufferMaxSize property of the data flow task to its maximum value.
Any help in this regard would be highly appreciated.
December 29, 2008 at 3:34 am
December 29, 2008 at 4:30 am
The server is having 60.0 GB memory. One thing: in my DEV environment I have connected using SQL Server SAuthentication whereas in the staging environment (where I am facing the error), I have connected using Windows Authentication. Could this be a potential reason?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply