Hi,

I'm trying to use dts to download data to an ascii file.

The query I'm using is below:

-----------------
SELECT generic_id, xml_transfer_site_id,
enable_invoice_id,
create_date, external_invoice_id, invoice_num, convert
(varchar(20),invoice_date,120) invoice_date,
enable_from_site, external_from_site,
enable_to_site, external_to_site, enable_source_from,
external_source_from,
source_date, trans_type_id, invoice_type, status,
convert(varchar(20),GETDATE(),120) AS edit_date,
privacy_flag
FROM xml_g_invoice_transfer_out_x where
create_date = convert(varchar(10),getdate(),112)
-------

When I "preview" the data it comes out fine (from the
source tab on the TRANSFORM DATA TASK PROPERTIES dialog
box). However when I go to the DESTINATION TAB and try to
create the "table" in the ascii file by clicking
on "EXECUTE" from the DEFINE COLUMNS dialog box, none of
the columns are created.

If I remove any two columns from the query, then it
creates the "table" in the ascii file.

Is there a limit as to the number of columns you can copy
over ?

Regards,


Ned

Have you recently applied SP3 to SQL Server ?

http://support.microsoft.com/default...B;EN-US;814113

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Ned Radenvoic" <anonymous (AT) discussions (DOT) microsoft.com> wrote