Run SSIS without Installing SQL Server

[AccessHelp123]

Hi,

I am trying to create a tool in Excel(VBA) which exports data(in excel & txt files) to SQL Server. If the users do not have SQL Server installed on their computers, is there any way they can run an SSIS package?(through excel or otherwise). Appreciate any help.

 

[MDXer]

they can execute it by commandline using dtexec but they have t have the dtexec utility loaded on their machine.

I would be careful about letting anyone run an import job. You can get into all kinds of issues. For example if you have a bit column and the file has a value of Y. You have to be sure you are checking and handeling all possible data issues.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[SQLSister]

Personally I would not allow users to directly import to tables. They don't understand what they are doing well enough to avoid destroying the database integrity. Also you do not want to give them direct rights to tables ever for security and internal control reasons.

If I was stuck with such an awful task, I would have them create the txt file and put it in a location and then schedule an SSIS job that I wrote to look in that directory and process the file. I would make sure it had lots of failure handling. Depending on how often there should be a file would be how often I scheduled the job. Often once a night is acceptable. Or you might need it to run hourly.

"NOTHING is more important in a database than integrity." ESquared