Can 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 want to ask the following:
Does anyone have an example of some code which executes an SSIS package from a ASP.NET web app using VB.NET?
I have built a web application and want to be able to execute the SSIS package when the user clicks a button on the web page.
So far I have:
[code]....
I need to know how to set this up so it runs remotely. I have searched MSDN (useless), [URL] and sqlservercentral.
I have a jar file exporting some functions which i want to use in my asp.net application. How can i achieve this? Will anything change if i use it in an windows azure application?
View 1 Replies 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 Created msi installer for my web application with the help of the following link. [URL] But when I insall application using this installer into my IIS under root dicrectory I can see my .cs files also. How to remove these .cs files from msi installer. ( I am using VS2005).
View 1 RepliesI 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].....
'm in need to create a custom installation package that I can distribute to my clients, where the installation of ASP.NET web applicationwould be as automated as possible. To do this I'm looking for custom install that has the following capability:- Copy and deploy files to desired location- Create a virtual application on the IIS- Connect to the SQL server and create the SQL database.- Ability to enter custom data such as the license key
View 2 Repliesi am having a problem in executing the SSIS package through an asp.net application. i'm using c#. every time i run the package through web, i think the package is not disposed properly so until and unless i stop the application the package won't execute...i am not able to dispose or unload the package. i'm geeting errors like
'WebDev.WebServer.EXE' (Managed): Loaded 'C:WINDOWSassemblyGAC_32CustomMarshalers2.0.0.0__b03f5f7f11d50a3aCustomMarshalers.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled. The result of the expression ""EXEC " + @[User::vRowData]" on property "SqlStatementSource" cannot be written to the property.
The expression was evaluated, but cannot be set on the property. : Package Execution results: {0}
here is my code
Application app = new Application(); //Package package = app.LoadPackage("D:ChipRewards_WorkingFolderChipRewardsCodebaseHeathPlanCommonTrunkSSIS PackageETL_WorkFlowETL_WorkFlowDataImport.dtsx", null); //package.ImportConfigurationFile("D:ChipRewards_WorkingFolderChipRewardsCodebaseHeathPlanCommonTrunkSSIS
PackageETL_WorkFlowETL_WorkFlowETLConfig.dtsConfig");
[Code]....
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 RepliesI've created a deployment package in visualStudio, the package is generated, but it has an awfull structure, which is basically, the path where I've my project(e.g "CONTENT/D_C/WorkSpace/MyCustomer/TheProjectName/TheDevelopmentBranchFolder/TheCurrentBranch/TheWebApplicationName/obj/Release/Package/PackageTmp/TheSiteIsFinallyHere!!!"
It's problematic, because with the web deployer of IIS, it recreate this path.
So how can I avoid the "D_C/WorkSpace/MyCustomer/TheProjectName/TheDevelopmentBranchFolder/TheCurrentBranch/TheWebApplicationName/obj/Release/Package/PackageTmp" part in visual studio?
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 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'.
I 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#.
I need to create SSIS Package for Microsoft tool preweblog utility.exe to modify the IIS LogFiles.
View 1 Replieshow to build sqlserver integration services( ssis) package i want to tranfer more than 1000 files of excel data into sqlserver
View 4 RepliesI'm a having a problem in passing the value of a variable from child package to the parent package in SSIS. either using configurations or using scripting (c# or vb.net)..
View 2 Replies