Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

store qeury count in variable ssis

Posted on 2015-01-16
2
Medium Priority
?
160 Views
Last Modified: 2016-02-15
Hello
Within SSIS, how can query a table for row count and then store it in a variable within the script task?
Thank you
0
Comment
Question by:Rayne
2 Comments
 
LVL 15

Accepted Solution

by:
Vikas Garg earned 2000 total points
ID: 40554930
Hello,

Why you are looking for script task when this can be simply done using execute sql task

using simply Select count(1) from table

and store the single result set into variable

SSIS
0
 

Author Closing Comment

by:Rayne
ID: 40562339
thank you Vikas
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

This is an article on how to answer questions, earn points and become an expert.
I came across an unsolved Outlook issue and here is my solution.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

569 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