sql server dts: export to DTSFlatFile -- sql server dts

export to DTSFlatFile

Sandrina
8/17/2006 8:15:39 AM

sql server dts:

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

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

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

--
Sandrin
-----------------------------------------------------------------------
Sandrina's Profile: http://www.dbtalk.net/m63
View this thread: http://www.dbtalk.net/t32637

RE: export to DTSFlatFile

Charles Kangai
8/20/2006 5:41:02 AM

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

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.