Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
scven
Starting Member
5 Posts |
 Posted - 2007-06-11 : 06:07:41
|
| I am making an application that is handling orders for a client that is using Pastel Partner 2007. I need to find out if it is possible to batch import orders into pastel, either as orders or as quotes. If possible in what format does this need to be done? |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-06-11 : 06:18:50
|
| You can set up Import/Export To/From SQL server using some sort of delimited files (e.g. using BCP), XML, or if there is an ODBC/OLEDB driver for Pastel Partner then DTS (in fact DTS will also import from a variety of file formats such as XLS and so on)Kristen |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-06-11 : 06:20:56
|
| A quick Google suggests that Pastel Partner 2007 uses the Pervasive database, so DTS + the ODBC driver for Pervasive is probably your best bet.Kristen |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-06-11 : 06:24:40
|
And of course DTS (Data Transformation Services) isn't called that in SQL 2005, its now SSIS or SQL Server Integration Services ... <sigh!>So goodness knows which terminology you will find lying around in the Pastel / Pervasive DOCs, probably best you plan to search for Either/Both  Kristen |
|
|
|
scven
Starting Member
5 Posts |
Posted - 2007-06-11 : 06:58:35
|
| Thanks, i have had a look in the Patel SDK and it seems like you can import pipe delimited fields. Does anyone know how i can set up a pastel db locally so that i can test what i have found |
|
|
|
|
|
|
Pastel Partner Import