Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

can SSIS package replace stored procedure Expand / Collapse
Author
Message
Posted Wednesday, June 25, 2014 11:21 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 12:54 AM
Points: 2, Visits: 4
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...
Post #1586022
Posted Wednesday, June 25, 2014 12:16 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:16 AM
Points: 6,259, Visits: 7,451
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.



- Craig Farrell

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 | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
Post #1586043
Posted Wednesday, June 25, 2014 12:25 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:06 AM
Points: 13,735, Visits: 10,706
Yes, SSIS can replace stored procedures. And vice versa as well.
That's about all we can say without further details.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1586047
Posted Thursday, June 26, 2014 2:42 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 12:54 AM
Points: 2, Visits: 4
ok..thank you..man..i need a clear steps for small SP.



please be quick..
by raja.
Post #1586292
Posted Thursday, June 26, 2014 2:47 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:06 AM
Points: 13,735, Visits: 10,706
CREATE PROCEDURE (Transact-SQL)



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1586294
Posted Thursday, June 26, 2014 7:29 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 9:32 PM
Points: 21,755, Visits: 15,459
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1586421
Posted Thursday, June 26, 2014 8:05 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, September 15, 2014 10:24 AM
Points: 371, Visits: 967
Koen Verbeeck (6/26/2014)
CREATE PROCEDURE (Transact-SQL)


Zing!


Cheers
Post #1586452
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse