I'm building the dts from scratch... The goal is to build a dts to export some data (sql statement is a must) from one table to a text file. I've built a package, connections (two of them, one for the sql server, and one for the text file), steps (only one), one task with one custom task, and one transformation object (there is only one column in the select clause in sql statement). However, when I execute the package, I get the following error:

"Incomplete file format information - file cannot be opened."

ProviderID property for the text file is "DTSFlatFile", and I've assigned the DataSource property - an UNC path. My guess is that the transformation isn't done correctly, but I can't figure out what's wrong... help...

You have not told DTS how to write the file. Double-click the file connection
and click Properties button. But even better, instead of building the dts
package from scratch like this, just use the DTS Import/Export wizard and
choose whether to export from a table or a SQL command. It will ask you for
the file format you want as part of the wizard. If you want to save the
package, you can do so as part of the wizard.

Charles Kangai, MCT, MCDBA




"Sandrina" wrote: