Do I ne?ed an ODBC connection to use the FTP task?  If so, what driver do I use

Thank you.  This is exactly what I needed.

Thanks for the info. I checked the settings and the fetch buffer size is set to 1 already.  Are you using the Fast Load option?  What driver are you using...

Thanks for your reply.

I have created a DDQ that counts the records.

The transformation is set to Write File.

I have the correct directory set in the Write File Transformatin...

Thanks for everyone's replies.

I'm working in DTS query Designer. The Execute SQL task in specific.

I can get the following statement to execute, but cannot chagne it into an...

This returns an error of "The query designer does not support the optional FROM clause construct."

Thank you. This does make sence, but my experience is limited.

I have 2 connections, a transform data task and a mail task in the DTS package.

Do I add an activex...

Thanks for all your help.  I've written several packages using this statement.  Just what I needed.

Regards,

Joan

Greg,

Thanks for your reply. Yes the databases are on the same server. I tried your solution. This statement parses but shows nothing in the preview of the...

Thanks for your reply.

I wrote the query on the Source page of the Transform data task and this returns an error of

ADO error: Invalid Object Name MAXSYR_COMAPNIES

Statement(s) could not...