See if any files in a folder are lockedJet OLEDB driver refuses to open a linked table where the original has...
What is this mysterious *green square* on my Content Editor?
Isn't a semicolon (';') needed after a function declaration in C++?
C++ range based loop with special case for first item?
How does holding onto an active but un-used credit card affect your ability to get a loan?
Buying a "Used" Router
Why do single electrical receptacles exist?
What really causes series inductance of capacitors?
Python to write multiple dataframes and highlight rows inside an excel file
How can I give a Ranger advantage on a check due to Favored Enemy without spoiling the story for the player?
When distributing a Linux kernel driver as source code, what's the difference between Proprietary and GPL license?
What sort of grammatical construct is ‘Quod per sortem sternit fortem’?
How to transport 10,000 terrestrial trolls across ocean fast?
How many copper coins fit inside a cubic foot?
Have any astronauts or cosmonauts died in space?
Multiple null checks in Java 8
Is there a configuration of the 8-puzzle where locking a tile makes it harder?
Do the speed limit reductions due to pollution also apply to electric cars in France?
Will the duration of traveling to Ceres using the same tech developed for going to Mars be proportional to the distance to go to Mars or not?
Is there any way to play D&D without a DM?
What happens if both players misunderstand the game state until it's too late?
Is there any danger of my neighbor having my wife's signature?
How to make transparent background from pdf to png
How to deal with an underperforming subordinate?
Short story about a man betting a group he could tell a story, and one of them would disappear and the others would not notice
See if any files in a folder are locked
Jet OLEDB driver refuses to open a linked table where the original has a lock - any way to force this?Advice for ETL from Oracle to SQL Server?SSIS 2012 Ftp parallel/asynchronous multiple file downloadWhy would a job call a batch file with dtexec.exe instead of just calling the SSIS package directly?Repeated login issue SQL Server 2008 R2 (SSIS)SQL Server 2014 SSIS Package Ignores Script Task when running as AGENTSSIS: Check file for row delimiter and dynamicly update row delimiter in Flat File Connection Manager at run timeLarge Variation in Bulk Insert timeDetermine the PackageFormatVersion for multiple .DTSX packages files in a folderSSIS Not Executing any Script Task
I am able to check if a specific file is locked, but am needing to check if any files of a specific type are locked.
We currently use this as a single file solution LINK
The issue we're running into is there are a batch of files being put in a directory of the same file type, and we never know what the file names will be.
ssis ssis-2014
asked 4 mins ago
jdidsjdids
948
add a comment |
I am able to check if a specific file is locked, but am needing to check if any files of a specific type are locked.
We currently use this as a single file solution LINK
The issue we're running into is there are a batch of files being put in a directory of the same file type, and we never know what the file names will be.
ssis ssis-2014
asked 4 mins ago
jdidsjdids
948
Why can't you just put your custom script in a "for each" container?
– Mr.Brownstone
1 min ago
add a comment |
I am able to check if a specific file is locked, but am needing to check if any files of a specific type are locked.
We currently use this as a single file solution LINK
The issue we're running into is there are a batch of files being put in a directory of the same file type, and we never know what the file names will be.
ssis ssis-2014
asked 4 mins ago
jdidsjdids
948
I am able to check if a specific file is locked, but am needing to check if any files of a specific type are locked.
We currently use this as a single file solution LINK
The issue we're running into is there are a batch of files being put in a directory of the same file type, and we never know what the file names will be.
ssis ssis-2014
ssis ssis-2014
asked 4 mins ago
jdidsjdids
948
asked 4 mins ago
jdidsjdids
948
asked 4 mins ago
jdidsjdids
948
asked 4 mins ago
jdidsjdids
948
asked 4 mins ago
jdidsjdids
948
948
Why can't you just put your custom script in a "for each" container?
– Mr.Brownstone
1 min ago
add a comment |
Why can't you just put your custom script in a "for each" container?
– Mr.Brownstone
1 min ago
Why can't you just put your custom script in a "for each" container?
– Mr.Brownstone
1 min ago
Why can't you just put your custom script in a "for each" container?
– Mr.Brownstone
1 min ago
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230527%2fsee-if-any-files-in-a-folder-are-locked%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230527%2fsee-if-any-files-in-a-folder-are-locked%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Why can't you just put your custom script in a "for each" container?
– Mr.Brownstone
1 min ago