May 28, 2009 at 11:52 am
is it possible to somehow track changes made to any SSIS packages stored in SQL Server? if it is then how can it be implemented?
thanks
May 28, 2009 at 1:32 pm
There is the source control option from within business intelligence studio - but its not part of SQL Server - that would be the obvious choice for tracking.
SSIS Packages deployed to a server just seem to be held as dtsx files in
\Program Files\Microsoft SQL Server\90\DTS\Packages
The [SSIS Configurations] table seems to contain only data to run the package, so possibly no use in tracking changes.
I tried importing a file system dtsx package, and it did sucessfully become an MSDB package, from where you can track it on the msdb.dbo.syddtspackages90 table (add a trigger to the table to write a history - but I'm not sure how useful this would be as the package data is in a binary field)
So the short answer is there is no obvious or easy way within SQL Server.
March 24, 2010 at 6:34 am
Hi Tom,
I'm new to SSIS, and I had one QUERRY, May I ask you?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply