Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Job with SSIS in sql2005

Posted on 2008-06-18
3
Medium Priority
?
313 Views
Last Modified: 2011-10-19
I looked at job properties and found its under Type=Sql server integration packages, my question now where can I edit this SSIS properties??


dts-packages.bmp
0
Comment
Question by:motioneye
  • 2
3 Comments
 
LVL 15

Expert Comment

by:rob_farley
ID: 21820191
To set various properties at runtime, use either Configurations or the "Set Values" tab in that bottom section.

But to edit the DTSX file itself, open it in SQL Server BI Development Studio.

Rob
0
 

Author Comment

by:motioneye
ID: 21853400
I open up the dtsx file, but its only a code without having any icon, I'm expecting something like a dts packages where we can see icons and tasks, so how should I open this *.dtsx in business intelligent studio?
0
 
LVL 15

Accepted Solution

by:
rob_farley earned 1500 total points
ID: 21854403
You should be able to create a project using the template Integration Services - then add an Existing Package to it.

Rob
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…

916 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