No announcements
Found 3738416 threads
-
0 Votes
generate a SQL query output as an excel file using task scheduler
output NULL I couldn't generate an excel file on my production ...Answered | 7 Replies | 2281 Views | Created by VR16 - Friday, September 16, 2016 6:12 PM | Last reply by pituach - Saturday, September 17, 2016 3:19 AM -
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.Answered | 2 Replies | 971 Views | Created by Muzahid Sarker - Monday, August 18, 2014 7:59 AM | Last reply by Visakh16 - Monday, August 18, 2014 3:22 PM -
2 Votes
Query output in Excel
Most of them have the option to export the data coming form SQL Server queries shown on grids to Excel files.Answered | 11 Replies | 1569 Views | Created by winoa - Wednesday, June 18, 2014 1:15 PM | Last reply by Jesús López - Tuesday, September 9, 2014 4:02 PM -
0 Votes
Dynamically generate Excel File
CAN U PROVIDE SAMPLE DATA AND QUERY THAT U USED IN EXCUTE SQL TASKAnswered | 11 Replies | 3118 Views | Created by eva05 - Wednesday, February 8, 2012 2:47 PM | Last reply by ArthurZ - Wednesday, February 8, 2012 7:21 PM -
1 Votes
How to schedule auto-exporting MS Access query to Excel and email it?
You need to setup and ODBC connection, put in the SQL query you need to run and specify where to output it as Excel and mail it.Answered | 3 Replies | 9669 Views | Created by dchencm - Thursday, October 9, 2014 7:16 PM | Last reply by Nanne Sluis - Sunday, January 1, 2017 5:09 PM -
1 Votes
Output an SQL query to a script file using C#
It sounds like maybe you want to execute the SQL Query at the database and output the result to a text file?Answered | 7 Replies | 10084 Views | Created by crazyco - Friday, January 21, 2011 10:06 AM | Last reply by BonnieB - Wednesday, January 26, 2011 4:42 PM -
0 Votes
Execute SQL Query from Excel using SSIS
I assume that, you captured all queries inside object variable by using Execute SQL Task.Answered | 8 Replies | 2926 Views | Created by Hussain000777 - Saturday, December 20, 2014 10:28 AM | Last reply by Hussain000777 - Tuesday, December 23, 2014 10:06 AM -
0 Votes
Schedule Access Reports/Queries to run and output to a server
To find the Task Scheduler, click on the Start Button and type in Task Scheduler in the Search Bar.Answered | 7 Replies | 14018 Views | Created by MKL0815 - Friday, October 14, 2016 5:02 PM | Last reply by ryguy72 - Tuesday, October 18, 2016 2:44 PM -
0 Votes
Vexatious Scheduled Task automating Excel
The scheduled tasks that wouldn't function all involved Office COM scripting where I'd save off Excel and Word files.Answered | 6 Replies | 3823 Views | Created by RomTom - Tuesday, August 2, 2011 8:32 PM | Last reply by RomTom - Monday, September 26, 2011 6:25 PM -
0 Votes
Schedule SQL to run and output results to a server location
Something like this: SQLCMD -SRemoteServerName -Q"Select *F rom sysobjects" -oc:\temp\out.txt -dmaster -E Then you can ...Answered | 1 Replies | 766 Views | Created by MKL0815 - Friday, October 14, 2016 5:03 PM | Last reply by Hilary Cotter - Friday, October 14, 2016 5:12 PM -
0 Votes
Execute DTSX file using windows task scheduler.
Otherwise what is the error if you run it interactively and log the output?Answered | 6 Replies | 1849 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
How to generate SQL Script file using Script Task C#
HI Naveen, Actually i have to generate the sql script file not just the results and These INSERTS can be executed to regenerate the data at some ...Answered | 53 Replies | 7623 Views | Created by MustafaH - Wednesday, April 17, 2013 10:44 AM | Last reply by MustafaH - Thursday, April 18, 2013 12:56 PM -
1 Votes
Using access to schedule tasks
Personally, I would use VBA to do the explosion.Answered | 3 Replies | 3083 Views | Created by Mark210275 - Monday, July 4, 2011 4:40 AM | Last reply by RichLocus - Monday, July 4, 2011 5:00 AM -
0 Votes
Task scheduler not completing SQL Server task
I'm not sure what this has to do with SQL Server.Answered | 1 Replies | 943 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
outputting Complex Excel document
in your data flow, put excel destination, and set data access mode as SQL Command, then write query as sample above, then map columns .Answered | 7 Replies | 4226 Views | Created by petarch - Monday, October 11, 2010 5:08 PM | Last reply by Reza Raad - Tuesday, October 12, 2010 9:36 AM -
1 Votes
Trouble Saving XML Output from SQL Task
Save the XML to a string variable and use it in sript task to save it to a file or whatever u need.Answered | 3 Replies | 14305 Views | Created by mary4help - Friday, September 7, 2007 9:20 PM | Last reply by Sudeep Raj - Friday, July 17, 2009 1:10 PM -
3 Votes
Export the query to excel sheet automatically
You can create a scheduled SQL Agent job to automate this task every day.Answered | 7 Replies | 64242 Views | Created by Raji Subramanian - Friday, April 6, 2012 6:08 AM | Last reply by Sethu Srinivasan - Wednesday, May 16, 2012 8:55 PM -
1 Votes
Scheduled Task
SQL Server Agent uses a network account, used to run other schedules over the network.Answered | 6 Replies | 3742 Views | Created by Joe O_C - Thursday, April 9, 2009 3:00 PM | Last reply by Joe O_C - Wednesday, April 15, 2009 9:04 AM -
1 Votes
Creating Excel Table Using Script Task and SQL task
Use this variable as the source in execute sql task.Answered | 3 Replies | 2789 Views | Created by VBDevNewbie - Tuesday, April 16, 2013 3:59 PM | Last reply by VBDevNewbie - Wednesday, April 17, 2013 11:19 AM -
0 Votes
Create task schedule in SQL job
Visakh is right that for running a bat file, why dont you just invoke bat file inside a job rather than creating a task and running that task ...Answered | 11 Replies | 1733 Views | Created by MYMY2 - Tuesday, July 1, 2014 8:11 AM | Last reply by tracycai - Wednesday, July 2, 2014 4:32 AM - Items 1 to 20 of 3738416 Next ›
No announcements