Who is online?  0 guests and 1 members
Home  »  search results

Search Results: File System Task

38 results found
  • FILE SYSTEM TASK/RENAME OF LOG FILE
    Hi, Thanks for responding...I have tried everything. I have even created a separate package with just the Foreach Loop Container with the File System Task and it works fine. It is only when I integrate it with the main package workflow. I have even tried
    Author: FSANCHEZ98 FSANCHEZ98     Date: 1/7/2010     Section: Forum
  • Copy and rename a file in SSIS using the File System Task
    "jampa.sb" asked a question about moving files around in SSIS using the File System Task and variables in the SSIS forum. Based on that question, I decided to put together a "Step-By-Step" walk through demonstrating how to do a portion of the issue. From
    Author: KeithHyer KeithHyer     Date: 1/12/2012     Section: Blog
  • Creating Checkpoints in your SSIS package
    Want to save your progress: add a checkpoint to your package. Checkpoints are added onto your control flow to ensure that if your package fails after multiple tasks have succeeded, the progress you have made will not be lost. Say you are doing a Data load
    Author: DanMatisis DanMatisis     Date: 6/5/2010     Section: Blog
  • Illegal character in File Path
    bluize76 said: This is the error that I get now..... Error at File System Task [File System Task]: An error occurred with the following error message: "Failed to lock variable "I:\DEPARTMENTS\Business Management\Business Intelligence\Initiatives\ScopingDB
    Author: KeithHyer KeithHyer     Date: 8/24/2011     Section: Forum
  • Illegal character in File Path
    I think I may have missed one step in my instructions there. ** Set the source to the variable one more time ( since it's replacing it with the path/file ) and.. THEN delete the expression(s) on the File System Task. Save it in this new state. The express
    Author: KeithHyer KeithHyer     Date: 8/25/2011     Section: Forum
  • Move and Replace Files HELP
    You will need a for each loop and place a file system task in side of it. Create a variable named strFile Name. Map the for each loop results to this variable. You will need to set the file filter to something that will only pick up the files you want. In
    Author: MikeDavis MikeDavis     Date: 2/3/2011     Section: Forum
  • Delete All Files Except with a Certain File Extension in SSIS
    I came across a situation today where I needed to prep a file directory for some work later on in an SSIS package. I needed to delete all the files in a folder that did not end in a specific file extension. I know a lot of people would probably take this
    Author: kylewalker kylewalker     Date: 1/25/2011     Section: Blog
  • Help on SSIS
    This can be done with one data flow and a file system task. In the data flow read in the excel file. (Excel Source) Then use a lookup transform to check the table for matches. Map the matches to an oledb transfrom to update the table. Map the non matching
    Author: MikeDavis MikeDavis     Date: 12/10/2010     Section: Forum
    tags : Excel, SSIS
  • FILE SYSTEM TASK/RENAME OF LOG FILE
    Hi, I am getting the following error toward the end of the master workflow when renaming and moving the error log file that is used by the child packages. Prior to the execution of the File System Task, the main workflow is executing several of the child
    Author: FSANCHEZ98 FSANCHEZ98     Date: 1/5/2010     Section: Forum
  • Variable Best Practices in SSIS
    Learn some of the best practices when using variables in SSIS.
    Author: MikeDavis MikeDavis     Date: 1/5/2010     Section: Article
  • SSIS For Each Loop over file with Date in Name
    Learn how to loop over files with a date in the file name and filter based on this date. This is done with no script task.
    Author: MikeDavis MikeDavis     Date: 11/29/2010     Section: Article
  • Illegal character in File Path
    Ah. Ok. Try this - Right-click your File System Task and go to properties. In the properties window, scroll down until you find "Expressions". Click on either the "+" to expand it or click in the box next to it and an "..." button will appear. Click that
    Author: KeithHyer KeithHyer     Date: 8/25/2011     Section: Forum
  • Illegal character in File Path
    Puzzling. I just set up what you described and it worked fine for me. Here are the screenshots of what I did - maybe you can compare settings to make sure there isn't a difference? First, I set up the variables like this: Then, I set the properties on the
    Author: KeithHyer KeithHyer     Date: 8/24/2011     Section: Forum
  • Illegal character in File Path
    Ok, here is a quick 3-step to correct it - everything else looks good. Right click and "Edit" your file system task. Click inside the "Destination Variable" text - anywhere should do. A drop-down arrow should appear to the right of your ( what is currentl
    Author: KeithHyer KeithHyer     Date: 8/25/2011     Section: Forum
  • Zipping Multiple Files Into One Archive in SSIS
    When archiving files, it is common to encounter the need to zip multiple files into one archive. This can be easily done with the help of Task Factory. For this example, I will use a file system task, the Task Factory Compression Task, and a ForEach Loop
    Author: ShawnHarrison ShawnHarrison     Date: 11/28/2011     Section: Blog
  • Rename Files Name
    Use a for each loop to go through the files. Then a File system task to rename them. You will need to use expressions and variables to alter the file name. The source in the file system task will be the variable from the for each loop. The destination wil
    Author: MikeDavis MikeDavis     Date: 10/26/2011     Section: Forum
  • Using Expressions to add Dates to the end of Files
    Archiving files can be a chore, especially when you want a clear and precise way of telling when the file was archived without having to worry about looking at details like "Last Modified" and such. Not to mention it is often times best practices to have
    Author: Tyler Tyler     Date: 10/31/2011     Section: Blog
  • Manipulating Files with SSIS
    One of the most common reasons to use SQL Server Integration Services (SSIS) is to import data from or export data to text files. Maybe the data in these files is delimited by pipes (|) or commas. Maybe the files are in XML format. Regardless of the type
    Author: KathiKellenberger KathiKellenberger     Date: 11/12/2012     Section: Blog
  • Using Database Transactions across multiple SSIS Tasks
    If you experiment at all with transactions that are built into SSIS you will discover that they are highly flawed. For example, if you have a transaction running on an entire package some tasks may not rollback on a failure. A file system task is one of t
    Author: DevinKnight DevinKnight     Date: 3/2/2010     Section: Blog
    tags : SSIS
  • Expression for Sources and Destination in SSIS
    When setting up a Source and Destination in SSIS one of the common features to uses is the expressions. This makes your packages dynamic and your connection can update based on programing logic. If this is done incorrectly you will see the error "Non Fata
    Author: MikeDavis MikeDavis     Date: 11/12/2009     Section: Blog
  • SSIS from the Ground up: Part 2 – The Control Flow
    This blog series will cover SSIS from the group up; beginning with the BIDS environment and going all the way through package deployment. Please feel free to message me or email me if there is a specific topic you would like addressed. Tune in each week t
    Author: BradSchacht BradSchacht     Date: 5/14/2010     Section: Blog
  • How to migrate Scripting.Filesystem objects used inside ActiveX script to SSIS equivalent task/code?
    Generally developers use Scripting.FileSystem object in ActiveX script task to perform various file system related tasks (e.g. Copy file, Delete file etc.). In SSIS you can perform many file system related common tasks using File System task . You should
    Author: BrianKnight BrianKnight     Date: 11/7/2009     Section: Blog
  • File System Task fails when run as job by SQL Agent Service Account
    It is definitely a permissions issue. You can use a test package a try just renaming the file at the source and then at the destination to test to see if it is the source or the destinatio permission issue.
    Author: MikeDavis MikeDavis     Date: 3/2/2010     Section: Forum
  • File System Task fails when run as job by SQL Agent Service Account
    I'm executing a package w/ a File System task that moves a file from an ftp server to a staging server. The package works fine from my desktop, 32bit, with my credentials even though it's using a share as source ( \\server\ftpshare\file.csv ) and a UNC pa
    Author: gharwood gharwood     Date: 3/2/2010     Section: Forum
  • Dynamically select earliest date file
    Assuming you are going to do this dynamically in a File System Task, you would use variable based on an expression for the Destination something like: "C:\\YourFolder\\"+ (DT_WSTR, 4) YEAR( GETDATE() )+ RIGHT( "0" + (DT_WSTR, 4) MONTH( GETDATE() ) , 2 ) +
    Author: timmurphy timmurphy     Date: 8/23/2011     Section: Forum