tags:

views:

6

answers:

0
Q: 

SSIS Post Execute phase takes too long

I have a SSIS Package (SQL Server 2005) which has a very simple control flow and a data flow. The package runs acceptably fast, but the Post Execute phase is ridiculously slow - the whole package takes 90 minutes to execute, from which 37 are the PostExecute phase.

I don't have any event handler on that step, the source and the destinations of the dataflow are "OLE DB Command" nodes.

Do you have any ideea what might be wrong? Or...is this normal, there's nothing wrong? Where could I look next in order to improve this? Any advice is very welcomed!

Thank you.

related questions

Compare Strings given in $_POST with php
Ruby: How to post a file via HTTP as multipart/form-data?
How can I upload more than one file from a single HTML form in IE?
Is there any way instead of a JS hack where I can post from an iframe to another page outside the iframe?
How do I POST from an iframe to another page outside the iframe?
Javascript Post on Form Submit open a new window
POST multiple parameters
HTML: POST for images?
Sensible HTTP POST timeout values to use when programmatically issuing requests?
How do you post to an Iframe?
How do I prevent ServerXMLHTTP from automatically following redirects (HTTP 303 See Other responses)?
How can I send an HTTP POST request to a server from Excel using VBA?
What is the preferred way to redirect a request in Pylons without losing form data?
Send file using POST from a Python script
Javascript Post Request like a Form Submit
Problem POSTing to webservice in .net 3.5 solution
Python and POST data
How would one log into a phpBB3 forum through a Python script using urllib, urllib2 and ClientCookie?
Parsing HTTP Headers
jQuery ajax $.post successfull ?
PHP Multiform Validation and Redirection
When do you use POST and when do you use GET?
Security advice for jquery ajax data post?
Passing $_POST values with cURL
What is the best way to upload a file via an HTTP POST with a web form?