Solved

Job with SSIS in sql2005

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
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.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

895 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

17 Experts available now in Live!

Get 1:1 Help Now