#filetotable

How to extract OneStream data and load it to an external table - Part II #CPM #DataLoad #FileToTable #SQLBulkCopy

In this post, we will look at how to extract data from OneStream and load it to an external table by choosing specific columns from the extracted file I’m going to repurpose the rule from How to extract OneStream data and load it to an external table We will cover how to save a DataTable to a relational table (SQL Server), use SQLBulkCopy, and add Column Mappings for SQLBulkCopy. Here is how…

How to load a delimited file to a table in OneStream #CPM #FileToTable #DataLoad #Tips #Tricks

In this post, we will look at how to load a delimited file to a table in OneStream. I was working on a project, and my colleague raised this question. “Hey, I got a CSV file, is there a way I can load that to an OneStream table?” Till that time I’ve never thought of doing something like that. Here is how it can be done. Here is the code that I wrote during the video. Dim fileName As String =…