Thanks again Tom. That was easier than I thought it was going to be.

Thanks for the help Tom. I thought I had tried that, but must have not done it correctly.

Now I just need to take my User::MinBegDate and User::MaxEndDate and pass...

Ps. I'm using OLE DB connections to SQL Server 2008.

If I try to use the SSIS Import and Export Wizard I get the following error after I enter in the properties of my IBM Informix OLE DB Provider:

===================================

Cannot get...

I'm using the 32bit Informix drivers in a 32bit Windows 2008 Server. The Informix DB is also 32bit. Is there a setting for 64bit in SSIS that I...

Are you running from your client PC or or you remotely connecting to the PC? I'm RDP'ng into a Windows 2008 Server and launching BIDS through there. I'm...

Either works.

I was thinking the columns of the report would be like this:

Item#, Item Description, Retail info (units, cost, retail), then the picture.

For the picture I would just...

Thanks for the response. However, I'm not sure I know which section I should be looking at on your link.

Thanks for the replies.

Informix will let me load using any number of delimiters. I prefer to use a 'pipe' (|) for the delimiter since Informix defaults to the 'pipe'...