sql server dts: I'm trying to run a package to import a file and get the following error:
Step "Copy Data from cel_stat to [Skynet].[dbo].[cel_stat] Step" Failed
Error: -2147467259
Source: Microsoft Data Transformation Services Flat File Rowset Provider
Description: Incomplete file format information - file cannot be opened.

I have seen other mention of this error and it is seen when trying to
construct and fire the package through VB but the same package when
save to EM was fine. There was this problem a while ago

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q247108&

Also can you check for this line in your code

.ConnectionProperties("Number of Column") = 0




By using this VB method it would seem you want to build a package every
time rather than persisting it. You can change properties from within
the Object Model and this would be my preferred way of doing things.




Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
www.konesans.com - for all your consultancy needs