I currently have logging enable on several of my packages.
However, we are still in development of our packages and are reaching upwards
of 100 and logging will eventually need to be active on all of them. In
production, there will still be a development server and a production server,
both with different server names and user id/pwd.
I am looking for a way to dynamically change the logon information for the
logging so that we do not have to have someone go through and manually change
the options. I have tried using Dynamic Properties Task, but this only works on
the 2nd run of the package.
--
As a second question: can anyone explain to me why the errordescription field
in sysdtssteplog is cut short?
Here's the DTS forum:http://groups.google.com/group/microsoft.public.sqlserver.dts/topics?lnk=srg
