I have a package that I want to export to a text file from a stored
procedure.

Both connections are set up correctly. When I try to edit the transformation
I cannot define any column mappings, the designer crashes when I click on
define columns. How do I create the transformations because at the minute I
just get empty rows?

If I create a simple export task through the wizard it all works fine, if I
try to edit this package then I cannot see any of the transformations as it
asks me to delete any invalid ones.

All the complicated stuff is finished I just cannot get the data to a csv
file.

--
regards Paul

Downloading now to see

--
regards Paul

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Could it be you are running into this problem which was introduced with SP3

http://support.microsoft.com/default...b;en-us;814113

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"PaulC" <paul (AT) _spam_cookson (DOT) demon.co.uk> wrote

Thank you. Patching has made it work. I would have been floundering for
hours.

--
regards Paul


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote