No announcements
Found 3866009 threads
-
0 Votesregarding ssis - schedule 20 packages
Or else listen to Olaf Helper and create 20 jobs...Answered | 7 Replies | 1073 Views | Created by Koteswararao Bellam - Friday, November 28, 2014 8:09 AM | Last reply by SSISJoost - Sunday, November 30, 2014 8:00 AM
-
0 Votes
My ssis package scheduleing for every 20 sec but for every 20 sec job run the end time is differ even though there is no data new data from source tables.
If the package is deployed on SSIS Catalog, you can view the Execution Report and find out the time spent on each task.Proposed | 3 Replies | 901 Views | Created by avs sai - Tuesday, November 6, 2018 4:38 PM | Last reply by Yang.Z - Thursday, November 8, 2018 9:47 AM -
1 Votes
opening connection to external pervasive sql database, in SSIS package, taking 20 sec (when executing by dtexec)
I tried running multiple packages one after the other, but it still takes the 20 sec connection time in each package.Answered | 2 Replies | 6074 Views | Created by sreekumar kv - Friday, December 30, 2011 1:54 PM | Last reply by sreekumar kv - Monday, January 2, 2012 12:08 PM -
0 Votes
Audio Problems: losing audio every 20 secs for 2-3secs.
hi. i have a LenovoG560 laptop, windows 7 x64. my audio is in perfect condition and performance, then suddenly the problem starts.Answered | 3 Replies | 1134 Views | Created by Louis112121 - Tuesday, March 4, 2014 11:02 AM | Last reply by Dave Patrick - Wednesday, March 5, 2014 1:18 AM -
0 Votes
SSIS, create new textFile for every time i run my package
okay i tried that before. i was actually missing to include the complete timestamp to the textfile, so it will differnetiate every time it runs and creates new ...Answered | 2 Replies | 9096 Views | Created by Dkuud - Thursday, July 7, 2011 5:12 PM | Last reply by Dkuud - Thursday, July 7, 2011 7:03 PM -
0 Votes
How to create job from new query editor on sql server 2012 run every 20 seconds ?
Msdb Database is used by SQL Server Agent for scheduling alerts and jobs.Answered | 7 Replies | 696 Views | Created by engahmedbarbary - Sunday, November 3, 2019 8:32 AM | Last reply by Rachel_Wang - Wednesday, November 6, 2019 9:50 AM -
3 Votes
Scheduling SSIS package to run multiple times daily
Make a sql agent job that polls this table at time intervals(based on yout logic) and check if there is any job that has to be run . if Any ...Answered | 7 Replies | 5301 Views | Created by BPG16 - Friday, January 23, 2009 6:58 PM | Last reply by Ashwani Roy - Monday, January 26, 2009 1:05 AM -
0 Votes
timeout make it 20 sec
Hi Subbu, to get the current partner timeout values run this query SELECT Mirroring_Connection_Timeout FROM ...Answered | 2 Replies | 5132 Views | Created by subu999 - Monday, September 17, 2012 8:44 AM | Last reply by maddy28 - Thursday, September 20, 2012 3:56 AM -
1 Votes
Scheduling SSIS package to run on first day of every month
Thought this might help your cause...remeber to create a proxy account to run the ...Answered | 3 Replies | 4691 Views | Created by knra - Friday, December 14, 2012 3:19 AM | Last reply by Raunak J - Friday, December 14, 2012 9:33 AM -
1 Votes
Job Was scheduled every 3 months
I would like to see you opening new thread for different questions and that would be helpfule for someone else in future for solving their problem.Answered | 5 Replies | 5574 Views | Created by subu999 - Monday, February 1, 2010 2:14 AM | Last reply by subu999 - Monday, February 1, 2010 3:16 AM -
0 Votes
Tests/Sec vs Avg.
I have something even more weired.Answered | 7 Replies | 9549 Views | Created by Popsovy - Friday, March 26, 2010 7:52 PM | Last reply by Hal eh - Friday, July 15, 2011 9:09 AM -
2 Votes
Writing SSIS package to load data in new excel file every time it runs
I do have a simple select query in my OLEDB source like, select CUST_NAME from ...Answered | 16 Replies | 25871 Views | Created by UltraDev - Tuesday, June 25, 2013 6:12 AM | Last reply by UltraDev - Thursday, June 27, 2013 5:44 AM -
1 Votes
Create a new excel in every time SSIS package is executed
1) By block I mean that the alphabets are appearing in block letters even though my template file has nothing such declared in it.Answered | 19 Replies | 32380 Views | Created by Sweta Dutta - Thursday, March 26, 2009 11:53 AM | Last reply by jsorrisone - Friday, February 27, 2015 12:31 AM -
0 Votes
Select Data for every 12hrs from given time.
Hi, If your Range is fixed(7 AM to 7 PM and 7 PM to 7 AM), its pretty easy select * from table1 T1 Inner JOIN Table2 on ...Answered | 5 Replies | 2085 Views | Created by SQLServer2k8 - Thursday, June 14, 2012 8:22 PM | Last reply by Satheesh Variath - Friday, June 15, 2012 5:52 AM -
0 Votes
Can we schedule a out of box timerjob for every 30 sec instead a minute?
Hi, If you look timer job setting, least option we found is minutes not seconds.Answered | 1 Replies | 1622 Views | Created by Hitch's - Monday, October 29, 2012 2:18 AM | Last reply by amol.khairnar - Monday, October 29, 2012 5:30 AM -
1 Votes
press a key in every 10 sec ?
Start a new Windows Forms app and drop a Timer on it.Answered | 2 Replies | 3469 Views | Created by SFeri - Friday, January 2, 2009 7:11 PM | Last reply by SFeri - Friday, January 2, 2009 7:41 PM -
0 Votes
Archive a table every night using SSIS Package
Create a new table for run date using Execute SQL Task (reference the connection above).Answered | 4 Replies | 6457 Views | Created by antot - Monday, September 20, 2010 6:34 PM | Last reply by BI Monkey - Monday, September 20, 2010 11:47 PM -
0 Votes
Sybase tables data migration using SSIS packages
you can save this package and run it as a scheduled job .Answered | 5 Replies | 11331 Views | Created by zoomer - Thursday, March 31, 2011 2:24 AM | Last reply by abbikhan - Monday, July 11, 2011 9:03 PM -
1 Votes
Response Time (sec) Vs Elapsed Time (sec)
Because I know that the Response Time + Thinktime = Elapsed Time.Answered | 1 Replies | 4944 Views | Created by sPrasannaWalchale - Tuesday, April 28, 2009 10:01 AM | Last reply by Edilson Broock - Tuesday, April 28, 2009 6:18 PM -
0 Votes
SQL Server Agent Job Scheduler- Set time less than 10 seconds
If you have data arriving fast use a Windows Service to schedule it for execution, SSIS also is not going to process many things in parallel.Answered | 4 Replies | 3872 Views | Created by sat08536 - Thursday, August 14, 2014 8:50 PM | Last reply by ArthurZ - Friday, August 15, 2014 6:49 PM - Items 1 to 20 of 3866009 Next ›
No announcements
