June 25, 2014 at 11:21 am
We require to convert a list of SPs in to SSIS packages. Most of the SPs do the below steps:
mainly our store procedure r to have compare the present date to past date , and comparing emp id between the files and also some joins. updating table r take place.
can u help me with clear steps to do...
June 25, 2014 at 12:16 pm
raja.payani (6/25/2014)
can u help me with clear steps to do...
As soon as you provide clear steps as to what you're already doing rather than a vague description. I left my crystal ball in my other pants.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 25, 2014 at 12:25 pm
Yes, SSIS can replace stored procedures. And vice versa as well.
That's about all we can say without further details.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 26, 2014 at 2:42 am
ok..thank you..man..i need a clear steps for small SP.
please be quick..
by raja.
June 26, 2014 at 2:47 am
CREATE PROCEDURE (Transact-SQL)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 26, 2014 at 7:29 am
Sure you can convert them.
Big question - Why?
Is it just that you need that functionality in SSIS?
Easy thing to do would be to call the stored procedure from an execute sql task in SSIS. No need to convert them in that case.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 26, 2014 at 8:05 am
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply