I disagree, with your statement that you do...

To send your spool file as an email attachment.

I do not use the nasty AS400 GUI to get my information, I use other tools but:

From the Main Menu navigate by...

quillis131 (2/6/2012)

Looking for downloading a file (.XYZ extension) from...

I feel like I'm talking to myself, well I guess I am.:hehe:

Resolved the problem removed the client access components from my client pc and it works.:-D

Why not Create a DSN and link to the tables from Microsoft Access?

You will need to have the iSeries Client Access Components on your machine.

You will need the IP Address...

AS400 uses the word File what it is in fact a table.

I just transferred an AS400 File (Table) to SQL Serve using SSIS.

Is it a JD Edwards File(table)?

There is a...

The file that runs the iSeries Service has the same version and size.

On the machine that it does not work in 6/8/2005 modified date and on the machine that it...

I recreate the package on two servers. It failed on the first one but it ran on the second server without any warnings or errors.

I installed IBM Client Access Components...

I set the property "AlwaysUseDefaultCodePage" to true and the warning goes away.

Now I'm getting the following errors:

[OLE DB Source [1]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB...

Yes, that is what I wanted.

Thanks.

Thanks Sean.

What function do I user on the parent_object to get the Database Name?

Sounds like your Planning User Account is orphaned or is not a member of the Fixed Database Role db_datareader role or does not have object permissions to any tables.

Login with...

gweiho4xd2 (1/30/2012)

I've checked the DSN settings and it's using the correct SQL user account and points to the correct database.

None of the tables/views show up regardless of whether I attempt...

Have you Linked any tables?

What happens when you try that?

gweiho4xd2 (1/30/2012)

I agree that it shouldn't be that hard, but it is.

I have configured the DSN to use the SQL Server Account which worked fine with 'Microsoft SQL Server Management...