Where using a SSIS 2005 pkg

Question

Hi,

I need to put a SSIS 2005 pkg into this production environment: web server that can access to a SQL Server in cluster; on the web server it's not present SQL Server 2005.

Any suggests to me, please? Thanks

Answer 1

Hi,

SSIS 2005 packages have to be deployed ("installed") to the production server running SQL Server Integration Services (2005).

SSIS 2005 often (but not always) runs on the same box as SQL Server 2005.

Ask your system administrator where are SQL Server Integration Services 2005 running and deploy your packages there

---

Sebastian Sajaroff Senior DBA Pharmacies Jean Coutu

Answer 2

You'll need to install Integration Services on the web server.

---

Chuck Pedretti | Magenic – North Region | magenic.com

Answer 3

Is it possible to import the SSIS pkg into the SQL Server in Cluster?

Thanks

Answer 4

Yes, assuming that SQL Server Integration Services (SSIS) is running as a "clustered" service

---

Sebastian Sajaroff Senior DBA Pharmacies Jean Coutu

Answer 5

SSIS is not cluster aware

---

Chuck Pedretti | Magenic – North Region | magenic.com

Answer 6

You could also run the SSIS package on the SQL Server, triggered by the web server by using sp_start_job to start an Agent Job that runs the package.

---

Talk to me now on

Answer 7

Hi, Todd, your suggest is interesting, but I don't need to run automatically the SSIS pkgs.

Some minutes ago, my hosting provider told me that SSIS isn't present on the cluster (SSIS isn't cluster aware). So I think that I'm constaint to install SSIS licensed. Does it exist any free installation for the dtexecui.exe or dtutil.exe?

Thanks

Answer 8

Hi, Todd, your suggest is interesting, but I don't need to run automatically the SSIS pkgs.

Some minutes ago, my hosting provider told me that SSIS isn't present on the cluster (SSIS isn't cluster aware). So I think that I'm constaint to install SSIS licensed. Does it exist any free installation for the dtexecui.exe or dtutil.exe?

Thanks

No, there is no production usable free version of the dtexecui.exe / dtutil.exe

---

Chuck Pedretti | Magenic – North Region | magenic.com

Answer 9

Hi,

We're running SSIS 2005 and SSIS 2008 R2 on a Veritas Cluster Environment. It runs pretty well, though there are several manual steps to be

done after the basic install.

Here are the instructions for MS Clusters

http://technet.microsoft.com/en-US/library/ms345193(v=sql.90).aspx

---

Sebastian Sajaroff Senior DBA Pharmacies Jean Coutu