August 18, 2006 at 4:51 am
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."
DataSource property for the text file is "DTSFlatFile". I can't figure out what's wrong... help...
August 21, 2006 at 8:00 am
This was removed by the editor as SPAM
August 24, 2006 at 6:30 am
First create a DTS Package using export wizard, then we can customise the package
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply