Any idea how to over come this error ?

Question

Any idea how to over come this error ?

mw_sql_developer

SSCoach

Points: 19445
More actions
April 7, 2016 at 11:06 am

#325529

While running an ssis package , I get this error..
[Execute SQL Task] Error: Executing the query
"exec [dbo].[sp_visits_modified_for_execution] @Run..." failed
with the following error: "Could not allocate space for object
'dbo.VISIT_IN'.'PK__VISIT_IN__38EB8C970A7378A9' in database
'TierMedTest 2016' because the 'PRIMARY' filegroup is full.
Create disk space by deleting unneeded files,
dropping objects in the filegroup, adding additional files to
the filegroup, or setting autogrowth
on for existing files in the filegroup.".
Possible failure reasons: Problems with the query,
"ResultSet" property not set correctly, parameters not set correctly,
or connection not established correctly.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Luis Cazares SSC Guru Points: 183706 More actions · Answer 1

mw112009 (4/7/2016)
While running an ssis package , I get this error..
[Execute SQL Task] Error: Executing the query
"exec [dbo].[sp_visits_modified_for_execution] @Run..." failed
with the following error: "Could not allocate space for object
'dbo.VISIT_IN'.'PK__VISIT_IN__38EB8C970A7378A9' in database
'TierMedTest 2016' because the 'PRIMARY' filegroup is full.
Create disk space by deleting unneeded files,
dropping objects in the filegroup, adding additional files to
the filegroup, or setting autogrowth
on for existing files in the filegroup.".
Possible failure reasons: Problems with the query,
"ResultSet" property not set correctly, parameters not set correctly,
or connection not established correctly.

Cause of the error on italic

Possible solutions on bold

Other option is that you ran out of disk space and need an additional disk.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2