.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Securing DTS Packages

Posted By:      Posted Date: September 01, 2010    Points: 0   Category :Sql Server
We have a requirement as follows to Secure DTS Packages in Production environment. Users should be able to ONLY VIEW DTS packages and their Properties Means they should be able to OPEN the package BUT Should NOT Be able to EDIT, SAVE, EXECUTE DTS Packages.. Is  there any security setting which we can implement w/o creating Owner and User Passwords to have this kind of security in Place ..? Please help !!! -Sneha

View Complete Post

More Related Resource Links

Silverlight Security: Securing Your Silverlight Applications


Josh Twist explains the unique challenges developers face in securing Silverlight applications. He shows where to focus your efforts, concentrating on the key aspects of authentication and authorization.

Josh Twist

MSDN Magazine May 2010

Foundations: Securing The .NET Service Bus


This column shows you how to secure the .NET Services Bus and also provides some helper classes and utilities to automate many of the details.

Juval Lowy

MSDN Magazine July 2009

Service Station: Securing Web Services with WSE 2.0


Beginning this month, The XML Files will run under the name Service Station. We have made this change so that the column can discuss broader topics such as Web services, service-oriented architecture, and the like.

Aaron Skonnard

MSDN Magazine October 2004

Securing my service

Hi guys, Can you please help me out.  I have a .NET4 WCF Service which I have deployed and is working fine over HTTP.  I have purchased an SSL certificate for my website and would now like my service to be over HTTPS.  Can someone please advise what little addition I need in my website config file to get this working. I have changed my client application to use https://domain/service and changed the endpoint in the client app to use transport security but it is says no endpoint is listening, I have also tried serviceMetadata httpsGetEnabled="true" httpGetEnabled="false".  I think I need to setup the https endpoint in the website config but since things seem to be have been simplified and there is less in the config than there was for WCF previously I need some guidance. Thanks for your help. John  

Transactions in SSIS packages

Hi guys - I've been working in ssis for a bit but never have encountered the need for transactions - until I realized that I really need them. Here's my setup. I have a master package that has a sequence container in it. In that sequence container are 3 execute package tasks (Insert - Update - Delete). Each execute package task points to a child package which contains 50 execute package tasks (to perform the tasks on my different tables). From there - the actual work is done. (default everything on transaction/isolation etc) My problem/question is that I need to make it where if the insert fails, the update/delete do not happen and everything gets rolled back. Right now if something fails it just stops there and gives me half changed records. Is there a way to do this or am I just hoping for un-doable? Thanks!

Need Best Practices for SSI packages (dtsx-files + ONE config)

Please advice hot to keep connection string for many packages at one place. Idea is to have one .dtsConfig-file for each iteas is not acceptable. DEV, TEST and PROD - different virtual computers. Each one can have it's own config-file lying in one and the same folder (c:\bi\configs\)

Securing ky digital media cd From Copying

Respected People, I M here to ask u a question.i am going to explain the problem.i have created a installer class using vsstudio 2008.it is window application using C#.net Now when i install the msi on the client computer every thing is fine amd my application runs ok.But the problem is any one can copy the taarget directory from installed folder and put it on the other machine and literaaly my application start running .soi want to avoid suh situtation i not getting any hin t how to stop this whether to register my apllcation dll in gac or is there any other way u can describe nme   thanx in advance

Issues with running SSIS packages programmatically

Hi, I have spent days trying to solve this problem and still stuck with this and I have posted some questions already in forums, but didn't get satisfactory answers. I am trying to be more clear this time and hope to get a better answer. I have gone through this article already http://blogs.msdn.com/b/michen/archive/2007/03/22/running-ssis-package-programmatically.aspx and here are my issues (I need to run the SSIS package from ASP.NET) option 1 is not suitable for me, because it may recycle worker process if it consumes memory option 2 is also not suitable because of security issues in creating a new process and passing the context to new process looks very complicated for me (according to the support article) option 3 is not suitable because using SQL Server Agent to run SSIS package is not allowed by the company I am working for(I guesss it requires installation of db engine on application server, not sure). but SSIS is installed on the application server. option 4&5 will have the same issues as options 1&2. I guess the only option left now is to create a windows service and start the service from ASP.NET. but will this allow running multiple packages in parallel? OR is there a better alternate solution for this? please let me know. Thanks.

What is Better Approach (Have Single Package or two Packages)

Hello, I want to design a package that will have 2 parts (2 parts of data flow). The package will be executed by scheduled Agent JOB. One part (DFT) should load data daily while the second part should load weekly. So I am thinking of 2 approaches: 1) Design 2 packages - one for each and have 2 Jobs scheduled accordingly 2) Design one package and use constraint to check current date/day. Execute first part and if this is Sat then the second DFT. Please advise. Thanks, Prabhat

Propagating Logging Details from child packages to parent packages

From MSDN I found the following: "The child package that the Execute Package task runs may or may not be configured to use logging, but the child package will always forward the log details to the parent package. If the Execute Package task is configured to use logging, the task logs the log details from the child package." It appears this only works one level deep.  My parent package is receiving log details from its child, but not from its grand child (package that the child executes).  How can I get the parent to receive log information all of its decendants?

Reg deployment of solution packages in SharePoint 2010 from MOSS 2007

Hi, Earlier we have developed some custom web parts,features and deployed into the site through solution package(wsp files) when customer was using MOSS 2007.Now customer is migrating all sites into SharePoint 2010.Now my query is can i use the same solution to deploy into the site through Central Admin of SharePoint 2010 or is there any seperate process for that? Thanks & Regards, Sudheer

Folders or folder like equivalent in SQL Server 2008 ? for packages & stored procedures ?

Hi,      Currently running SQL-Server 2000.  We have hundreds of stored procedures and DTS packages. We have so many it's becoming a serious challenge for names and such.  We were wondering if SQL Server 2008 has a way to 'nest' both the equivalent of DTS packages (SSIS) and stored procedures in something akin to 'folders'.  We know we have to upgrade one of these days but a version that would handle these would be much more attractive. Just getting this functionality would be worth whatever effort would be required to upgrade.   Thanks in advance for any help on this.

SQL Server 2000 Enterprise Manager no longer displays DTS packages

SQL Server 2000 Enterprise Manager no longer displays DTS packages and the SQL Server Agent jobs that use the DTS packages now fail. The affected servers are running Windows Server 2003 SP2 and SQL Server 2000 SP4 and all update patches for both the OS and SQL Server. The DTS packages are ActiveX scripts that read data from a database table and output that data to a text file on the same server.  They include the database connection string and the SQL account used by the connection string has not changed. I've determined that the DTS packages still exist by trying to re-create them with the same name, but they don't appear in the Local Packages window and they no longer function when the scheduled job that uses then runs. The SQL Server Agent Job error is as follows: Executed as user: <server admin user account>. DTSRun: Loading... Error: -2147467259 (80004005); Provider Error: 11 (B) Error string: [DBNETLIB][ConnectionRead (recv()).] General network error. Check you network documentation. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context 0. Process Exit Code 1. The step failed. The job has working perfectly for the last 5 years, until about a week ago when it started failing. I have two other servers with the exact same configuration running the same DTS packages and job that still work and the DTS packages show up in Enterprise

upgrade/rebuild wss3.0 'wsp' packages to sharepoint 2010 compatiable

Dear All, I would like to rebuild/upgrade the source code given in the following links as SharePoint 2010(64 bit) compatible. Though, I opened solutions in Visual studio 2010 but in the build tab I am not getting 'package' option to rebuild. Kindly let me know the procedure to create 64-bit WSP package for the below source codes. http://sppex.codeplex.com/SourceControl/list/changesets ; http://spgooglemap.codeplex.com/SourceControl/list/changesets ; Thanks

How to merge SSIS packages

Hi Guys, Is there any way to merge changes into SSIS package under version control. It's a plain XML, which is easy to merge, but it's also quite easy to make the package invalid. Would appreciate any ideas. Thanks, V.

Best Practice to deploy update packages on a production ASP.Net solution

Hi guys, I've a production web site.  It was deployed/installed using a standard MSI project.  But now, I'll like to create a kind of MSI package containing only those components affected during a fix.  Everytime I fix something in the solution, I've to manually copy/paste all modified components (ascx,aspx,dll, etc) to the web server.  Of course, I've a staging area from where I can validate that my package is completed and I'm not missing anything.  But I'll like to avoid this manual-risky-prompt-error process.  That way my fixes packages will looks more professional and I could even have our web manager deploying fixes on this production box. What folks do to deploy fixes? Any ideas? Thanks.  

Securing files using Handler and App_Data folder

HiI have secured some files on my webserver by putting them into the App_Data folder in the root (I do not have the option to secure folders using the ASAPI filter)The user gets access to these files by requesting them through a handler, fx. by requesting ~/Handler.ashx?file=App_Data/MySubFolder/MyFile.jpgNow, I want to make all the content in a specific folder called "Members" (a single subdirectory of the App_Data folder) available only by passing a specific password. That is by requesting ~/Handler.ashx?file=App_Data/MySubFolder/MyFile.jpg&password=xxxxIn my Handler.ashx I have written some logic seeking if InStr(context.Request.QueryString("file"), "Members") = 0 before sending the file. If inStr <> 0 a password is required.Is this a good way to secure a folder in and its content? Is there a way of getting access anyway, like using some kind of "sub-directory" line in the path (the same way as you can request parent directory by using "../../Myfile.jpg)? I know there will be a problem if someone fx. legitimately tries to access the file App_Data/Members.jpgThanks in advance!-Jesper
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend