Who is online?
0
guests and
2
members
Member login
|
Become a member
Home
Articles
Forums
Blogs
Jobs
Events
Files
Spaces
People
login
register
Home
» search results
Search Results: loop
234 results found
Replacing Cursor in SSIS
yes, you were clear. Ok, than I would suggest you to insert in your dts: 1. SQL Task with your atual select that populate the cursor and return a resultset You should configure Resultset to Full result set. In this way you can return you query into a Vari
Author:
marcoadf
Date: 1/24/2012 Section:
Forum
tags :
container
,
each
,
for
,
full
,
loop
,
result
,
resultset
,
set
,
SQL
,
task
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
SSIS Skip Certain Files in a For Each Loop
When running a For Each Loop through a set of files, sometimes you will have specific files that you do not want to load. For example, I have a set of files named: Abc.txt Mno.txt Rts.txt Wln.txt Xyz.txt If I want to skip the file that starts with “W” the
Author:
MikeDavis
Date: 3/26/2010 Section:
Blog
tags :
Expressions
,
For Each Loop
,
Skip Files
,
SSIS
Loop Through Excel File in SSIS
You can loop through excel files using SSIS. This will use the For Each Loop container and a Data Flow task. First create a variable named strExcelfile as a string variable; you can leave the value blank. Next, drag in a For Each Loop. Set the enumerator
Author:
MikeDavis
Date: 5/5/2010 Section:
Blog
tags :
Excel
,
Loop
,
SSIS
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
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
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
Date: 11/29/2010 Section:
Article
tags :
date
,
For Each Loop
,
SSIS
Exit For Each Loop... ?
SchaffnerC, I don't see why you couldn't use a for loop to check for the value of a variable. Call it rolling_number or whatever you want. You could store the current rolling_number variable and you would increment it by what is the current value in the i
Author:
briankmcdonald
Date: 7/5/2012 Section:
Forum
tags :
Brian K McDonald
,
briankmcdonald
,
for each loop
,
For Loop
,
SQLBIGeek
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
Date: 2/3/2011 Section:
Forum
tags :
for each loop
,
ssis
.PDF Source
tooba - Since you're just after the file names, you might consider creating a table and then using a for each loop container configured for files to load the filenames into your table. To get rid of the .PDF extention for your JOIN key, you could use the
Author:
KeithHyer
Date: 10/21/2011 Section:
Forum
tags :
for each loop
,
joining two sources
,
REPLACE()
Using SSIS to create a report to show backup share folders, their size and file contents
There are many ways to skin the proverbial cat, but I'll take a stab at this one. webtechie said: Question# 1) How do you iterate through share folders on a server? Maybe nested for each loop containers? The outer one might be a for each row in an ADO rec
Author:
KeithHyer
Date: 5/11/2011 Section:
Forum
tags :
Conditional Split
,
file system
,
For Each Loop
,
iteration
,
merge
,
SSIS
ssis package execute date
Yes, no question about that. Why dont you import your excel data into a object variable and loop (Foreach Loop Container using Foreach ADO Enumerator) through it's values? Inside the loop insert a "Execute Package Task" wich will be the value in the excel
Author:
marcoadf
Date: 2/15/2012 Section:
Forum
tags :
Foreach Loop Container
,
loop
How to iterate over package precedence constraints programattically?
I am trying to iterate over all the precedence constraints in one of my packages. I can iterate through everything else just fine. Even the precedence constraints for containers (sequence, for loop, for each...). I dont see a way to get the precedence con
Author:
MrPerson
Date: 7/21/2010 Section:
Forum
tags :
api
,
constraints
,
integration services
,
loop
,
package
,
precedence constraints
,
programmatically
,
ssis
,
task
,
taskhost
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
SSRS Report Catalog Path
This has a few loops in it ( not cursor, but a WHILE loop ) - but it might do what you're after: NOTE: The contents of the ReportPaths table gets modified with this method - so make sure if you use this method, you're using a COPY of your report paths tab
Author:
KeithHyer
Date: 10/25/2011 Section:
Forum
tags :
CHARINDEX()
,
REVERSE()
,
SUBSTRING()
Making the SSIS Data Reader Source Query Dynamic
As long as all of the tables have the same structure, Mike Davis posted a blog a while back that shows you how to set up a command within a "FOR..EACH" loop container. The blog can be found here: http://www.bidn.com/blogs/MikeDavis/ssis/156/using-a-for-ea
Author:
KeithHyer
Date: 8/3/2011 Section:
Forum
tags :
dynamic data source
,
Foreach Loop Container
,
ssis
SSIS For Loop Containers Part 1
In a previous blog I talked about the Sequence Container, and some of its uses. To continue with that theme I now bring you the For Loop Container. The For Loop is one of two Loop containers available in SSIS. In my opinion it is easier
Author:
TomLannen
Date: 3/30/2012 Section:
Blog
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
Free SSIS Training - SQL Lunch #24 (Looping in SSIS)
Join Brad Schacht this week on the SQL Lunch to learn about Looping in SSIS . Go to SQL Lunch and add this event to your calendar or use the link in this posting. To receive notifications about upcoming SQL Lunches please go here . Every week this month w
Author:
PatrickLeBlanc
Date: 7/7/2010 Section:
Blog
tags :
Speaking
,
SSIS
,
SQL Lunch
Using For Each
loop
to Loop through Files in SSIS
When you have a set of files that you need to load into a database, a For Each Loop in SSIS can help with this process. The first thing to do is drag in a for each loop into the control flow of your package and set the properties of the tasks. Let's say w
Author:
MikeDavis
Date: 11/12/2009 Section:
Blog
tags :
Using For Each loop to Loop through Files in 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
Can I use a system.object variable as a stored procedure parameter in SSIS?
Right, the loop would not get the contents of the file, just the file name. Then have an execute sql task in the loop, using the new variable with the current file name in the loop.
Author:
MikeDavis
Date: 5/27/2010 Section:
Forum
tags :
Loop
,
SSIS
Error handling in SSIS! Help!
I did not see an attchment. But there are several questions. Do all three files have the same structure/Meta Data? If yes then you can use a for each loop. If not then you will need three seperate data flows. There are several SSIS examples on BIDN.com ht
Author:
MikeDavis
Date: 6/30/2011 Section:
Forum
tags :
ssis
size and row count of a table in database in ssis
Use a for each loop on the SMO objects and select the table names as the objects. Map the tabe name to a variable. Then use an Execute SQL task in the for each loop to get the desired from each table. The SQL query will contain a parameter with the table
Author:
MikeDavis
Date: 2/6/2012 Section:
Forum
tags :
loop
Page 1 of 10 (234 items)
<< Prev
1
2
3
4
5
6
7
8
9
10
Next >>
Go to page:
[Go]