Solved

Do While Loops Works in TSQL but not SSIS

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
My client has a dictionary table. They're defining a list of standard naming convention. Now, they are requiring my team to provide us a mechanism how to match new incoming data with existing data in their system.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

863 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now