Hello:

I have a WEB.NET 2003 program service. This service lets me check if a
file exists in the hard disk of the server, if this is true a need to
execute some packages that read text file and bring the information to SQL
tables. Currently, I have structured storage file created, but the problem
is my application needs to b taken to other servers, so the connection
needs to be change!!

My question is, all the time I need to add the reference and add the
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\dtspkg.dll

and follow the steps to create the Strong name key and the wrapper related,
or there's another way to do it???

-How portable can be the packages created as SQL SERVER, I mean if the
database is scripted, are the packages scripted too, as aprt of the objects.

Thanks

DTS packages are portable yes but remember their info will not
dynamically change simply because you moved it so if a connection points
to ServerA whilst the package sits on ServerZ when you move it to
ServerX the package will still be pointing to ServerA


Transferring DTS Packages
(http://www.sqldts.com/default.aspx?204)



"Gina Hernandez" <ginah (AT) wdsinc (DOT) com> wrote