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...

Seems to work with the supplied data, but does not work with all occurrences of multiple commas, eg

insert into #table select '01008,,,,,,,,,,,,,,03072,0078,R,,'

I like Ramesh's solution. Your first solution replaces all commas ... this is not the requirement.

If your source data does not contain dups, but your target data does, you should be asking why, in my opinion - and that was my assumption on reading your...

Your DBA should be able to help you find out what process has locked the table ... then you just need to decide what to do about it. Killing the...