Search Results: Foreach Loop

• 
  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     Date: 1/7/2010     Section: Forum

  tags : Archive, Foreach Loop Container, Rename File, Variable Expression
• 
  how to set for each loop execute one time

  Moving the file won't do anything for that situation. The ForEach Loop will only process a file one time in each run of the package. The only way that the file would be imported 4 times is if you have 4 copies of the file on the file system, you are actua

  Author:  BradSchacht     Date: 9/15/2010     Section: Forum

  tags : Excel, loop, ssis
• 
  Copy a folder from FTP to local/shared drive

  Here is a tutorial to help you out with FTP task. By your description, your control flow will be something similar to: 1) create variable with the path from FTP 2) add a FTP and a Foreach Loop so you can loop in all .csv files from that path. here is a li

  Author:  marcoadf     Date: 3/5/2012     Section: Forum

  tags : container, files, foreach, FTP, loop, rar, SFTP, winrar, zip
• 
  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     Date: 1/25/2011     Section: Blog

  tags : File System Task, Foreach Loop, SSIS
• 
  Adding Files to a Running ForEachLoop

  I ran into an issue yesterday that turned out to be a small topic, but very important. The package that I had created was a group of loops to bring in files for an import process for the client I was working for. The files were compared to a list in a dat

  Author:  BradSchacht     Date: 5/12/2010     Section: Blog

  tags : ForEach, SSIS
• 
  HRESULT E_FAIL Error when trying to add Breakpoints

  I ran into a small problem this morning when trying to test an SSIS package. I simply wanted to add a breakpoint to a Foreach Loop Container to pause the package at the beginning of each iteration of the loop. Pretty straight forward, yes? Well I thought

  Author:  kylewalker     Date: 8/12/2011     Section: Blog

  tags : Breakpoints
• 
  Are there really 4 SSIS Containers?

  We all know about the Control Flow tasks for the three containers (For Loop Container, Foreach Loop Container and Sequence Container): Are you aware that there is a 4th container that you can't see in the list of tasks? It is called the Grouping Container

  Author:  SMcDonald     Date: 10/29/2010     Section: Blog

  tags : Grouping Containers, Pragmatic Works, Sherri McDonald, SSIS Containers
• 
  SSIS Package Containers- Part 5: Foreach Loop Containers

  The Foreach Loop container is used to loop over a collection of objects or files. AS it loops over the collection of objects, it will assign the value of the connection to a variable. This variable could then be used by objects within the container. Here

  Author:  DonnyJohns     Date: 3/25/2011     Section: Blog

  tags : SSIS Package Foreach Loop Containers
• 
  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     Date: 1/5/2010     Section: Forum

  tags : RENAME FILE, FILE SYSTEM TASK
• 
  dynamically execute child package

  Here is an alternative to dynamically calling a child package. I have created a parent package that is designed to call all of the child packages. I get the list of packages from a table that i have created in the source database. The name of the package

  Author:  FSANCHEZ98     Date: 12/29/2009     Section: Forum

  tags : app.LoadPackage, Package Configurations, Calling Child Package
• 
  FTP TASK in SSIS - Need help

  First you'll need to get a list of the files on the FTP server: http://www.mssqltips.com/sqlservertip/1641/get-list-of-files-from-an-ftp-server-in-sql-server-integration-services/ You'll stage the list of the file names. Then you can use a ForEach Loop to

  Author:  DustinRyan     Date: 3/15/2012     Section: Forum
• 
  .Execute method works in dev/BIDS but not on the production server

  I have a "master" package that uses a script task within a foreach container to examine source files for size and "freshness". The foreach loop gets the collection of files to examine from a query against a SQL table. If the source file passes muster, the

  Author:  Christian     Date: 6/28/2011     Section: Forum

  tags : execute package task, microsoft.sqlserver.dts.runtime, script task
• 
  send mail task

  KathiKellenberger said: Are you using a ForEach Loop to delete every file in a folder? If so, you could have a variable to count the number of files as they are deleted. For SSIS 2005 and 2008, you will need to add a Script task to the loop and increment

  Author:  Toufeeq     Date: 9/4/2012     Section: Forum
