How do you know the package is hung as opposed to just working? Are you
looking at sysprocesses, perfmon counters, etc? Or are you saying it hangs
when designing the package as opposed to when you run it?

Try breaking the import into smaller transactions, say importing 1000 rows
or 10000 rows per transaction.

Try the same insert through a linked server query, does it work? At the
very least it might fail and give an error message that will lead you to
the source of the problem.

Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.