Enterprise ETL "Appliance"

At least one company has developed such a product. Here's a link: http://www.dataintegrityinstitute.com/copula.htm

I am interested to read your thoughts on this.

DISCLAIMER: I don't work for the aforementioned company and don't benefit from them in any way.

this website looks suspicious to me. sry, i don′t think these guys are reliable.|||Duane,
Please tie this post back to SSIS, or it will get deleted. This is an SSIS forum, not a bulletin-board.|||

Phil Brammer wrote:

Duane,
Please tie this post back to SSIS, or it will get deleted. This is an SSIS forum, not a bulletin-board.

Ok. My understanding is that ETL appliances are the wave of the future and that many of these devices work with ETL software tools. Considering that SSIS is an ETL software tool, I am curious as to whether SSIS can work in tandem with such devices. In as much as this is a forum dedicated to SSIS, I believe that any discussion regarding the role of SSIS in the marketplace is indeed relevant to this forum. Since many of the people who visit this forum work in an ETL capacity, I believe that this topic would be of considerable interest to them. I believe that this forum wasn't intended to be strictly focused on SSIS. But rather that this forum was intended to serve an audience who are interested in using SSIS in their overall technical solutions.

If you disagree with anything that I've stated, please feel free to post a reply to that effect.

Enterprise ETL "Appliance"

At least one company has developed such a product. Here's a link: http://www.dataintegrityinstitute.com/copula.htm

I am interested to read your thoughts on this.

DISCLAIMER: I don't work for the aforementioned company and don't benefit from them in any way.

this website looks suspicious to me. sry, i don′t think these guys are reliable.|||Duane,
Please tie this post back to SSIS, or it will get deleted. This is an SSIS forum, not a bulletin-board.|||

Phil Brammer wrote:

Duane,
Please tie this post back to SSIS, or it will get deleted. This is an SSIS forum, not a bulletin-board.

Ok. My understanding is that ETL appliances are the wave of the future and that many of these devices work with ETL software tools. Considering that SSIS is an ETL software tool, I am curious as to whether SSIS can work in tandem with such devices. In as much as this is a forum dedicated to SSIS, I believe that any discussion regarding the role of SSIS in the marketplace is indeed relevant to this forum. Since many of the people who visit this forum work in an ETL capacity, I believe that this topic would be of considerable interest to them. I believe that this forum wasn't intended to be strictly focused on SSIS. But rather that this forum was intended to serve an audience who are interested in using SSIS in their overall technical solutions.

If you disagree with anything that I've stated, please feel free to post a reply to that effect.

Enterprise Deployment of SSIS

Hello, we are interested in upgrading our Data Warehouse environment to SQL Server 2005 to take advantage of SSIS. Our current data warehouse environment consists of 2 production servers with over 900 DTS packages between the 2 servers.

Are there any white papers out there detailing what type of deployment works well for an Enterprise wide use of SSIS? We're trying to determine if we should use SSIS on the same server hosting our databases, or separate SSIS onto its own dedicated box. If we went the dedicated route, what type of horsepower would we need on the SSIS box (procs, RAM, etc.)? Also, if we went the dedicated route, does it make sense to have 1 SSIS server that handles the data warehouse packages and the OLTP packages, or should that be separated into 2 SSIS servers having one server for each environment?

Thanks for any help you can provide on this subject!

Eric

the 32 bit version of ssis can use a maximum 3 GB of RAM. because of this limitation, i recommend using the 64 bit version instead (if possible).