Hi...I am hoping that some one can help me. I have only been working with DTS for a short time and I am stuck! I have a DTS package (in VB) that connections to an informix database, queries some tables and saves the results into unicode text files. There are 16 queries that I run, each saving to a separate file. Only one of the 16 queries is failing out with the error of....
The "PumpCibs2RatePlanStep" step in the package "Cibs2DataToFile" failed.
ErrorCode: -2147217887
Source: Microsoft Data Transformation Services Flat File Rowset Provider
Description: Incomplete file format information - file cannot be opened.
HelpFile: DTSFFile.hlp
HelpContext: 0
IDofInterfaceWithError: {0C733A69-2A1C-11CE-ADE5-00AA0044773D}
Now, this is not the first query or the last query but the 7th query. All of the others work fine. I looked up this error on microsoft's web site and got evey little info back. I am not sure what is going on and how to go about fixing it. If anyone could help, I would greatly appreciate it.
Thanks so much!