Passing paremeters in SSIS - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

Passing paremeters in SSIS

Author

Topic

Bhavika18
Starting Member

4 Posts

Posted - 2011-04-13 : 09:24:28

Hi,

1) Can anyone let me know how to pass paremeters in SSIS packages.

2) I have a function. I want to write that function using SSIS .Please let me know how to do that . Below is the function:

ALTER FUNCTION [dbo].[GetReportingPeriodID]
(
@ReportingFrom datetime,
@ReportingTo datetime
)

RETURNS INT
AS
BEGIN

DECLARE @RepALTER FUNCTION [dbo].[GetReportingPeriodID]
(
@ReportingFrom datetime,
@ReportingTo datetime
)
RETURNS INT
AS
BEGIN

DECLARE @ReportingPeriodID INT

Select @ReportingPeriodID=ReportingPeriodID from ReportingPeriod
where FromDate=@ReportingFrom And ToDate=@ReportingTo

RETURN @ReportingPeriodID

ENDortingPeriodID INT
Select @ReportingPeriodID=ReportingPeriodID from ReportingPeriod
where FromDate=@ReportingFrom And ToDate=@ReportingTo

RETURN @ReportingPeriodID

END

Thanks & Regards,
Bhavika

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources