SSIS package in a cluster, failing on Server Name but not ..

External Since: Nov 15, 2007 Posts: 5

Sorry for the repost... thought it better to put in a message of its own...

We have installed SSIS in a cluster.

We have a test package setup, however when we go into the properties for the package, go into Steps and on the General tab, under Server: we enter the Server Name, the package fails, but when we enter the IP address the package runs...

We need to have the server name and not the IP address, any ideas as to what the problem might be?

From http://www.developmentnow.com/g/99_0_0_0_0_0/sql-server-clustering.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com

External Since: Feb 23, 2005 Posts: 443

See if this helps any:
http://weblogs.sqlteam.com/geoffh/archive/2007/10/04/To-Cluster-or-Not...-Cluste

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP

"Chris" wrote in message

> Sorry for the repost... thought it better to put in a message of its
> own...
>
> We have installed SSIS in a cluster.
>
> We have a test package setup, however when we go into the properties for
> the package, go into Steps and on the General tab, under Server: we enter
> the Server Name, the package fails, but when we enter the IP address the
> package runs...
>
> We need to have the server name and not the IP address, any ideas as to
> what the problem might be?
>
> From
> http://www.developmentnow.com/g/99_0_0_0_0_0/sql-server-clustering.htm
>
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com