From SQL to SPSS

Question

I need to export some data and then I have to export them in a SPSS file format.

I've already found out that I need a SPSS SDK. I also have found out that i need a I/O DLL for creating and reading these files.

But I cannot find them. Can anybody please send me the direct link, as it seems that I'm too dumb to find it.

Please help!

Thanks in advance

PS: I just need to create some SPPS files and I don't have any SPSS licence.

EDIT: it'a an webapplication on the internet, and the client wants us to generate SPSS files, so he can download it make some statistics

Answer 1

You can get the SPSS I/O materials from the SPSS Community site at www.ibm.com/developerworks/spssdevcentral. Free registration required.

These materials allow you to build an application in C, Basic or other languages that can read or write SPSS sav files. Doc and libraries are provided for a bunch of platforms.

HTH, Jon Peck

Answer 2

If your SPSS user is in your organization, they can connect to your SQL source with ODBC and then you won't need your SSIS package.