View Complete Post
I could not find the exact details on how to create a SSIS script that would ftp files on these forums, so I am adding my code to help save time for anyone else that might be wanting to do something similar.ÃÂ Here is the VB code for my script task to FTP files (hope this helps someone):
' Microsoft SQL Server Integration Services Script Task
' Write scripts using Microsoft Visual Basic
' The ScriptMain class is the entry point of the Script Task.
I want to delete all files in a given folder that are older than 3 days from today's date.
I tried using a "Foreach Loop container"ÃÂ with aÃÂ "File System" task inside it but found I couldn't access any file properties such as the file creationÃÂ date. Am I using the wrong task forÃÂ this job?
P.S. History of the problem:
I used the sql 2005 Database maintenance program to setup our database backup jobs. One day I noticed that the free space on the drive where we keep the dumps had grown small. I foundÃÂ that we had at least 4 weeks of dumps in there, not the 3 days I wanted to keep!ÃÂ I lookedÃÂ but could not find the "delete file" optionÃÂ in the SSIS package generated by the Database Maintenance Wizard. No wonder the files were piling up.
I would like to move/copy some files between two SQL servers. The files are consist of .css .png .jpg and .gif files. I've tried to do this using the File System Task but I can't for the life of me work out how I point it to the servers file
system. I'm obviously not an SSIS guru, I had a play and can move files around my own PC from location to location, but can work out my server to server issue, I hope someone can help, or at least point me in the right direction.
I'm going from SQL2005 to SQL2008 if that makes any difference, but as I say its not SQL tables, data, or what not, it's simply moving files that happen to be stored on the two servers.
Thanks in advance
A one-off shot at using, SSIS, I appear to be missing something.
From what I have read here, the Foreach Loop Container in which a File System Task has been placed is how one copies files contained in a source server folder to a folder on a target server. I have defined Source and Destination pkg variables using
UNC \\servername\aharedfolder and a FileName variable that is empty. My impression is that this is suppose to iterate through and copies all files in the source folder to the target. I only get
the first file copied.
In the FLC Collection section I am using the Foreach File Enumerator under which I have the Folder as
\\servername\sharedfolder and files as *.* . I am not using Expressions. The Variables Mapping reference my FileName variable.
In the FST, I both path variables set to True and reference the destination and source variables described above. Operation is Copy File.
I appears that I need to pass a list of the source folder file names to the FileName variable, rather than some built-in logic grabbing a files in the source folder. Is a passed filename list what I am missing?
We have an website that have 3 libraries. The "first Library" is used only to edit documents and it's called "my documents". When a user finish of edit your documents here, they start a workflow that will check fields in the document and move the document
for the second library (using Sharepoint Designer Workflow - without custom actions).
In "second library" we have a big workflow. This WF has some steps for approve, collect feedback, generate sub-tasks and others things related for the document. This WF use many custom actions in (Sharepoint Designer).
When this WF arrives to the end, the document is moved to "third library", that is a official repository of documents in the enterprise.
The entire cycle works fine. But when someone creates a internal copy of the document in the "first library" to begin again the flow, we receive a Invalid Url error. It occurs when any update operations is executed over the document item, the value is conserved
but the error is displayed. After it, we can not execute other workflows over the item.
If we save the document in local disk, delete the library item, and then upload it again, the problem is solved.
Some one have an idea about why and how solve it? We are using WSS 3.0.
The following is an error registred in log file when you d
Hello, just wanted to ask a question about SSIS and SharePoint, any input will be greatly appreciated.... did search the forum but could not find anything....
So basically we have a SQL Server DB with the metadata ONLY, WITHOUT the related files(doc/ppt/pdf..etc) which should've been in the DB and they are on a separate web server inside folders. Each row in the DB has a key (column) which matches the related
folder's name, so for row with ID #112, there's a folder named ID112 on the web server with the relevant files inside. There could be more than 8+ files for one folder.
Now, I think it is possible but just wanted to double check, would it be possible to use SSIS and some kind of a script to get the metadata inside the SQL DB AND the related files inside those folders, combine & relate them and
upload them into SharePoint as a custom list with file attachments? would they display the attachment normally (like the paperclip icon in a sharepoint list...etc) I wonder if anyone has tried this...
Any guidance, thoughts, suggestions for other solutions, inputs will be great!!! Thank you!!