Solved

How to Upload dtsx to SQL Server 2005

Posted on 2008-06-12
5
1,557 Views
Last Modified: 2013-11-26
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
0
Comment
Question by:kchoed
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 13

Expert Comment

by:rickchild
ID: 21777010
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
 
LVL 1

Accepted Solution

by:
sqlconsumer earned 200 total points
ID: 21777025
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
 
LVL 13

Expert Comment

by:rickchild
ID: 21777065
That was mentioned in the last paragraph as the easy alternative ;-)
0
 
LVL 1

Expert Comment

by:sqlconsumer
ID: 21777077
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
 

Author Closing Comment

by:kchoed
ID: 31466800
Really Thanks Experts, it's useful
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question