Simple Select Statement
Hi,
I reached finally the Data Flow screen and set up OLE DB Source and Flat File Destination.
Now I need somehow to:
----------------------------------------------------------------
Select * from dbo.TABLE
where ACCT_YYYYMM = @[User::ACCT_YYYYMM]
----------------------------------------------------------------
and load the result to the Flat file. I can not figure where to put this logic.
I only know SQL, no VB or C++. Any advice.....?
Thanks, Dmitry
May 18th, 2011 6:24pm
Check this out.
http://msdn.microsoft.com/en-us/library/ms141696.aspxRussel Loski, MCITP Business Intelligence Developer and Database Developer 2008
Free Windows Admin Tool Kit Click here and download it now
May 18th, 2011 6:33pm
Thanks, I figured it out. OLE DB source editor has an option of passing parameterized variables.
Dmitry.
May 18th, 2011 8:15pm