Showing posts with label tasks. Show all posts
Showing posts with label tasks. Show all posts

Friday, March 23, 2012

Multiple FTP tasks that connect to same server at same time error

I have this job that download 4 files once a month from the same server. The files are sizable and I need to download them in less than 5 hours total. In 2000 I use an active x script to generate the ftp script then execute the script. all four files download at the same time in 4 different tasks with no issues.

I am rewrote the process in 2005 so that it uses the IS FTP function but when all 4 ftp tasks kick off they all fail... instantly. the initially shared the same FTP connection manager so I created different ones for each and still the same result

the error is one that relates to changing directories.... Now if I just run one of the tasks it runs fine it is just when more than one try to run at once. I ended up putting in 10 second delays between each ftp task kicking off and it works just fine...

Does this sound like a bug?

Also... I am on SQL 2005 Enterprise SP1 on Windows 2003 enterprise SP1.

I can also reproduce the problem when multiple FTP tasks share the same FTP connection manager. But everything works fine if I create individual FTP connection manager for each task. This does sound like a bug to me so I am going to log a bug issue. We will investigate the problem and address it ASAP. Thanks you|||Thanks...

Friday, March 9, 2012

Multiple data flow tasks in one SSIS package

What are the advantages and disadvantages of having multiple data flow tasks in one SSIS package?

Is this a good idea at all considering the workflow may be similar now but may change in the future? Should it be left as one data flow per package?

It's up to you and how you like to manage your work. I like to break my packages into logical units -- each containing as many data flows as required. You'll want to balance this with maintainability though -- the less in a package, the easier to maintain.