How to Upload dtsx to SQL Server 2005

Hi Experts,

I have created the dtsx using Business Intelligence Development Studio , and then, could you please advise how to put it on to the SQL Server 2005, and then schedule it to start this SSIS in a particular time ?

Thanks
kchoed
kchoedAsked:
Who is Participating?
 
sqlconsumerCommented:
You don't have to upload the package to the server but just reference it in a job task.

From the SQL Server Agent create a new job and give it a name. In the steps tab create a new step.

In the 'Type' drop down select 'SQL server integration services package'.

In the 'general' tab change the selection to 'Package Source' to 'File system' and then reference your package using the 'Package:' browse button.

Hope this helps.
0
 
rickchildCommented:
One method is you can create a Deployment package to help you load the SSIS into the server.

In Visual Studio right click on the project (In Solution Explorer) and choose properties.
Go to Deployment Utility and change CreateDeploymentUtility to True.

Now when you Build the project there will be a file called ProjectName.SSISDeploymentManifest
Double click this and it will run a wizard to help deploy the package to the server.

To Schedule a job go Managemnt Studio -> SQL SErver Agent -> Jobs and create a new job.
For your job step choose Type "SQL Server Integration Services Package"



An easy alternative is just go to the job, choose step "SQL Server Integration Services Package" and then choose Package Source "File System" instead of SQL Server.  You can then choose the .dtsx.
0
 
rickchildCommented:
That was mentioned in the last paragraph as the easy alternative ;-)
0
 
sqlconsumerCommented:
Yeah I know we answered the question at exactly the same time, check out the DATE TIME stamp.

Your just a bit quicker typing than me. ;-)
0
 
kchoedAuthor Commented:
Really Thanks Experts, it's useful
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.