• 
  Question: how do I make acopy of ssis packge

  I think you are asking how to read and coy the dhs files, correct? You can use the ForEach loop to iterate the files in a folder and then inside the ForEach Loop container do whatever you need to do with them. Here is an article on how to use the ForEach

  Author:  KathiKellenberger     Date: 9/8/2012     Section: Forum
• 
  On connection fail go to next

  Hi all, I have a simple SSIS package that reads a table with a list of servers. Then has a Foreach loop to grab some data about each server. The problem i have is, that at some point, one of those servers in the list will be turned off (it includes dev en

  Author:  staggerlee011     Date: 4/3/2013     Section: Forum
• 
  SSIS Sequence Container

  hi All, I am using 2 sequence container and one foreach container inside a top level Sequence container in my package . My requirement is, if one of the sub Sequence container or foreach loop fails then all the sub contianer and foreach loop has to rollba

  Author:  joy_sen     Date: 12 days ago     Section: Forum
• 
  Delete/Move files based created date

  In your ForEach loop, use a Script task to check the creation date. You can use something like dim sFilePath as String = Variables("filename").Value dim fi As FileInfo = New IO.FileInfo(sFilePath) From here you can play around with what you need. Please n

  Author:  sqlchicken     Date: 7/14/2011     Section: Forum

  tags : scripting, ssis
• 
  ETL for Excel Workbook with multiple sheets

  Objective: Load column based data from multiple Excel sheets within a workbook. I have completed the following: 1) Written a script task to extract and store the sheet names in a variable User:ExcelTables 2) Created a ForEach Loop container to use the abo

  Author:  towen     Date: 5/10/2011     Section: Forum

  tags : Excel, multiple sheets
• 
  Splitting Raw Files to Fill in Missing Date Ranges

  What combination of tasks could I use to split one Raw file into multiple raw files based on primary key? I've got a 5M record table which holds inventory for each part number for every period dating back from 2006. There are over 221K unique part numbers

  Author:  aabundez     Date: 8/26/2011     Section: Forum

  tags : Raw Files
• 
  Executing a stored procedure after loading all the files into a table

  if I understand you when you load data_account and data_component and data_agent for one day you want stored procedure to be excuted. Am I right? If so I think you want one foreach loop contains three data flow task one for data_account, one for data_agen

  Author:  Elmozamil     Date: 12/26/2011     Section: Forum
• 
  Looping over Excel Files Using For Each Loop Container

  As Rob said, you only want to set the expression on the ExcelFilePath. There should be no expression on the variable that is populating that or on the ConnectionString. You are likely going to have to delay validation on that data flow task inside the For

  Author:  BradSchacht     Date: 9/5/2010     Section: Forum

  tags : Excel Source, ssis
• 
  SQL Maintenance Plan Doesn't Delete Backups

  I recently created a maintenance plan for our server to backup all the databases on a daily basis. In the cleanup step I set it to delete backups older than 7 day. I let the plan run for a week and checked on it to make sure the old backups were being del

  Author:  BradSchacht     Date: 12/8/2009     Section: Blog

  tags : Maintenace Plan, SQL
• 
  Can I use a system.object variable as a stored procedure parameter in SSIS?

  I get a list of files from the FTP Site into a System.Object package variable, as an array. I know I can loop over them using the Foreach Loop Container, within which I can INSERT INTO ImportFile <<File name>>, etc. However, I'd like to INSERT

  Author:  SAinCA     Date: 5/27/2010     Section: Forum

  tags : Stored Procedure, SSIS
• 
  create ssis package with multi r=task

  My recomendation would be to make a separate data flow for each of the different files. If you have 3 different formatted Excel sheets then you would need 3 data flows. Unfortunately SSIS is very rigid in the data flow area. The next thing I would do it c

  Author:  BradSchacht     Date: 9/2/2010     Section: Forum

  tags : SSIS
• 
  Best way to upload files into different database tables

  When you say "However if the new file is added to the folder again i need to modify the pacakge to include another dataflow." do you mean the new file is: 1. Another .txt file with the same name (ie, tblb.txt) but different columns 2. Another .txt file wi

  Author:  BradSchacht     Date: 9/3/2010     Section: Forum

  tags : FlatFile, SSIS