Search Results: File Properties

• 
  Checking a File in Use and File Compression in SSIS with Task Factory

  Checking a File in Use and File Compression in SSIS with Task Factory Getting compressed files from customer is a common occurrence in today’s database world. Decompressing and loading those files can be a lot of work, even in SSIS. Task Factory makes thi

  Author:  MikeDavis     Date: 6/8/2011     Section: Blog

  tags : Compression, File in Use, File Properties, Files, Task Factory, Zip, SSIS
• 
  Task Factory: File Properties Task

  Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating SSIS packages become more efficient. And as we all know, when we are more efficient, we are more productive. In this nugg

  Author:  briankmcdonald     Date: 9/3/2011     Section: Blog

  tags : Brian K McDonald, File Properties Task, task factory
• 
  Task Factory - TF File Properties

  My last video on the Task Factory Compression Task was well received, so I thought I’d build on it with a video on the File Properties Task. It’s a cool little tool that will grab any of the various attributes associated with a file. If you want to see mo

  Author:  arcanecode     Date: 7/19/2011     Section: Blog

  tags : SQL Server Integraion Services, SSIS, Task Factory, Pragmatic Works
• 
  Task Factory - Advanced E-Mail and SMS Task

  I've been continuing my learning process of my companies Task Factory suite. Building on my previous work with the Compression task ( video ) and File Properties task ( video ) I've now created a new video about the Advanced E-Mail and SMS Task. After com

  Author:  arcanecode     Date: 8/5/2011     Section: Blog

  tags : Pragmatic Works, SSIS, Task Factory
• 
  How to check whether source file exists or not in a dialy load package

  Saraswathi, This is a little more "advanced" because installing new SSIS components can be tricky if you're new to it. That being said, another good option to consider is "Task Factory" from Pragmatic Works. http://www.pragmaticworks.com/Products/Business

  Author:  KeithHyer     Date: 10/13/2010     Section: Forum

  tags : exist, file properties task, file, pragmatic works, task factory
• 
  How to use if else with flat file connection Expression in SSIS?

  I have one SSIS which takes data from .csv file and insert into sql table now my file name is Flat file properties and expression for connection string is : @[User::Directory] + @[User::Filename]+" "+(DT_STR,4,1252)DATEPART( "yyyy" , getdate() ) +"-"+ RIG

  Author:  ashuthinks     Date: 9/19/2011     Section: Forum
• 
  SSIS watch a folder and transfer the latest file from the folder

  Here is a WMI example: http://microsoft-ssis.blogspot.com/2010/12/continuously-watching-files-with-wmi.html And what details of the file are you talking about? Here is an example of getting file properties such as date, size, owner, etc. http://microsoft-

  Author:  SSISJoost     Date: 3/26/2011     Section: Forum
• 
  SSIS watch a folder and transfer the latest file from the folder

  This could be done with a script task or 3rd party tool like Task Factory to grab the file properties and then write it to a database from an SSIS variable. http://pragmaticworks.com/Products/Business-Intelligence/TaskFactory/Default.aspx .

  Author:  DustinRyan     Date: 3/25/2011     Section: Forum