cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
beobregon
‎10-11-2016
  • 4 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: How to convert SAS export file (.xpt) to SAS data files in SSIS pa...

by Calcite | Level 5 in Microsoft Integration with SAS
‎10-11-2016 11:26 AM
‎10-11-2016 11:26 AM
Hi Patrick,   Yes, I am suspecting that I will need to talk to our SAS developers to find out how they are currently converting the xport file to data sets and saving the files in a share path. That may be the way to go.   I will update the post asap.   BOGE ... View more

Re: How to convert SAS export file (.xpt) to SAS data files in SSIS pa...

by Calcite | Level 5 in Microsoft Integration with SAS
‎10-07-2016 11:29 AM
‎10-07-2016 11:29 AM
Hi Ballardw, accesing SAS directly is not an option, the sender is completely another institution sending us information. We use sFTP to transfer the files.  Regarding (.csv) hm, ... well that may be our last option. As I already mentioned, we are already loading the data sets just wanted to find a way to automate the process using the xpt export file if at all possible.   Thanks!!! ... View more

Re: How to convert SAS export file (.xpt) to SAS data files in SSIS pa...

by Calcite | Level 5 in Microsoft Integration with SAS
‎10-07-2016 10:50 AM
‎10-07-2016 10:50 AM
Hey Reeza, Thanks so much for replying! Reeza, we are actually already loading the data set to SQL Server, but it involves a lot of manual interaction. We are looking for automate the process that's the reason for trying to use SSIS.   I will take a look to the post that mentions using "STATTransfer" tool. I will let you know my findings.   Meanwhile, if anybody knows a way to automate this process please share 🙂     ... View more

How to convert SAS export file (.xpt) to SAS data files in SSIS packag...

by Calcite | Level 5 in Microsoft Integration with SAS
‎10-06-2016 05:57 PM
‎10-06-2016 05:57 PM
Hello there,   I have the following requirement. One of our data sources send us SAS data sets as part of a SAS export file (.xpt). We need to upload those data sets into SQL Server. So, we were planning to design an SSIS package that were able to extract the data sets from the XPT file to a folder and then using SAS ODBC driver upload them into SQL Server.   M problem is that I have not been able to find an application for windows that will do the extraction work in SSIS for us (I meant, something similar to what the 7z.exe does for a zip file.)   Is this even possible to extract the data sets from the xpt file using SSIS?   Thanks a lot in advance,   BOGE ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-11-2016 11:57 AM
Quick links