Need to process all the files from folder... Take one file at a time and pass on to "Data Flow Component"...After processing move the file to some other folder and and send email alerts as to how much records got processed. and start processing of another file till the folder is empty.
View 1 RepliesI would like do this in a script task. For example i would like to be able to do something like this:
For each file as file in strDirectory
file.delete
next file
My program needs to monitor two folders and if any files arrives in any of those it needs to be processed.So i created two filewatch tasks & the OnChanged event for both This does not work when the files are already in the folders before i start to run my program.It works for just the new files coming in.having a for each loop files loop in the onChanged event will this work I would like to know what's the best way to achieve this
View 1 RepliesMy DBA has several SSIS packages that he would like the functionality of providing the end user with a way to input values for variables in the package. What would be the best solution for creating an application that would take the user input and pass the data through to the SSIS package variables?
I can get this work locally using this code
Dim packageName As String
Dim myPackage As Package
Dim integrationServices As New Application
[code]....
Problem is this requires that the user have SSIS installed locally.
in the current project im making i've decided to add in some tools, 1 of which is a renamer based of a renamer app that already exists (called scdtoolz), i want to build my own version of it so i can learn some new things, and build a nice GUI version of it.[code]So what i have managed to determine is that the current app scans the folders contents for the CRC32 Checksum, and renames based of that, since the 456.bin's CRC32 Checksum was 2274F80B, and in the text file 2274F80B is found here 'WWF - Rage in the Cage (T-81015)(U)#2274F80B#'So now i have determined game identification is based of the CRC32 checksums, how would i go about coding a similar ap in vb.net?first i need to make the app scan a folder, but how to return crcchecksum? and then rename if check = XXXX? If MD4 sums are easier/simpler i can use those instead, im lookin at a few hash app sources now, so i think i can see how to get the md5 but not the crc32 yet, or how to rename the 2 files and folder based of the text file.
View 6 RepliesI wrote an application that copies files from Folder(A) into Folder (B) First it checks if the files exists if yes it will copy them and it will over write the them in fodler (B) and is working great , but if I have a file in Folder(B)that is located in a subfolder the file inFolder (A) will not be copied to the new location.
belwo is the code to copy the files if they exist :[code..]
I am trying to create a datagrid and export the contents to a text file using VB.NET and I am doing this inside an SSIS script task in order to automate the process to export a dynamic table to text file. I don't get any error and the files are created but the files are empty. [code]
View 2 Repliesi am using vb.net to program and process some files.I pick files from one folder process them and once i process them successfully i should store them in a different folder. when i do fi.move(destination folder) i get an error message saying "THIS FILE IS USED BY ANOTHER PROCESS" below is my code
[Code]...
I need to read a dtd file using vb.net for processing the xml elements. How to do this?
View 3 RepliesI have a .NET customer framework that functions much like a Workflow. It uses reflection to get a listing of all of the processes it is capable of from a specific folder, and starts them via reflection with a known start point (all of them have a method called "Process"). Since these files are only called to do the processing and not part of the compile... is there a way for me to be able to drop in a new reference library (DLL) for one of the processes that is being updated without restarting the whole process?[code]...
View 1 RepliesI'm trying to keep the oldest file and move the new ones to a different directory
View 7 RepliesI have created tool which performs batch processing on files that are selected. The sub routine I have defined in the code, now I want to implement a way through which I can select actions that I want to perform and then perform the actions. For example the list has multiple actions, like Open, Close, SaveAs, Resize, Color Correct etc. I should be able to select what all I want to do on each file and then perform this actions. Someone suggested me using delegates for this, but I cant use that since all my functions have different parameters. Ither option I had is to use a nested IfElse or Switch to determine which action is selected and call function according to it, but thats to heavy I think, is there any optimized a better way to do this.???
View 2 RepliesI am currently creating a merging program which is processing multiple text files with header. I've manage to merge the text files but I'm stuck with the header that needs computation.
path of input files and header explanation: Input Files
After merging, I need to put back the header, adding up each values, which I explained in the path above. How can I do that?
Here's my current code:
Imports System.IO
Public Class Form1
Dim openFolder As New FolderBrowserDialog
'The routines must be
[Code] .....
I created a simple VB application in Visual Studio 2010.My computer, which I am using to create the program, is Windows 7 Pro, and SQL Server 2008 is running on a Windows Server 2008 Enterprise, which I have full access to.
I want to click a button and have an SSIS package execute.I looked around on the Internet and found examples, but they do not seem to work for me.I try to add a reference, Microsoft.SqlServer.ManagedDTS.dll, as a few sites advise, but it is not listed when I go to PROJECT>ADD REFERENCE.
I also type:
Imports Microsoft.SqlServer.Dts.Runtime but all I get is a squiggly green line, which when hovered over states "Namespace or type specified in the Imports 'Microsoft.SqlServer .Dts.Runtime' doesn't contain any public member or cannot be found." Below is some code I copied from one of the websites and pasted in my button click event (the path is correct), but a get blue squiggly lines under "Package" and "DTSExecResult":
Dim pkgLocation
As String
Dim pkg As
New Package[code]....
What can I do to make the SSIS package run when I click the button on the Windows application a created?
I need a script that will check files in a certain folder (lets call it folder1) against files in another folder (folder2), if there are any new files, or changed files it updates them in folder2.
View 2 RepliesI need to watch onr folder using filesystemwatcher when a file is come in i have to send the file to websservice and recive processed file i done this. my question is if at the time 20 or 30 files come in how to do this 1 by 1 the webservice takes time to process its depends on the file size. so how to process 1 by 1 files correctly without crashing.
View 3 RepliesUsing windows xp. Sp3. over 100GB free on each disk that I use,Attempting to unzip a file that has directories in it. I want all files in the zip file to go to one directory ignoring the dir structure.I'm using VB to do this. Problem is that the process hangs at the same place on 2 different machines. Any ideas. Code below in vb and the results.Executing the same command line from DOS works correctly.unzips 72 files then hangs.
Code
newProc.StartInfo.UseShellExecute = False
newProc.StartInfo.CreateNoWindow = True
[code]....
Here's where it stops. And shows the dir struct of the zip file NDDF Plus DB. i've got a screen shot of the dir structure and files. basically it unzips the files in order of the dir structure and stops above.
I am using the FilesystemWatcher to look for files in a Directory, it does not matter what the file is. After a file appears it starts my ftp process and I end up with a bunch of 0 byte files because it processed before all the files arrived.
I would like to WaitFor... (Files_Created) to finish but dont seem to have the right syntax to get this to work properly. I have working code up until it loops. As you can see I have tried various processes to get it to work... mostly commented out. I also have imported just about everything trying to get this to work. Please ask away.
Imports System Imports System.IO.File Imports System.IO Imports System.Threading Imports System.Collections Imports System.Collections.Specialized Imports System.Diagnostics Public Class FileSystemMonitor Public Shared Sub Main() Dim fsw As New FileSystemWatcher() ' create an object of FileSystemWatcher ' set properties of FileSystemWatcher object
[code]....
I just learned some basics of multi threading in VB.net recently as I came across processing a large List of records and inserting them into SQL database one by one.
I have code look like this:
Private Sub btnLoadNow_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLoadNow.Click
Dim autoLoad1 As New Thread(AddressOf AutoLoad)
autoLoad1.Start()
[CODE]...
Itemlists is a global lists i retrieved from database, everything looks fine to me but when i run this program, I found that the threads are inserting one records 9 times into the database(I have 9 threads in total), which makes me think that maybe i need to specifically assign 1/9 of a list to each thread? Is there another way to do it which doesn't require the splitting of the list, if not , how do i split it then assign?
2008 Array Processing and Sequential File Processing
View 14 RepliesIm a college student and this is my first programming class, i am having extremely diffcult time with arrays and sequential file processing. Im not asking for the whole program, just something to get me started and hints along as i progress with it. Please help me get started on my program, its due in 2 days.
Here are the requirements....
1. The program must input any number of individual�s last and first names using two separate textboxes.
2. The array of names must be sorted by the last name using a bubble sort. You must code the sort.
3. The program must be able to recall the names from the file and add to the existing list of names so that more names can be added to, sorted, and written back to the file in sorted order.
4. Sort in ascending order: A to Z
5. All names must be displayed in a listbox in sorted order when the user wishes to see them.
6. In the listbox the last and first names must be separated by a comma and a space. Example: Smith, Mary
7. The user must be able to search for a name in the array, using the binary search algorithm. You must code the search.
8. Do not use module-level variables. Instead you may choose to use Static.
9. The program must be designed using Visual Basic 2008
I am using Visual Studio 2008 Setup project. I need to copy one folder and the sub folders into the program files but when I tried to copy or add the folder to "Application Folder" in File System editor, I am able to add only files and not folders.
View 1 Replieshow to change the install folder path in a setup and deployment project/Installer class from program files to C:usersPublic in windows 7 and allusers folder in xp.Want to add MVP with my name.
View 3 RepliesI have made this installation program and everything work just fine, but I wish to improve it a little. Atm. all the files being installed is in a seperate folder, and the installation program simply move them to the right location.There is a builder program too.I would like it to add all files from a list to the programs resource.folder instead of a seperate folder.Atm I add the installation file to the destination folder with the following line. [code]
View 2 RepliesCode so far:
Private Sub Button6_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button6.Click
If FolderBrowserDialog1.ShowDialog = Windows.Forms.DialogResult.OK Then
End If
End Sub
I have managed to get drag and drop working if this is any help:
Private Sub ListBox1_DragEnter(ByVal sender As Object, ByVal e As _
System.Windows.Forms.DragEventArgs) Handles ListBox1.DragEnter
If e.Data.GetDataPresent(DataFormats.FileDrop) Then
[code]....
I am wanting to get a complete file/folder listing and then copy these files to another folder.
Here is my
[Code]...
This happens on many folders. How can I get a listing of these folders and also copy these files?
So I've been using some code to generate directories and such in a custom treeview, but am looking to expand upon this idea. While it's not using recursive functions, and only calls functions when expanding levels, I'm not quite sure how to put some of these together.find a way to just search through all folders on the PC. If the folder contains audio files, that folder is than added to an array (searching a folder for audio files and adding that folder to an array is done). It's just recursivly searching all folders on the PC.Here is the code I've been using for the treeview (I'm not sure if it can be adapted):
Public Function ListAllDrives() As String()
Dim arDrives() As String
arDrives = Directory.GetLogicalDrives()[code].....
Basicly I'm downloading XML files with the Webclient class for processing and caching in a local database. There are three different categories of data, each contains 1 to n numbers of XML files. To retrieve the XML file I ask the server with following parameters in the URL:
[Code]...
Basically I am trying to enable the user the ability to select a folder and the folders music files populate a list box. I want two list boxes on the page, one with all the contents of the folder and then the other one for files selected from the first box. I have no clue on how to do this at all...
View 4 Replieswhat im trying to do and what i have done so far is probably a little backwards not sure sure how to id it any other way.when the user generates an error because a particular file doenst exist ive got my dialoge box to generate an .txt file for each file it errors on, so that the administrator can check and update missing files as an when - shouldnt be many files missing in the first place, should just be new product ranges or item just launched.what im stuck on is:
1. is there a better way
2. how do i open a .txt file and add the extra lines to it, so i re use the file but keeping the previous data.