May 18, 2011 at 8:18 am
I have a SQL Database, I recenrtly inherited the responsiblities. SQL Server 2008; I have some .dtsx files i think were created in SQL 2005. I'm new to SQL server. I would like to know how these files relate to some SQL Server Agent Jobs that calls these packages(.dtsx).
Example:
/****** Object: Step [tmpAimsAll] Script Date: 09/09/2009 13:51:58 ******/
EXEC @ReturnCode = msdb.dbo.sp_add_jobstep @job_id=@jobId, @step_name=N'tmpAimsAll',
the previous command is within a Agent Job, that creates an error
Please help and/or lead in correct direction
Thanks
May 18, 2011 at 11:32 am
Think of them as programs that are called by Agent. To know what they do you wil have to look at their code. Sometimes the packages are stored IN the server, sometimes on the file-system. Either way they are just programs. What is the error you are getting because the fragment you showed is the part that adds a job step to a job..
CEWII
May 18, 2011 at 5:47 pm
Well to figure out what your server is doing you'll need to look at the jobs configured in SQL agent and find out which packages they're running. Like the previous poster said they can either be stored directly in SQL server or stored .dtsx files, which you seem to have for some of your jobs.
To figure out what the packages are doing you would need to open the packages in Visual Studio and review them. If they're password protected hopefully the previous developer left you the password(s).
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply