I am sysadmin user on a database server for SQL Server 2005.
I need to change the connection string that use 'sa' to another account. But I don't know how to change the data manager connection for the package 'XYZ'.
How can I allow non-sysadmin users to create/edit a SSIS package? Do I need to give special permissions?
View 6 RepliesI installed ASP MVC 3, but when I go to tools I can't see the Library Package Manager, it was supposed to install along ASP MVC 3, how come I cannot see it?
View 2 RepliesIm trying to build a deployment package out of VS2010 against a web project and want to include all IIS settings as configured in IIS Manager. However when i enable this i get the following error message
Object of type 'manifest' and path
[code]...
Now this error makes very little sense as the specified application does exist in Default Web Site. I've checked the spelling. I've tried having ISV as a virtual directory and as an Application and tried with and without the ISV folder.
On the Web page i hae the Project URL set to [URL] On the Package/Publish tab IIS web site name is set to "Default Web Site/ISV/Web.Crm.Framework/"
Bing/Google search turn up very little on this and the documentation is not really detailed enough.
I am trying to update NuGet Package Manager from ver.1.0.11220.104 to version 1.1.229.160 using the VS extension manager, but the install fails on VS2010 Ultimate Version 10.0.31118.1 SP1Rel because of a signiture mismatch; see error below.
[Code]....
What is your opinion on allowing administrators to update the SQL Server Connection string dynamically from the application versus just showing them the connection details in the application? Because the database connection is so important and on a heavily used system the abrupt change to the connection seems like it could cause problems. However I would think displaying the server and catalog and whether the connection is using SSPI or SQL Auth could be helpful for administrators who don't like playing with .NET config files.
View 4 Repliesi don't know how to use a Encrypted ConnectionString with RoleManager in ASP.NET This is code in Web.config.
<connectionStrings>
<add name="strConnectionString" connectionString="eF8w9r2UJOsk0Ps3pxmV7/Fy/xPR2hN2S7BrC1iOYNnAUaI8AqkSm5bw7r+ta4sePWSV9t/3Spnpz6wsFpvMmcppNpqM5Zk7iiDqWVgIV4k="/>
</connectionStrings>
<roleManager enabled="true" defaultProvider="CustomizedRoleProvider">
[Code] ....
And in project I create a library to read web config
private const string ConnectionStringKey = "strConnectionString";
private readonly string SQLConnectionString =
Security.DecryptString(ConfigurationManager.ConnectionStrings[ConnectionStringKey].ConnectionString);
if I change my ConnectionString like this, it's working:
<add name="strConnectionString" connectionString="server=My-PCMSSQL2008; database=MyDB; uid=sa; pwd=passw0rd;"/>
But I want my ConnectionString Encrypted so i use
<add name="strConnectionString" connectionString="eF8w9r2UJOsk0Ps3pxmV7/Fy/xPR2hN2S7BrC1iOYNnAUaI8AqkSm5bw7r+ta4sePWSV9t/3Spnpz6wsFpvMmcppNpqM5Zk7iiDqWVgIV4k="/>
So when i running website it throw error:
System.ArgumentException:Keyword not supported: 'eF8w9r2UJOsk0Ps3pxmV7/Fy/xPR2hN2S7BrC1iOYNnAUaI8AqkSm5bw7r+ta4sePWSV9t/3Spnpz6wsFpvMmcppNpqM5Zk7iiDqWVgIV4k='.
Line 46: string[] roleNames;
Line 47: roleNames = Roles.GetAllRoles();
[URL] .....
I have an error with this tutorial.
Line 13:
Line 14: Private Sub BindGrid()
Line 15: Dim constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
Line 16: Using con As New SqlConnection(constr)
Line 17: Using cmd As New SqlCommand("Customers_CRUD")
Imports System.Data
Imports System.Configuration
Imports System.Data.SqlClient
Public Class tessatusatu
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
[Code] ......
I downloaded and installed VS 2010 Ultimate as a trial and I received "sucessful" message at the end of the installation.
But when I opened VS 2010 Ultimate I received this warning "The 'Visual Studio HTML Editor Package' package did not load correctly.' error message".
The next thing I know is that all the Toolbox icons are grayed out (I tried to create a .NET web application). There is no design/split pane.
I have been trying to install VS 2008 profesional in my computer, I am getting this error "Package Visual Web Developer HTML source editor package has failed to loas properly GUID = BFCC0C3C-6F87-4285-A6C8-BB1606180OD Please contact package vendor for assistance, application restart is recomended , due to possible environment corruption.
View 7 Repliesi am having a problem. i want to get info on a package from database and get the software linked to that package.. my db looks like this.
[Code].....
We have a DNN site and we use the AJAX Toolkit. We upgraded from AJAX 30930 to 40412. We changed the script manager to a ToolkitScriptManager. I have a image button that posts back and calls a modal popup.show() method. When I click the button I get
a javscript error before the post back:
Error: Sys.WebForms.PageRequestManagerServerErrorException: This version of MicrosoftAJAX does not offer the ScriptManager.RegisterClientScriptBlock method.
I just installed sql server 2008 R2 on my computer. I am trying to connect to sql server throught my C# code and everytime I run the C# program,
I get this error "A network-related or instance-specific error occurred while establishing a connection to SQL Server.
The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) "
The connection string that I used in my web.config file is
[Code]....
I am not sure what am I doing wrong, but I followed this article below step by step and still I am getting the same error
http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/
My instance name is MSSQLSERVER and the server that I am using is on my local machine and it has my computer name in it.
I'm looking for any and all information on how to execute an SSIS package from my asp.net web site. I have written the call and when I run the application from (Localhost) it works, but when I run it from the server it does not.
Here is my code to call and execute the package:
[Code]....
Again this works from my local machine running from localhost, but not from our live server. I have turned on impersination to see if that worked and still getting the same result. The file is written successfully to the server without issue, but I'm just lost.
Migrating SSIS package from SQL Server 2005 to SQL Server 2008
View 1 RepliesHow can convert DTS package from SQL Server 2000 to SQL Server 2005
View 2 RepliesCan a SQL Server 2000 DTS Package be run from a Web application?
If so, what permissions, SQL Server roles, etc. are required?
I've been only able to find examples of Windows and VB applications.
I would like an example of a Web application (written in C#/VB.Net).
I am running into a problem trying to open a SQL Server 2000 DTS package I imported into SQL Server 2008. I set up a new server and installed a fresh install of SQL Server 2008. The database I need to run is a SQL Server 2000 database. I moved the database over with no problem but there are a few DTS packages that need to run in legacy on SQL Server 2008. I exported the DTS packages I need out of SQL2000 and imported them successfully into SQL Server 2008. My SQL Server 2008 is x64.
I can see the DTS packages under Data Transformation Service in Legacy but when I try to open the package I get this message. "SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special web download, "SQL Server 2000 DTS Designer components" to use this feature. (Microsoft.SqlServer.DtsObjectExplorerUI)"
I downloaded the components and installed them and still get this error. I researched and found an article about this not working on x64 so I have an x86 machine that I installed the SQL Server 2008 tools and tried to open the package from there and got the same error.
Sql server 2005 is already installes in my machine.., i want to use SSIS now.where can i download SSIS package as add on to sql server 2005.
View 5 RepliesWe have built an ASP.NET application in 4.0 (we can change it to 3.5 if necessary) with a SQL Server database.
I am looking to create an installation package (exe or msi) so that I can provide this file to my clients and they can install it on all of their laptops. This asp.net application will be running on laptops that don't have access to the internet. Some of these laptops have XP Home, Win 7 Home, and other windows operating systems and not all of them have IIS installed. Is there some sort of simple application that I can use to create an Installer application where it will install IIS or some other web server, SQL Express, and .NET framework 4.0. If these applications are installed already, then it shouldn't install it.
I have recently decided to dive in to ASP and have set up a Windows Server package on my resellers account (shared hosting).I'm from a largely PHP background and haven't touched ASP since, well, tonight.I created a new file in Dreamweaver (hey, I like the colourful syntax) and was presented with a choice of filetypes:
[code]...
Created SSIS package, it runs fine I import it into Stored packages in Integration Services, I right click and click "Run Package" it runs fine Create a new job to run the package and I get errors
The package runs an Execute Package task. That seems to be where the errors occur. But it runs fine in all circumstances except from a "job".
Note: ALL THE ERRORS ARE IN TASKS THAT CONNECT TO A REMOTE SERVER.
[code]....
SSIS package is running successfully and the db table is not populating in sql server.I am using csv file to populate datas to database tables.
I am using flat file source and oledb destination in data flow in ssis.
I'm trying to run my SSIS packages as a step inside a sql agent job.This runs normally when the package uses the SAME database as used to create my job.The problem occurs if I create a job to run the package and this package must execute queries in another database. Probably authentication problem. So how to authenticate my package and the job runs normally ?
View 1 RepliesI have a scenario in which user having a collection of comma delimited (txt) files in a folder.
He wants to insert all files data to sql server using dts package.
Dts package is already created with all details.
Our requirement is dts should read all file one by one and insert all files records into database.
Comma delimited file format is same for all files. For etc
Name, id, roll no, address, city, phone, pin,
Records.
Test, 01, 0001, bandra, Mumbai, 9898989898, 400410
how to read a comma delimited file and transfer each file records into sql server using dts package through asp.net and vb.net/c#.