February 6, 2008 at 11:19 am
Good Morning,
I need assistance in designing a rather convoluted SSIS package. Here's what I need:
Extract two fields from a set of Crystal Reports.
Use one of the fields to link to my AS/400 table to obtain other data points.
Combine the resulting data set into a flat file and output to a network share.
Is it possible to use Crystal Reports as a data flow source?
How would I construct my link between my Crystal Report and the AS/400 table? Would I use an ODBC connection manager?
As you can probably tell, I'm a newbie to SSIS. Any direction/assistance would be greatly appreciated.
Thanks,
Sid
February 6, 2008 at 11:56 am
Can you render the Crystal report in XML? If so you can use the XML as a data source. Regarding the AS/400 connectivity, you can use the Microsoft OLEDB Provider for DB2 available in the feature pack (http://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en)
Good luck 🙂
Tommy
Follow @sqlscribeFebruary 19, 2008 at 12:45 pm
Is anyone familiar with configuring the IBM DB2 OLE DB Provider in SSIS? If so, can you forward to me documentation to follow in setting up this OLE DB Provider as a connection manager?
Thanks,
Sid
February 19, 2008 at 12:51 pm
Are you using IBM's OLE DB provider or Microsoft's OLE DB provider? If MS, refer to http://support.microsoft.com/kb/218590/[/url]
Tommy
Follow @sqlscribeFebruary 19, 2008 at 1:14 pm
I've been asked to use IBM's DB2 OLE DB Provider.
February 19, 2008 at 1:23 pm
In that case, IBM will be your best resource. A good place to start -
http://www-03.ibm.com/systems/i/software/access/windows/database.html
Tommy
Follow @sqlscribeFebruary 19, 2008 at 1:41 pm
Hi Tommy,
Thanks for your help. I'll check the I Series link you sent to see if we have that product licensed. I appreciate your assistance.
Thanks,
Sid
February 19, 2008 at 1:50 pm
NP, Good luck 🙂
Tommy
Follow @sqlscribeViewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply