This was easily achievable in the earlier versions of MS-SQL using the data transformation services on MS-SQL which had the ability to connect to CSV files or Excel or Access or other RDBMS's or DBMS's.
I'm not quite sure if this is possible on MS-SQL 2005 as I do not see that option available at least out of the box on SQL 2005. Maybe its a separate product now sold separately? It would be possible using Remedy's EIE engine, if you are willing to deal with a few share of problems it seems to be bundled out with where no fixes seem to have been offered by Remedy support for a while now - Or at least that's what I heard on a thread I had started out earlier describing problems I am facing with it. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of brooksm Sent: Wednesday, July 11, 2007 6:38 PM To: arslist@ARSLIST.ORG Subject: Importing csv file into Remedy Does anyone know of a way to allow end users to import records from a .csv into Remedy? My Remedy system is on SQL Server 2005, so I thought there may be a way to create an SSIS package that imports a file from a shared directory when triggered by workflow. Does anyone know if this is possible? Or is there some other easier way? Thanks Brooks No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.476 / Virus Database: 269.10.4/896 - Release Date: 7/11/2007 4:09 PM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
