Using Asp.net To Launch A DTS Package
Aug 18, 2006does anyone know an easy way (or any way for that matter) to run a DTS package from an asp.net page?
ADVERTISEMENT
Launch A Package From VBA...
Mar 13, 2006Hi all,
I'm trying to launch a SIS package from a VBA macro in excel...now I launch the dtexec.exe from a shell but a have this error:
Started: 10.14.33
Could not load package "Package1" because of error 0xC0014062.
Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired). The SQL statement that was issued has failed.
Source:
Started: 10.14.33
Finished: 10.14.49
Elapsed: 16.594 seconds
but all credential are correct...
any ideas ???
thanks in advance
Wolly
Create A SP That Will Launch A DTS Package
Oct 10, 2006Hi all. How can I create a Stored Procedure that will launch a DTS package that I have already built dynamically ?
I have a string already built and I need to put it in a SP because my application is php (linux) and the database is SQL Server on a Windows machine.
I will use php to execute the stored proc, which is the only way to access it.
My string looks like this :
C:Progra~1Micros~380ToolsBinnISQL.EXE -S [MyServer] -U [Username] -P [Password] -Q "ISQL_Batch 'D:DDFIImporteIMPICAFI.bat [user] [Schema] [Pwd] '" -n -d [database]
(Words in [] are only to show that I will put other values)
Thanks
CFGilles
How To Launch A SSIS Package From VB Or Whatever
May 18, 2006Dear all,
I am looking for any snippet of code where you can launch a SSIS package by DMO or VB 6.0. I read that it was posible to call dts.runtime assembly from VB 6.0 but at first it might be converted or something like that.
Issue comes from the moment that we€™ve got an ASP 3.0 scheduler for hundreds of dts and now we have to migrate them to sql25k.
Thanks in advance for any info regarding this,
How To Launch Programatically A SSIS Package?
May 22, 2006Dear all,
I wrote this post others times but the answer did not satisfied so that I'd like to know if really anyone has ever used or experienced with this possibility. No by .Net language rather than Vb 6.0 or ASP or even instanciacing DMO library.
According this link http://support.microsoft.com/?kbid=817248 it seems possible but I haven't idea if possible keeping in mind that it has been made by yourself no for others... So that, I mean, these assemblies comes along with Sql Server 2005 installation.
Thanks a lot for your support,
Launch SSIS Package With SQL Event
Jun 27, 2007Is it possible to launch an SSIS package after a SQL event takes place? I need to run a package after a customer order is placed. Can a trigger in SQL launch the package?
View 1 Replies View RelatedHow To Launch Package From A Windows Service
May 20, 2006I'm developing a Windows Service to watch for an e-mail and then launch a package. It extracts some parameters from the e-mail that I then need to pass to the package. What is the best way to launch the package from the service? Should I run it in a new thread? I don't want the service to have to wait for the package to complete. How would I pass the parameters? Should I use dtexec? If the service fails or is stopped and the package is still running, it would terminate the package also, correct? Any way to avoid that? Thanks.
View 3 Replies View RelatedDTS & Security: Permissions Required To Launch Package
Jan 9, 2001I have prepared several DTS packages which must be launched by a custom external application. What is the best way to provide access to this application? What are the minimum security requirements? Currently, they are local packages; I understand that some utility is offered by saving them as .DTS files, but I don't know the pros & cons. Are there advantages to using the Repository? The app should be able to do its work from a different box on the same network as the server. (Ultra-super-secret security isn't an issue, but I don't want to have give our developers sa-level access unless necessary.)
View 2 Replies View RelatedHow To Launch Package From Client Machine, Display Progress And Finally Results?
Oct 4, 2006Please help. I'm completely new to SSIS, and I was hoping someone could point me in the right direction(s).
I am developing a winforms client app, and I need to be able to provide the user with the ability to import data in CSV format into our application's database.
I'd like to use SSIS if possible, as long as what I am trying to do isn't near impossible.
I'm thinking of a UI where the user can specify a flat file (CSV) to upload and be processed by an SSIS package on a remote database server.
This package will be responsible for validating the CSV file and inserting data into the database as appropriate.
Is there a way I can:
launch an SSIS package remotely, from a winforms app on the client machine that is not running SQL server (preferably asynchronously) -- and pass it some parameters, including the import file itself
(optionally) provide progress feedback to the client pc to let them know it is being processed
display a nice SSRS report on the client upon completion that tells them exactly what the success/failure of the import was (how many rows processed, which ones failed and why, etc)
Any helpful examples, links, etc would be most appreciated.
Thanks in advance!
How To Launch Them??
Nov 7, 2006Hi everyone,
Primary platform is Framework 2.0
Our vb application throws .dtsx by means of the usual methods.
When I want to run packages allocated in my Windows folder I use LoadPackage; when I want to run packages allocated in my MSDB I use LoadFromSqlServer and at the end of the day when
I want to run packages allocated in my File System SSIS folder I use LoadFromDtsServer.
Drawbacks come here according a "new sort of SSIS packages". I'm talking about those packages which are imported from Sql2k from
Database Engine->Management->Legacy->Data Transformation Services.
How do I launch this kind of SSIS packages??
I'm totally stuck with this. Or maybe the problem is easier: the ones aren't ssis but dts????????????????
Thanks in advance for your input,
How Do You Launch Tutorials?
May 8, 2007I inherited a computer from a co-worker who left. On it she installed SQL Server 2005. The help system is chock full of references to the various and sundry tutorials that come with the product, but I can't find so much as a syllable about how one actually accesses those tutorials.
When I select Start, Programs, Microsoft SQL Server 2005, Documentation and Tutorials, Tutorials, SQL Server Tutorials, it simply launches one of the help screens. That screen, and the ones it contains links to, describe the tutorials topics in great detail, but nowhere is there any explanation of how you actually launch the tutorials.
What am missing here?
Can't Launch ReportBuilder
Feb 20, 2008I was the happy admin of some reportservers (build 3175) until someone asked me to get the ReportBuilder to work. I've read through the documentation and configured the SSRS site security so that the icon is visible. However when I click on it nothing happens. If I try to launch it by right clicking and then save as -- open I receive the following error:
- Downloading file:///C:/UserTemp/_temp/ReportBuilder.exe.manifest did not succeed.
- Source: System.Deployment
- Stack trace:
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
at System.Deployment.Application.FileDownloader.Download(SubscriptionState subState)
at System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri& sourceUri, String targetPath, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadApplicationManifest(AssemblyManifest deploymentManifest, String targetDir, Uri deploymentUri, IDownloadNotification notification, DownloadOptions options, Uri& appSourceUri, String& appManifestPath)
at System.Deployment.Application.ApplicationActivator.DownloadApplication(SubscriptionState subState, ActivationDescription actDesc, Int64 transactionId, TempDirectory& downloadTemp)
at System.Deployment.Application.ApplicationActivator.InstallApplication(SubscriptionState subState, ActivationDescription actDesc)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)
at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
--- Inner Exception ---
System.Net.WebException
- Could not find file 'C:UserTemp\_tempReportBuilder.exe.manifest'.
- Source: System
- Stack trace:
at System.Net.FileWebRequest.EndGetResponse(IAsyncResult asyncResult)
at System.Net.FileWebRequest.GetResponse()
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
--- Inner Exception ---
System.Net.WebException
- Could not find file 'C:UserTemp\_tempReportBuilder.exe.manifest'.
- Source: System
- Stack trace:
at System.Net.FileWebResponse..ctor(FileWebRequest request, Uri uri, FileAccess access, Boolean asyncHint)
at System.Net.FileWebRequest.WrappedGetResponseCallback(Object state)
--- Inner Exception ---
System.IO.FileNotFoundException
- Could not find file 'C:UserTemp\_tempReportBuilder.exe.manifest'.
- Source: mscorlib
- Stack trace:
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, Boolean useAsync)
at System.Net.FileWebStream..ctor(FileWebRequest request, String path, FileMode mode, FileAccess access, FileShare sharing, Int32 length, Boolean async)
at System.Net.FileWebResponse..ctor(FileWebRequest request, Uri uri, FileAccess access, Boolean asyncHint)
COMPONENT STORE TRANSACTION DETAILS
No transaction information is available.
Here are the things I have checked/tried:
Ensured the .NET Framework Reliant components are enabled in the browser
Running the browser with a user account that is local admin on the workstation
MIME settings on IIS server look ok
I am not seeing any access denieds on my workstation (checked with file and regmon)
I am not seeing any failures in the security event log
For the test that I am doing, both the user account, workstation and server are in the same domain
Don't see any errors in the SSRS logs
Can anyone think of anything else that would lead me to resolving this problem?
Thanks
How To Launch An Oracle SP From SQL Trigger?
Aug 16, 2006I need to know a few things about this..
1. What do I need running or available on SQL Server machine (presuming an Oracle client)
2. Has anyone done this and perhaps can give me some quidance?
3. Any concerns about going from outside a firewall to the Oracle instance?
Architecture is probably going look like this:
SQL -> ON INSERT Trigger -> business logic -> Call Oracle Procedure
Any help is appreciated, thanks!
JTGIS
When Did Microsoft Launch SQL Server ?
Dec 13, 2006Hi Folks,
My understanding is that Microsoft acquired the rights to use and re-badge Sybase as SQL Server and since then have engaged in a substantial re-write as part of their commitment to it.
Is this correct and can anyone give me some dates ?
Thanks very much
B.Dimple
Senior DBA
Quick Launch 2005 On PC
Jul 25, 2007Poor me :o I have to share a home PC now so cannot have things my own way. When using my own PC I had SQL Server 2005 dev edition run on start up. Now I am sharing it seems rather churlish to not have it start on demand.With 2000 you got a little icon in the taskbar that indicated the status of SQL Server and a quick right click -> start was all you needed to get the little fella up and running. With 2005 you need to go all the way to configuration manager and start it. I have four options:#1 - a few mouse clicks to start SQL Server via configuration manager (unacceptable - imagine all the wasted time and RSI!)#2 - bat file to start SQL Server (ok)#3 - more sophisticated little app that shows the status of SQL Server in the taskbar and allows me to start it (nice but a pain to put together)#4 - something much spiffier which one of you gurus can let me in on I am sat on the edge of my little seat in anticipation :)
View 1 Replies View RelatedDTS Launch From SQL Server Agent
Mar 18, 2004Hi,
I want to build a task that does 3 things automatically at a fixed time interval:
1) Refresh the data (copy newly inserted data from a datamart to a datawarehouse)
2) Run a program (exe) to produce some external reports
3) Refresh an OLAP Cube with the new data so that users can access it
Basically, using SQL Server Agent, setting up steps 1 and 2 was pretty straightforward (for step 1, the main point of entry is a single sp).
I ran into some trouble figuring the easiest way to complete step 3. I created a DTS package with one object that updates the Cude on my server. This seems to be working fine. Then, I created step 3 in Agent and chose 'CmdExec' as the type of command. I then referenced the external exe 'dtsrun' to execute my DTS package.
Everything seems fine but I'm not sure I used the "best" way of doing things. Since the SQL Server Agent and DTS manager are both SQL Server tools (so is the Analysis services), I'm wondering if there wasn't an easier (thus more robust) way of completing my 3rd step?
Anyone? How is this done where you've worked?
Thanks,
Skip.
Launch Storedquery For Each Record
Nov 21, 2007hiI have a scenario where I have created a stored procedure wich task isto search in my database with certain criterias. For each record fromthis search, I want to run a couple of other stored procedure.Here is some code:decare $myid nvarchar(15)select id, desc, customer from project where customer = 'cust1'--------------------------------------------HERE IS CODE MISSING----------------------------------------------for each of the records returned, I want to run 4 stored procedureswith the id as parameter.beginexecute StoredProcedure1 $myidexecute StoredProcedure2 $myidexecute StoredProcedure3 $myidexecute StoredProcedure4 $myidendThe problem is I don't know how to get hold of the result set and loopthrough. Maybe you can help me.regardsRoger
View 6 Replies View RelatedReport Builder Will Not Launch
Nov 10, 2006I am having problems launching the Report Builder. I click the button and nothing happens. I did see the other suggestions about re-installing the .NET 2.0 Framework but that did not help. I tried to launch it directly from the address bar and I am getting the same reponse as when I click on the Report Builder button. I can access the Report Builder from other machines and it works fine. I did just recently install IE 7 and I tried to uninstall it and go back to IE 6 but I got the same results.
Any help would be appreciated.
Thanks Tim
Launch Instance Only When Is Required
Aug 7, 2015I've SQL instance used for Telecom Software, that SQL instance kept to run automatically consume 2 GB RAM and slow my machine..How could I configure it to lunch only when I open my Telecom Software and to close when I exit it.
View 9 Replies View RelatedFailed To Launch 'osql'
Sep 13, 2006I use one-way Transactional Replication on 38 servers with same configuration.
On one server I have problem with OSQL.EXE path.
On
Publication properties ->
snapshot ->
Additional scripts ->
Before applying the snapshot, execute this script:
Is set preinit script (C:ReplDataReplPreInit.sql).
On Distribution agent properties -> step "Run Agent"
I set additional command for log problem.
command= -Output C:ReplOutFile.txt -Outputverboselevel 2
Here is part of ReplOutFile.txt:
--------------------------------
The osql command is: "C:Program FilesMicrosoft SQL Server80ToolBinnosql.exe" -U"***" -P"***" -i "\STROSBBReplDatauncSTROSBB_antikor_DataCDB20060908104051ReplPreInit_0.sql" -S "BTSVR" -d "AntikorCDB" -o "C:WINNTTEMPReplPreInit_0.sql_20060912150416.log" -b -X1
Launching osql to apply the script 'ReplPreInit_0.sql'
[9/12/2006 3:04:16 PM]STROSBB.distributionAntikor: {call sp_MSadd_distribution_history(1, 3, ?, ?, 0, 0, 0.00, 0x00, 1, ?, 0, 0x01, 0x00)}
Agent message code 20130. Failed to launch 'osql'
[9/12/2006 3:04:16 PM]STROSBB.distributionAntikor: {call sp_MSadd_distribution_history(1, 6, ?, ?, 0, 0, 0.00, 0x01, 1, ?, 4, 0x01, 0x01)}
Adding alert to msdb..sysreplicationalerts: ErrorId = 1233,
Transaction Seqno = 00000491000618f4007000000001, Command ID = 4
Message: Replication-Replication Distribution Subsystem: agent STROSBB-antikor-BTSVR-1 failed. Failed to launch 'osql'[9/12/2006 3:04:16 PM]STROSBB.distributionAntikor: {call sp_MSadd_repl_alert(3, 1, 1233, 14151, ?, 4, N'STROSBB', N'antikor', N'BTSVR', N'AntikorCDB', ?)}
ErrorId = 1233, SourceTypeId = 3
ErrorCode = '3'
ErrorText = 'The system cannot find the path specified.
--------------------------------
Problem is that the path to osql command in log ReplOutFile.txt is
C:Program FilesMicrosoft SQL Server80ToolBinn
but SQL is installed on path
C:Program FilesMicrosoft SQL Server80ToolsBinn
Diferences is between Tool vs. Tools
I think that when server create OSQL command for preinit sql script he use STATIC path to osql.exe and there is my problem.
Where is this path stored and can I change it?
Launch DTS With OLAP From .net Application
Sep 19, 2006Hi,
with reference to the following thread:
http://forums.microsoft.com/msdn/ShowPost.aspx?postid=740855&isthread=false&siteid=1&authhash=775a583435c503730bf96695fe78ffc77f04a290&ticks=632942355374528292
Which in summary is that I am trying to execute DTS packages containing OLAP tasks to process cubes from an application. It hangs and fails after an hour and some minutes.
the code :
Package2Class package = new Package2Class();
object pVarPersistStgOfHost = null;
package.LoadFromSQLServer(serverName,null,null,DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrustedConnection,null,null,null,packageName,ref VarPersistStgOfHost);
package.Execute();
I have launched the DTS on command prompt using DTSRUN on the computer I am trying to execute my code, and it executes marvellously.
DTSRUN can also execute a DTS on another physical server Alpha for instance which process a cube of AS2000 found on another physical server Beta for instance.
Since I need to check that each steps have been executed properly and that running DTSRUN from the application is not a possibility to do so, I need a way to be able to launch the DTS and get to know which steps is failing. the above code is supposingly a way but its failing on LoadFromSQLServer() method.
I am using SQL Server 2000 and AS2000 and .net 1.1 (modifying a legacy system to enable the above facility).
Any views please?
Thanks
How To Launch A Dts 2000 From Framework 2.0?
Nov 7, 2006Either c# or vb samples are welcomed.
Thanks in advance,
Launch Condition To Detect SQL CE?
Jan 29, 2007I have written a .NET application that uses SQL Server Compact Edition. It's deployed by a MSI file (setup project in VS - not ClickOnce).
How do I add a SQL CE launch condition to my setup project?
Best Way To Launch Report From A C# Winforms App?
Jan 25, 2007I'm new to SSRS. I would like to launch a report from a C# desktop application, supplying parameters programatically. I was able to do this using System.Diagnostics.Process p ... then p.Start(@"(path)iexplore.exe","(reportURL)"); I'm betting there's a much better way to do this.
Ideally I would like to create an IE window that shows only the report, that is, only the report viewer toolbar is visible, the IE toolbars and menus are hidden. I want to specify IE as the browser in case some other browser is installed as the default web browser.
Can anyone link me to a tutorial or provide a code snip? Thanks.
Enterprise Manager Launch Error
Mar 15, 2004Not sure what has caused this to suddenly happen, but each time I attempt to launch Enterprise Manager I get the error:
"MMC cannot open the file C:MSSQLBINNSQL Server Enterprises Manager.MSC
This may be because the file does not exist, is not an MMC console, or was created by a later version of MMC. This may also be because you do not have sufficient access rights to the file."
Now, I've already attempted to reinstall the client tools with no luck. The file does exist, and I have not changed my security settings -- at least that I'm aware of.
I use EM daily, so I'm perplexed as to why over night it stopped working. Is it possible a Windows Update could have caused this?
If you have any insight I'd appreciate it. Thanks.
PS. I'm using SQL 7.0 on a WinXP Pro laptop.
David
Can You Launch A Crystal Report From A Sql Trigger
Mar 21, 2006and if so does anyone know where I can find some code examples?thanks
View 1 Replies View RelatedReport Builder Fails To Launch
Jun 20, 2007
Good day:
I've searched and found a whole lot of information regarding Report Builder's occasional failures to launch, but every single suggestion has not worked for me. I'll try to describe this as completely as possible.
PC 1: Login with my user id, navigate to either my test or production report server, click 'Report Builder'; application launches and can be used as expected. Login with a 2nd user id, and it works. OS is Win2003 Server. Because both logins work on this PC, which tells me the security credentials are set correctly.
PC2: Login with my user id, navigate to either my test or production report server, click 'Report Builder'; application fails to launch. I do not receive an error message or dialog. The 'frames' for the Report Builder form flash momentarily on the screen. Login with same 2nd user id, and it fails the same way. OS is WinXP SP2; all updates.
PC3: Login with my user id, navigate to either my test or production report server, click 'Report Builder'; application fails to launch. I do not receive an error message or dialog. The 'frames' for the Report Builder form flash momentarily on the screen. Login with same 2nd user id, and it fails the same way. OS is WinXP SP2; all updates.
On PC2 and PC3, I navigate to the ClickOnce cache in my profile, right-click and 'run as' the reportbuilder.exe file. Choosing 'run as' my login and providing a password -- voila -- the application runs. I have to manually set the link to the report server, but it appears all else works fine. Same situation when I use my 2nd user id. If I don't 'run as' and provide the password (just double-click to launch the file), I get the same 'flash frames' above.
Ultimately, the push is to get PC2 and PC3 to function as does PC1. My resident .NET expert is stumped, as am I. Please help.
Launch An Application From Reporting Services?
Nov 22, 2007Hi all,
I don't know if this is possible or not but what I want to do is include a few images on a report that will launch a little VB6 application when clicked. I've tried messing with the Navigation - URL properties of the image but am getting nowhere fast!
Anyone any ideas?
Cheers
Ninj
SQL 2005 Standard From Ready To Launch. Is It X64?
Oct 12, 2006I just set up a server with Windows 2003 Standard x64. I have a copy of SQL Server 2005 Standard Edition that I got from the Microsoft Launch event. On the back of the case, it gives version requirements for both the x86 and x64 versions. When I went to install it, it didn't ask me which one I wanted to install. When I look on the CD, I see different installers for x86 and x64 for various pre-requisites, like MSXML. As I'm installing SQL Server I see that it is installing most things to "C:Program Files (x86)" which is where 32-bit programs go.. I decided to let it finish. Most of the binaries and everything, include sqlservr.exe, are in the Program Files (x86) folder, but it did install a few things in Program Files, so it must be aware of the difference.
I checked task manager and, I see that the sqlservr.exe and SQLAGENT90.exe are NOT 32-bit processes. So, great, they're running natively in 64-bit mode! But when I look at the server options in SQL Server Management Studio, the patform is listed as NT INTEL X86. The memory page also shows an option to use AWE which according to the documentation is only available and relevant to 32-bit installations.
SO I'm pretty confused. Almost everything points to this being an x86 installation, but the running processes are running natively in x64. Does anyone know what's going on here?
I just tried to run the x64 version of SP1 for SQL 2005, and it told me that it cannot update x86 products, so I guess that clinches it. I'm still pretty confused and annoyed though. If this isn't x64, how can I get an x64 version of the same product, and will my license key work?
Launch Mirror Monitor Option Is Not Available
Nov 29, 2007I have configured a Mirror with Server A as Principal, Server B as Mirror. I can Remote Desktop into both machines and see the Launch Mirror Monitor option in the Tasks list from the Object Explorer. I do not, however, have the option when logged in from my desktop Object Explorer. In each instance, I log into OE using the SA login. Both machines are on sp2. I have seen others post similar problems but have not found anyone with a resolution. Any help is greatly appreciated.
Thanks,
StephenNva
Launch An SSRS Report From SSIS
Mar 11, 2008I want to launch an SSRS report from within SSIS, save the results as an excel fiile and then send it to a user.
Can this be done?
If so, can someone point me in the right direction?
Thanks.
SQL Server Express 2005 Can't Launch BIDS
May 6, 2008After re-installing SQL Server Express 2005 and the Toolkit BIDS will not launch. Windows is looking for a file devenv.exe. Does anyone know how to get around this problem?
View 5 Replies View RelatedHow Do I Launch SQL Server 2005 Express After Download?
Nov 25, 2007Looks like I sucessfully downloaded SQL Server Express Edition w/Advanced Services SP2 on my Vista-based notebook. Took care of the prerequisites from downloading with Vista. I see the Configuration Manager, and Error and Usage Reporting. But......How do I launch SQL Server Express please?
Thank you!
Sandra Shokite