External scripts / imports / updates

Looking for suggestions on this one. What I want to do have have a text file that may have any number of rows and cols (with a predefined format) that a user can update or insert into a table. The definition of the row/cols and data mapping etc, has been done, it is the mechanics of actually doing the below I would appreciate help and advice on.

As the user is an 'end-user' (and has no SQL knowledge at all) the text file to import from will be placed in a predefined location and then a small script will be executed from their PC (as it happens, it's a Mac that runs an app that can exec an SQL command on the currently open database) that will in turn run a stored proc which is then reads in (imports or updates) the appropriate tables witht he contents of the external text file.

Sorry the explanation is a bit long winded but if anyone had any practical suggestions and examples, it would be greatly appreciated.

FYI, they are running SQL 2000 on both XP Pro and W2K3 server.

Thanks
StarbYou can take help of DTS package and schedule to run or give rights to the user to execute in order to import/export the data required.

Also can achieve with ISQL/OSQL utility, refer to books online for more information.|||You can take help of DTS package and schedule to run or give rights to the user to execute in order to import/export the data required.

Also can achieve with ISQL/OSQL utility, refer to books online for more information.
Thanks. Dont want to use a third party tool (OSQL etc) and can't use such as DTS and Exec as it is the 'End User' that will use the funtion. It must be run via a simple script from the Mac app.

Cheers
Starbsql

Exports reports from RS 2000 to RS 2005

Hello,
I need to export reports from RS 2000 to 2005 but I have problems
using rsscripter utility. The folders and datasources were imports to
RS 2005 properly. But the problems are the reports. I got the
following error when I ran the rsscript.cmd file:
SetReportDatasources is not a member of
Microsoft.SqlServer.ReportingServices2005.ReportingService2005.
1. Is there any fix to resolve this error?
2. Are there another ways to export/import reports from 2000 to 2005?
Please, I need help ASAP.Try opening the 2000 report in SSRS 2005, if it is a old version it will ask
you for exporting automatically, say yes to that and see how it does.
Amarnath, MCTS
"Gabe" wrote:
> Hello,
> I need to export reports from RS 2000 to 2005 but I have problems
> using rsscripter utility. The folders and datasources were imports to
> RS 2005 properly. But the problems are the reports. I got the
> following error when I ran the rsscript.cmd file:
> SetReportDatasources is not a member of
> Microsoft.SqlServer.ReportingServices2005.ReportingService2005.
> 1. Is there any fix to resolve this error?
> 2. Are there another ways to export/import reports from 2000 to 2005?
> Please, I need help ASAP.
>|||Thanks for response, your suggestion work properly.
Thanks!!
On 22 mar, 02:01, Amarnath <Amarn...@.discussions.microsoft.com> wrote:
> Try opening the 2000 report in SSRS 2005, if it is a old version it will ask
> you for exporting automatically, say yes to that and see how it does.
> Amarnath, MCTS
>
> "Gabe" wrote:
> > Hello,
> > I need to export reports from RS 2000 to 2005 but I have problems
> > using rsscripter utility. The folders and datasources were imports to
> > RS 2005 properly. But the problems are the reports. I got the
> > following error when I ran the rsscript.cmd file:
> > SetReportDatasources is not a member of
> > Microsoft.SqlServer.ReportingServices2005.ReportingService2005.
> > 1. Is there any fix to resolve this error?
> > 2. Are there another ways to export/import reports from 2000 to 2005?
> > Please, I need help ASAP.- Ocultar texto de la cita -
> - Mostrar texto de la cita -