"Allan Mitchell" wrote:

> Wouldn't you better off writing a macro inside of Excel to do this
> instead of invoking SSIS? What do you see are the advantages of SSIS?
>
> --
>
>
> Allan Mitchell
> http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
> http://www.konesans.com
>
>
>
> "MIB" <MIB@discussions.microsoft.com> wrote in message
> news:EF539DA4-A995-4035-AE44-A5FB8D10383B@microsoft.com:
>
> > We are going to use the same worksheet, a table containing data from SQL
> > server will be refresh after the user press a button. And the same user will
> > send data to SQL Server after changing some datas. Each time tht new data are
> > in the system, some package must run again.
> >
> > "Allan Mitchell" wrote:
> >
> > >
> > > Ok?
> > >
> > > Not sure what you need here.
> > >
> > > Does your application create the Execel Workbok and sheet and you want
> > > to pump that into SQL Server using SSIS?
> > >
> > > OR
> > >
> > > Do you use the the same workbook for all users and they create their
> > > worksheet in the same book?
> > >
> > > The latter may see concurrency issues on the XL file.
> > >
> > > --
> > >
> > >
> > > Allan Mitchell
> > > http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
> > > http://www.konesans.com
> > >
> > >
> > >
> > > "MIB" <MIB@discussions.microsoft.com> wrote in message
> > > news:16EEFA43-72AC-470A-9754-735CF2731C0F@microsoft.com:
> > >
> > > > Hi,
> > > > I have to construct on Excel a worksheet, where users can write data on
> > > > table. When they finish, they have to press a button. This button is calling
> > > > a SSIS package on the server. What is the best way to proceed if i have many
> > > > users?
> > > > Thanks
> > >
> > >
>