Showing posts with label packages. Show all posts
Showing posts with label packages. Show all posts

Monday, March 26, 2012

I wrote my own configuration tool to maintain the connection strings in a SQL table

I wrote my own VB app to maintain all of my connection strings and link them to packages. I then grab them at run time and set them as variables in memory.Sorry this was suppose to be a reply not a new post.

Wednesday, March 21, 2012

I want to install SSIS on a 64 bit server without SQL Server on it

I want to install SSIS on a 64 bit server without SQL Server on it.

Say I want to install the SSIS engine on one server and have it call packages stored on another servers msdb.

It this possible?

Yes. It does require a SQL license for the server with SSIS on it, as well as the server with the database engine.