I had already replied to the op - my point on the BCI was in response to Gerd who wrote " I even doubt that exporting data from UD files directly into SQL Server tables is possible at all without some really fancy programming in foreign tongues like C# or similar." I was just saying that actually that is not the case BCI is simple, However as you say it may not be the right solution.
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Tony Gravagno Sent: 20 January 2010 22:43 To: [email protected] Subject: Re: [U2] Export files > From: Symeon Breen > Actually updating sql tables directly from udt is pretty easy > using the BCI I have to shake my head sometimes. Pick people are rightfully always looking for simple way to do things but when it comes to relational databases they resort to things like DTS and BCI and VSI and complex interactions that aren't necessary. Sure, I recently wrote here about a complex utility I wrote that discovers tables, views, and schema so that we can do exchanges with an RDBMS without manual mapping, but that solves a specific problem that isn't the topic of this particular thread. My policy is to not make MV do direct interaction with external environments unless I really need to do so. That policy works very well and I encourage others to consider it among other solutions. The OP question was: "Which is the simplest way to export data from Unidata to SQLServer?" When someone asks the "simplest" way to do things, consider just creating text files that have SQL queries. Then shell out to execute them or transfer them to a system where you can do so and execute them elsewhere. INSERT INTO table_name (column1, column2, column3,...) VALUES (value1, value2, value3,...) Just loop on that template in BASIC and replace the markers: INSERT INTO Employees (ID, LastName, Status) VALUES (1234, "Jones", "Terminated for stupidity") INSERT INTO Employees (ID, LastName, Status) VALUES (1235, "Smith", "Transferred to Siberia") Everyone here can understand this solution, unlike the others that have been proposed, and this is free and doesn't include any component other than BASIC. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula R&D provides Pick/MultiValue development services remove.pleaseNebula-RnD.com/blog Visit PickWiki.com! Contribute! http://Twitter.com/TonyGravagno _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
