Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error When Saving DTS

Status
Not open for further replies.

eusjyfy

Programmer
May 9, 2003
3
US

Hey,
I am new to SQL Server, so please forgive my ignorance. I created a DTS package and saved it without issue. I then went back in and added a VB Script to the package. When I try to save, I get the following error:

Error Source: Microsoft OLE DB Provider for SQL Server

Error Description: Could not allocate space for object 'sysdtspackages' in database 'msdb' because the 'PRIMARY' filegroup is full.

Has anyone else experienced this, and how can it be fixed?
BR,
Jeremy
 
Is the msdb database set to Auto Grow? If not, change the option to allow Auto Growth.

If Auto Grow is on, check the amount of available disk space on the drive containing the database file.

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top