Solved

Do While Loops Works in TSQL but not SSIS

Posted on 2013-06-26
5
456 Views
Last Modified: 2016-02-11
I am using a DO WHILE loop in tsql to populate two months worth of data with over 150 columns of information.  My query works in TSQL to where it displays all the information but I noticed that it is basically executing the query separately for each day in the two month timeframe.  I am guessing that is why when I try and run this stored procedure in SSIS to populate a new table it just writes the first record then finishes successfully.  I am guessing I should be using another statement besides DO WHILE or doing something different in SSIS?  Any feedback you can provide would be greatly appreciated.  Please advise.
0
Comment
Question by:Gary Harper
  • 3
  • 2
5 Comments
 
LVL 35

Expert Comment

by:David Todd
ID: 39280574
Hi,

I wasn't aware that there was a do ... while loop in T-SQL. Can you show us your code?

Regards
  David
0
 

Author Comment

by:Gary Harper
ID: 39290539
Actually it is a WHILE loop... Attached is a sample of my query... there are several more columns.  What I would like to do is loop through this x number of times and insert all these records into a table by date... How is this possible?
sample-query.txt
0
 
LVL 35

Accepted Solution

by:
David Todd earned 500 total points
ID: 39291239
Hi,

The problem is that the begin after the while is commented out.

simple while looks like this

declare @days int
set @days = 1

while @days <=  86 begin
    insert dbo.sometable
    select columns
    from dbo.someothertable
    where
        somedayscolumn = @days

    set @days = @days + 1

end

Open in new window


HTH
  David
0
 

Author Comment

by:Gary Harper
ID: 39291245
That is what I ended up doing since I didn't get a response.  I suppose this is the correct way to do it.
0
 
LVL 35

Expert Comment

by:David Todd
ID: 39291383
Hi,

Do you need further help?

Regards
  David
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question