May 4, 2011 at 8:51 am
Hi everyone,
i am new to sql server 2000, at the moment i have a table called "Temp" i want to have a package that would allow users to search within the table name temp based on a ID, once the id has been found in the temp table that record must be sent to another table called "Final"
The user must have an input box to enter their ID search criteria. (did this part already using visual basic activex script)
Please for some assistance (books, websites, code, videos anything)
May 4, 2011 at 9:17 am
DTS isn't really built for this. It would be more like something you would do in a web page or reporting services. To make this work you would have to have each person run the package in Enterprise Manager to get this to work.
Possibly it will work with someone executing a DTS Run, but packages are not meant to be interactively.
The idea of what you want to do is run code that accepts a parameter, and then inserts matching rows into another table. That can easily be done with a stored procedure that accepts a parameter. The hard part of getting that value from a user. As mentioned, a web page or even an Access application would work better here.
May 4, 2011 at 9:28 am
The package would actually be built for high level administrators with access to the server and not low level users
May 4, 2011 at 10:04 am
Like Steve said, DTS is not the best avenue for this type of thing. A stored proc is what you want to use.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
May 4, 2011 at 10:17 am
If it's for high level administrators, then why not this?
Create procedure MoveDate
@id int
as
insert Final
select *
from temp
where temp.id = @id
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply