How to import SPSS .sav files with SQL Server Import and Export Wizard?

_{Tuesday, February 20, 2018 12:04 AM}

Hi all,

I've been struggling with trying to import an ongoing series of .sav files from SPSS into a SQL Server database. I've tried using ODBC connections in conjunction with the .Net Framework Data Provider for Odbc in the SQL Server Import and Export Wizard but I'm having no luck.

Am I going about this the wrong way? Is there a better way? I don't want to just export from SPSS to CSV files, because I'd like to eventually automate or semi-automate the import process. 

Open to any tips.

Thank you!

_{Tuesday, February 20, 2018 1:32 AM}

Hi Eric,

There is no native support to import .sav files in SQL Server. You can convert this file into .csv or other supported format. You can convert the file in SPSS or with the help of programming language (C# or python that i know, can do it).

How to do it refer below link

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/94621c5e-878e-45a5-bdc6-bbd7cb57436d/sav-files-conversion?forum=csharpgeneral

After converting you can use SSIS to load the data.

You can automate the entire process within SSIS itself.

Thanks

Cheers,

Amit Tomar

Please mark this as answer if it solved your query

Please vote this as helpful if it solved your query

My Blog My Wiki Page