No announcements
Found 4083488 threads
-
0 Votesgenerate a SQL query output as an excel file using task scheduler
, function, trigger, or view nesting level exceeded (limit 32). output NULL I couldn't ...Answered | 7 Replies | 1963 Views | Created by VR16 - Friday, September 16, 2016 6:12 PM | Last reply by pituach - Saturday, September 17, 2016 3:19 AM
-
0 Votes
Need a query to generate an output as below
Try with: SELECT T1.Emp_ID, T1.Emp_Name, T1.Designation, T2.Emp_ID as T2_Emp_ID --due to duplicate columnAnswered | 1 Replies | 1244 Views | Created by Manoj-D - Tuesday, October 27, 2015 7:04 PM | Last reply by Ivan Donev [MSFT] - Tuesday, October 27, 2015 9:19 PM -
1 Votes
Output an SQL query to a script file using C#
Hi, I am trying to figure out how I can use an SQL query here and output the result to a text file. At the moment it works just by manually ...Answered | 7 Replies | 9553 Views | Created by crazyco - Friday, January 21, 2011 10:06 AM | Last reply by BonnieB - Wednesday, January 26, 2011 4:42 PM -
0 Votes
SQL Query to output formatted Excel file
I need to create a query (SQL 2000) that renders a formatted excel (xml or xls) file for each row that is outputted. The ...Answered | 3 Replies | 15608 Views | Created by Liquid Tobi - Wednesday, August 2, 2006 1:42 AM | Last reply by JWilliamsoh - Monday, May 24, 2010 2:03 PM -
0 Votes
Using SQL Query output as a variable
User1987255407 posted Hello. I am trying to use the output of a SQL query as a verable in my ...Answered | 6 Replies | 13 Views | Created by Anonymous - Monday, June 9, 2008 10:34 AM | Last reply by Anonymous - Monday, June 9, 2008 3:49 PM -
2 Votes
Run Sharepoint file using Task scheduler
local script file that you are running now from task scheduler Download SP file using PSAnswered | 4 Replies | 2482 Views | Created by Poovi - Wednesday, October 11, 2017 10:58 AM | Last reply by PriyaranjanKS - Wednesday, October 11, 2017 12:09 PM -
0 Votes
Store query output in a excel file?
There are a few ways to do this...you could use the bcp utility, or you could use dts to export the data from a SQL Server database to an excel ...Answered | 4 Replies | 11338 Views | Created by JayaC - Tuesday, April 17, 2007 7:44 PM | Last reply by tewald - Friday, November 7, 2008 3:18 PM -
0 Votes
SQL TASK OUTPUT IN EXCEL REPORT
You can create a data flow task and use stored procedure inside oledb source as command using EXEC storedprocedure. Then link it to excel destination to ...Answered | 2 Replies | 821 Views | Created by Muzahid Sarker - Monday, August 18, 2014 7:59 AM | Last reply by Visakh16 - Monday, August 18, 2014 3:22 PM -
0 Votes
update excel file using execte sql task
data transfers, not update some cells in an Excel file. MCTS, MCITP - Please mark posts as answered where appropriate.Answered | 3 Replies | 2343 Views | Created by Sudeep Puvvadi - Tuesday, June 26, 2012 10:22 AM | Last reply by Koen Verbeeck - Tuesday, June 26, 2012 11:00 AM -
0 Votes
Task scheduler not completing SQL Server task
a certain time in the early morning. There is VBA macro set to run on opening. It accesses information from an SQL Server database, ...Answered | 1 Replies | 717 Views | Created by SKeithLA - Thursday, July 28, 2016 6:32 PM | Last reply by Erland Sommarskog - Thursday, July 28, 2016 8:07 PM -
0 Votes
Execute DTSX file using windows task scheduler.
Hi Arthur, I am using the command as cmd.exe C:\folder\file.bat in actions tab of task scheduler ...Answered | 6 Replies | 1386 Views | Created by Partha_B - Wednesday, November 29, 2017 2:59 PM | Last reply by Partha_B - Thursday, November 30, 2017 4:17 AM -
0 Votes
Console Application run as Task Scheduler
the JSON file with the date. This runs fine when local debugging and also when run with a command prompt on the server. But when scheduled Task ...Answered | 2 Replies | 1761 Views | Created by Manoj Deshpande - Thursday, April 11, 2019 5:36 PM | Last reply by Manoj Deshpande - Thursday, April 11, 2019 9:53 PM -
0 Votes
scheduler task
I suggest that you can check out A New Task Scheduler ClassAnswered | 1 Replies | 3486 Views | Created by developer00 - Wednesday, February 27, 2008 9:35 AM | Last reply by Feng Chen - Friday, February 29, 2008 8:48 AM -
0 Votes
Task Scheduler
User-837620913 posted It looks like you are using the Task Scheduler Manager Wrapper available here: httpAnswered | 1 Replies | 19 Views | Created by Anonymous - Monday, April 29, 2013 1:28 AM | Last reply by Anonymous - Monday, April 29, 2013 5:40 AM -
0 Votes
Generate a Flat file as an output for a sql server table
I need to generate a flat file: Input sql server table: ex: select * from customers output should ...Answered | 1 Replies | 5789 Views | Created by smackstrider - Monday, May 18, 2009 10:50 AM | Last reply by eliasen - Monday, May 18, 2009 11:01 AM -
1 Votes
Using Windows Task Scheduler C#
Even if you wrap Task Scheduler COM interfaces, administrator permission is required. To workaround that, you will have to use impersonation (run schtasks ...Answered | 6 Replies | 40720 Views | Created by optimus_prime - Saturday, April 7, 2012 7:49 AM | Last reply by Tarun00007 - Monday, April 9, 2012 6:33 AM -
0 Votes
How to write sql query output in Excel File
User-1253618151 posted Hai All, How to write sql query output ...Answered | 1 Replies | 13 Views | Created by Anonymous - Friday, February 13, 2009 6:51 PM | Last reply by Anonymous - Friday, February 13, 2009 6:56 PM -
0 Votes
Task Scheduler
; icon. This tool is a GUI for the very same Task Scheduler service that I described how to access programatically and from the command line in the other post (guess ...Answered | 1 Replies | 4242 Views | Created by AndersBank - Wednesday, July 19, 2006 1:36 PM | Last reply by Michel Baladi - Thursday, July 20, 2006 10:34 AM -
3 Votes
SQL query output to a text file
exe to run a sql query remotely or locally. My purpose is to prepare a sql query to be used in ASP.NET code to ...Answered | 10 Replies | 87866 Views | Created by marked9 - Wednesday, July 21, 2010 10:45 AM | Last reply by Tom Li - MSFT - Monday, July 26, 2010 6:56 AM -
0 Votes
Using an Excel file on a SharePoint as a datasource
Using Excel as a Reporting Services data source Since the Excel file is on a SharePoint site, in the “Select ...Answered | 5 Replies | 19307 Views | Created by JR Hunt - Wednesday, May 2, 2012 4:01 PM | Last reply by JR Hunt - Tuesday, May 15, 2012 3:36 PM - Items 1 to 20 of 4083488 Next ›
No announcements
