Maybe you could try INSERTing the data from another SQL Server table and comparing times - to work out whether the problem is something to do with the import or...

Add a process at the end to remove the dups from the flat file ... ?

Not elegant, but avoids the major redesign.

-- edit -- see below.

If you are using the VariableDispenser method to set/retrieve variables, you do not need to add the variables to ReadOnlyVariables or ReadWriteVariables - in fact, you should not. Just trying...

What sort of mainframe? Are you just talking about files, not databases?

Your mainframe tech guys will be able to help you, I would guess, in determining how best to do...

APARNA (4/8/2009)

---

May be it is an authentication issue . Please test by creating a simple sp that inserts data into the table and schedule it as a job and...

So is ID the PK in your destination table?

It is possible to do the UNPIVOT in T-SQL - but you would have to do the import of the data 'as...

This is not directly supported. I suggest that you bring the data in to a temporary (or staging) table (after having run TRUNCATE on it) and then use a stored...

Nasty - can you get a more verbose error message somehow?

Have you tried changing the Flat File Destination to a local drive, just to rule out possible permissions problems?

Have you tried editing the package in VS to see whether you can make it include the options that you want?

I haven't checked, but I'm guessing that the wizard has...

That is good news - thank you for the feedback!

Here looks promising

http://www.microsoft.com/downloads/details.aspx?FamilyId=E1A87D8F-2D58-491F-A0FA-95A3289C5FD4&displaylang=en

but I'm no Foxpro guru.

If that's a Foxpro DBF, you might need to install a driver (free, I think) before this will work.

Are you using a Foreach/File container?

Easy for me to...