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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics