我有sis軟件包,因為我要從平面文件中獲取值并將其插入表中。在創建一個臨時表中,我執行了一個執行SQL任務CREATE TABLE [tempdb].dbo.##temptable (date datetime,companyname nvarchar(50),price decimal(10,0),PortfolioId int,stype nvarchar(50))Insert into [tempdb].dbo.##temptable (date,companyname,price,PortfolioId,stype) SELECT date,companyname,price,PortfolioId,stypeFROM ProgressNAVWHERE (Date = '2011-09-30') AND (PortfolioId = 5) AND (stype in ('Index'))ORDER BY CompanyName現在在上面的查詢中,我需要(Date = '2011-09-30') AND (PortfolioId = 5) AND (stype in ('Index')) 使用變量名傳遞這3個參數,我已經在包中創建了變量,以便變得動態。
如何在執行SQL任務SSIS中將變量作為參數傳遞?
瀟湘沐
2019-12-03 15:44:12