Problems with DTS in SQL 2005

Hi, I'm try to edit/run DTS packages against a SQL 2005 (developer edition)
database. I installed the download to support the DTS designer, but
occasionally the designer still prompts for the download and then (usually)
crashes.
Sometimes, however, it works fine -- sort of. In Bulk Insert task, I can't
get the task to recognize the .fmt file specified. The step fails and then
the format file name is changed in the step to the destination table name in
the step properties. It looks like DTS is ignoring the .fmt file and trying
to do the conversion itself. Weird.
Any help or appropriate KB articles would be appreciated.
Thanks,
Beige Bond
http://www.aspnetworkshop.com/
More detail on this: SQL 2005 seems to have a problem importing 2000 DTS
packages correctly in some situations. I think it depends on how they were
exported. I can get export/import to work but it takes a couple tries
sometimes.
The .fmt problem was just an error in the DTS. (oops)
"Beige Bond" <BeigeBond@.hotmail.com> wrote in message
news:%23j%23MK5UPGHA.3016@.tk2msftngp13.phx.gbl...
> Hi, I'm try to edit/run DTS packages against a SQL 2005 (developer
> edition) database. I installed the download to support the DTS designer,
> but occasionally the designer still prompts for the download and then
> (usually) crashes.
> Sometimes, however, it works fine -- sort of. In Bulk Insert task, I can't
> get the task to recognize the .fmt file specified. The step fails and then
> the format file name is changed in the step to the destination table name
> in the step properties. It looks like DTS is ignoring the .fmt file and
> trying to do the conversion itself. Weird.
> Any help or appropriate KB articles would be appreciated.
> Thanks,
> Beige Bond
> http://www.aspnetworkshop.com/
>