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


Top 5 Contributors of the Month
Kaviya Balasubramanian
Sgraph Infotech
Imran Ghani
Post New Web Links

run dtexec on server from batch file on client machine

Posted By:      Posted Date: September 16, 2010    Points: 0   Category :Sql Server
 
Hi I would like to enable a user to execute an SSIS (2005) package located on a server.  The client does not have any elements of SQL server installed on his machine so he cannot execute the package locally.  At present he has to remote connect to the server and double click a batch file on the server that contains the dtexec script. I would like to have a batch file located on the client desktop that he can click, that will run the dtsexec script on the server - as it will not work from the client machine.  However every set of commands i try inevitably end up trying to run the package on the local machine, which obviously fails. Is there any way to have the client kick of the package and have it run on the server, without him actually having to directly remote desktop to the client? Thanks  Guy


View Complete Post


More Related Resource Links

Saving Image File in a Folder on Sever from Client Machine using Sql Server

  
  Hi EveryOne... Can anyone help me Saving an Image file in a Server folder from a client machine using Sql server 2005....   

SSIS Package working on SQL Client Machine but when trying to run on SQL Server machine giving error

  
Hi We are trying to run SSIS package on sql server machine but sometimes it is giving error for data flow task containing Script Component. Error is - [SSIS.Pipeline] Error: component "SCR DimensionRelation" (1) failed the post-execute phase and returned error code 0x80004002. This error is not coming continuously. And also not for specific DFT. It comes for different DFTs as we rerun the package. Can anybody help me on this? We are using SQL server 2008. We are not getting any error on client machine :(:(

To prevent the server from setting cookie on the client machine

  
Hi, I have deployed a Web application on IIS 6. I want to prevent my server from setting cookie on the client browser. I am using the following setting on the web.config file. < sessionState mode="InProc" cookieless="false" />  <authentication mode="Forms">   <forms loginUrl="login.aspx">     </forms>  </authentication> However, it looks like its creating a default cookie named ".ASPXAUTH" in the client machine. I dont want my application to create any sort of cookie. Is there anything specific I need to do in web.config? Please help. Thanks in Advance

Client download .csv file from server using Response.TransmitFile

  
I am using the code below to enable clients to download a .csv file from my server.The problem I am having is that when the file is saved to the client computer the file name is prefixed and suffixed with an underscore which leads to a file type of .csv_ which is obviously not a recognised file type.How can I strip the underscores from the file name at the transmit stage?        Dim FileName As String = LstBox1.SelectedItem.ToString        Dim FilePath As String = "~/temp" & FileName        Response.Clear()        Response.ContentType = "text/csv"        Response.AddHeader("Content-Disposition", "attachment; filename=\" & FileName & "\")        Response.TransmitFile(FilePath)        Response.End() 

Run a batch file at server side

  
Hello,         I am creating an intranet application which runs a batch file and create an xml file as result. Which i am using for further processing. My problem is when i am running my application from local machine batch file is running fine and creating xml,but when i am running it through iis nohting is happening,it meance process.start coudn't start command Prompt.I am using following code. I have given all permission to iis.Dim ProcessInfo As Diagnostics.ProcessStartInfoProcessInfo = New Diagnostics.ProcessStartInfo("cmd.exe", "/C " + Server.MapPath("~\myScript.bat"))        Dim Process As New Diagnostics.Process       ProcessInfo.CreateNoWindow = False        ProcessInfo.UseShellExecute = False        Process.StartInfo.WindowStyle = System.Diagnostics.ProcessWindowStyle.Normal        Process = Diagnostics.Process.Start(Server.MapPath("~\Spandata\RunSpan.exe"))       Process.WaitForExit(20000)        Process.Close()

Accessing image file in local machine from server

  
 Hi i have a  .JPG file in my local machine which has  to be sent as body of SMTP mail. Path of image D://foldername//imagename.jpg The code I run is in the server m\c. I want it to access my local machine's d:\ folder to get the image file. But it is accessing the server m\c's d:\ folder. How can this be done? Thanks Amuda.RG  

Urgent!!!!!!!-- xecuting Server Side .exe File From Client Side

  
helllocan any 1 plz teel me . How To run exe on client machine which(exe) store in Server side.I dont want user need to downoad My .exe file and then Install on his machine. I want user just click on Register linkbutton and directly Start Executable Installation process. PLZ HELP MEAMIT:)

Can I run Sql server 2000 client tools and SQL server 2005 on teh same machine.

  

Hi

Could you please advise me on this issue.

I have installed sql server 2000 client tools, and complete set up of sql server 2005 on my system.

The enterprise manager on sql 2000, crashes and and window vanishes, when ever i try to create DTS package.

They doubt its becos i am runnning both instance of sql server on the same machine- So its having some compactability issues.?

Can we run SQL server 2000, 2005 and 2008 on same machine with different instance ?

I am using windows 7 and i3 processor.

Thanks in advance.

thansks

shan


Download an XML File to the IIS server, not to the client

  

Hey guys,

I'm trying to do the following in ASP.NET (with c#):

1. On page Load, download an XML file from a different website to the IIS server, in a subdirectory of the application directory called "downloadedFiles"


I know that WebClient.DownloadFile() can download a file, but this only seems to download the file to the client's machine. I am interested in downloading it to the actual IIS server (so that it can be utilized throughout the lifetime of more than one session). Does anyone know how this could be performed?

Specifically, I'm trying to download an XML file from a website (as an example: http://api.twitter.com/1/statuses/followers/CiscoSystems.xml). How could I download that XML file onto my actual IIS server?

Thanks a ton for any help



WCF Windows Auth (NTLM) Problem when Client and Server are on the same machine

  

I have WCF service being hosted in IIS with windows auth enabled, it is running under NetworkService account .  I have a simple method on my WCF service which just reflects the identity of who is calling it.

 

public string RefelctIdentity()

{

 

return HttpContext.Current.User.Identity.Name;

}

I am using IIS to authenticate the user and pass me the WindowsPrincipal in the HTTP context.

I am consuming the WCF service witha client used in a WindowsService that is being run under the NetworkService account.  When the WindowsService.  When running b

Import Excel File to Sql Server on a 64 bit machine

  

I need to import Excel (xls - 2003-2007) data into a Sql Server 2008 database. Both the Excel file and the database live on a Windows Server 2003 R2 sp2 64 bit machine.  I’m fine with it running in 32 bit mode but it all needs to happen on the same server. Also, I would like it to run in T-Sql but as a fallback we can do this in SSIS.

My T-Sql code which runs fine on a 32 bit machine is as follows:

SELECT * Into #TempTable From OpenRowSet('Microsoft.Jet.Oledb.4.0','Excel 8.0;Database=\\Servername\Folder\filename.xls;HDR=NO;IMEX=1', 'select * from [Main$]')

 

On the 64 bit server:

Not able to create scheduled task in windows server 2003 using a batch file

  

Hi,

I am working on a .net 1.1 windows forms application. We have windows 2003 service pack 2 as the server operating system which uses IIS 6.0.

We have a report generation section. User submits report from the screen(c# code) to run report on a specified time. This request will create a batch file with the AT command with the time specified by the user. This batch file will create an AT job in scheduled tasks window and this AT job will a call another scheduler. This scheduler will generate the report.

the AT command looks like T 16:32 /INTERACTIVE C:\Inetpub\wwwroot\mywebservices\bin\Schedulers.GenerateReport.exe

 

This is working fine in all servers except one server which uses windows 2003 standard edition. The problem is like it is not able to create the batch file and subsequently fails to create the AT job.

Is there any permission related issue by which it is not able to create the batch file from code.

Please advice me!!!


Problem connecting to report server from client machine

  

We've deployed some reports from a server machine which can be accessed without any problems if you are logged onto the server itself by going to the URL of http://servername/ReportServer. However if we try and access the reports from a client machine (even if we use the same administrator Windows account) we get the Windows security window appear asking for a Username and Password to be entered in order to connect to the server. We've tried entering this but we then just get a blank screen after being re prompted a few times to enter the details.
Now I'm not sure whether this will be a Reporting Services or a Windows issue. Could it be a setting within IIS? It can't really be a user thing as the same user works on the server but not on the Client machine so it's more of a machine problem. It's as if there are some authentication settings somewhere that need to be set.
We are using SQL Server 2008 on Windows 7.
 
Thanks a lot
Steve


Problem accessing Report Server from client machine

  

We've deployed some reports from a server machine which can be accessed without any problems if you are logged onto the server itself by going to the URL of http://servername/ReportServer. However if we try and access the reports from a client machine (even if we use the same administrator Windows account) we get the Windows security window appear asking for a Username and Password to be entered in order to connect to the server. We've tried entering this but we then just get a blank screen after being re prompted a few times to enter the details.

Now I'm not sure whether this will be a Reporting Services or a Windows issue. Could it be a setting within IIS? It can't really be a user thing as the same user works on the server but not on the Client machine so it's more of a machine problem. It's as if there are some authentication settings somewhere that need to be set.

We are using SQL Server 2008 on Windows 7.

 

Thanks a lot

Steve


Server call client machine and pick data from client service.

  

HI All,

Does anyone have any opinions over the best ways to connect a server to client service over internet to get data on server website.

If you have any idea and solution then please feedback me . Thanks 

Regards,

SAS

 


Client can't connect to WCF on deployment machine Windows 2003 Sp2 server .NET 3.5

  

Hello, 

I have a WCF service hosted in a Windows service application.  I have a Windows Form client that connects to it.  I am using net.tcp binding for two endpoints.   It all works fine in my environment, but when I deploy it on my cutomer's machine the client does not get a response from the service.

I ran netstat -na and I can see the endpoints listening.  I can even see the connection ESTABLISHED when my client runs the first method.  But my client times out and receives a "Could not communicate with XXX service.  This request operation sent to net.tcp..... did not receive a reply within the configured timeout (00.01.00) The time alloted... etc"

I tried removing all security from the configuration file, but that did not make a difference.

I reinstalled .NET Framework 3.5

I added     System.Net.ServicePointManager.DefaultConnectionLimit = 200 as suggested in another post.

I am creating a trace for the client and the server.  The server does not log any activity of a connection.  The client is catching a communication exception.

Any insight would be greatly appreciated.  What else can I try to see why the client is not able to chake hands with the server on this particular machine?

Many thanks,

Karen


Ka

scripts file not found on server - 404

  

Fiddler is showing a 404 error when my published web application runs. the jquery.js file in
/scripts is highlighted in red by fiddler as not found. ( IIS log also shows the 404 error ).
I run the web app from visual studio, on local host - no problems. The publish is successful.
All the files are in the scripts folder of the web app on the server.

In the site.master I have:
<script src="../../Scripts/jquery-1.4.1.min.js" type="text/javascript"></script>

Visual studio does not complain about this. ( which indicates the file is found. )

Oddly, when I fully qualify the path, VS says file not found, but after I publish and run, fiddler
shows the jquery file being found and sent to the browser.
<script src="/MvcApplication1/Scripts/jquery-1.4.1.min.js" type="text/javascript"></script>

when the <script> path is "../../Scripts/jquery-1.4.1.min.js", the fiddler error is
404: /Scripts/jquery-1.4.1.min.js .

when the <script> path is "/MvcApplication1/Scripts/jquery-1.4.1.min.js", fiddler shows the file
being sent to the browser from that /MvcApplication1/Scripts path.

Both the Scripts fol

Categories: 
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