07-17-2013 01:24 AM
Hi Team,
Could any one please help to upload data to CSV file in CPO.
i have some data in DB and i need to extract data and copy to some CSV file in a dedicated path within CPO server.
Regards:
Vignesh
Solved! Go to Solution.
07-17-2013 04:42 AM
Using an OLEDB would work great if you always saving the same file name. However, a single target might be difficult if you have to write different file names in different workflows, or perhaps different columns.
You could also use the following sequence of activities:
Note that if you are trying to save thousands of lines of data this way, OLEDB approach might be faster and easier on the Orchestrator.
07-17-2013 03:42 AM
You can make the CSV file a target and configure it via OLEDB target and then do whatever to it I would think.
You need to install the MS ACE driver @
http://www.microsoft.com/en-us/download/details.aspx?id=13255
Then you can use the Generic DB target in CPO
Make the hostname/datasource the file name, runtime user as a windows user with access to the file, and the connection string something like this:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\
I used "C:\test.csv"
--shaun
07-17-2013 04:42 AM
Using an OLEDB would work great if you always saving the same file name. However, a single target might be difficult if you have to write different file names in different workflows, or perhaps different columns.
You could also use the following sequence of activities:
Note that if you are trying to save thousands of lines of data this way, OLEDB approach might be faster and easier on the Orchestrator.
07-17-2013 04:51 AM
Hi Shaun,
Thanks for replying. I will try these options as mentioned above and will send you the update if any issues.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide