SolvedPrivate

sql scripts

Posted on 2013-06-01
6
23 Views
Last Modified: 2016-02-11
i have a script that updates a field in the table.
i want to break the script into 4 parts.
how do i call the script one after the other without using a ssis package?
0
Comment
Question by:package_monkey
  • 3
  • 2
6 Comments
 
LVL 18

Expert Comment

by:Matthew Kelly
Comment Utility
How are you calling them now?

Generally, you could make them stored procedures, and then just have one script call each procedure.

Lots of examplese of stored procedures here: http://msdn.microsoft.com/en-us/library/ms187926(v=sql.90).aspx
0
 

Author Comment

by:package_monkey
Comment Utility
i have a package that executes sql tasks, it creates a  temp table.
next temp table is populated with the the values from 4 fields from the production table.
i update the table with another temp table which is created using inserts from the excel sheet.
then i use inner join to update the production table using the updated temp table.
my question is how do i break the scripts? i do not want to run the whole sucker as one script.
0
 
LVL 18

Expert Comment

by:Matthew Kelly
Comment Utility
The four scripts you want are:

1. Scripts

Creates a  temp table.

2. Scripts

Populate temp table with the the values from 4 fields from the production table.

3. Scripts

Update the table with another temp table which is created using inserts from the excel sheet.

4. Scripts

Use inner join to update the production table using the updated temp table.
You then want the single SSIS package you have to execute all four scripts in order when called?

To do that, the best method is to create four stored procedures, each one doing one step of the above tasks; then have the SSIS package call each of the stored procedures. You would also be able to call the stored procedures manually one at a time without the package as well.

Is it timing out? Is that why you want to break the scripts up?
0
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 

Author Comment

by:package_monkey
Comment Utility
i do not want to  run it in a one swing, as so many rows are being inserted and updated.
i do not want to cause any problem down the pipeline.
0
 

Author Comment

by:package_monkey
Comment Utility
it is a one time update. that is why i do not want to do it as a package or as a stored procedure.
0
 
LVL 25

Accepted Solution

by:
jogos earned 300 total points
Comment Utility
Split your script in 4 and then you have (besides running it in a sql-window) different options

Sql*agent
http://databases.about.com/od/sqlserver/ss/sql_server_agent_3.htm

SQLCMD
http://msdn.microsoft.com/en-us/library/ms162773(v=sql.90).aspx
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Over the last 2 years, I have been working on SSIS 2008. Really the tough tasks in SSIS are to deploy packages and pass parameters (Values from outside package). The latter is certainly a headache for developers, particularly for me. We had to ma…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

744 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

15 Experts available now in Live!

Get 1:1 Help Now