Solved

Job with SSIS in sql2005

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

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 14

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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

747 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now