Solved

Job with SSIS in sql2005

Posted on 2008-06-18
3
306 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
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.
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

623 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