Solved

Do While Loops Works in TSQL but not SSIS

Posted on 2013-06-26
5
465 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
My client sends data in an Excel file to me to load them into Staging database. The file contains many sheets that they have same structure. In this article, I would like to share the simple way to load data of multiple sheets by using SSIS.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
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 …

840 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