Solved

Job with SSIS in sql2005

Posted on 2008-06-18
3
302 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
[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
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 500 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

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
execute a MS SQL script as a schedule SQL job 72 157
CROSS APPLY 4 69
Database Mail Profiles 1 52
Trying to understand why my Index is so large 12 52
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
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.
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

752 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