Reed Me

Development schtuff, SQL Server & other random geekness. Now with more [fill in the blank]!

Need to Renumber All Your Packages?

Need to Renumber All Your Packages?

  • Comments 1

If you do quasi-template driven development for Integration Services packages, you might find yourself in a situation where you suspect that your problems stem from concurrently executing packages that share the same GUID value for package ID. When that's the case, you'll probably want an automated means to do this instead of manually cracking them all open, right? Well, here it is (buried in the Support Knowledge Base):

for %%f in (<FilePath>\*.dtsx) do dtutil.exe /i /File %%f

Pasted from <http://support.microsoft.com/kb/906564/>

Enjoy!

Leave a Comment
  • Please add 3 and 4 and type the answer here:
  • Post