MySQL Forums
Forum List  »  Microsoft SQL Server

Advanced Search
New Topic

How to read from a text file in SQL query ?
Posted by: DataStageBarTenDer DataStageBarTenDer
Date: February 20, 2012 04:03PM

I am creating a SSIS package which reads from a table & outputs a text file. In the SQL that is being used I have a WHERE condition, WHERE FISCAL_YR = '2012'.

Instead of hard coding the year '2012' I would like to pass the year from a text file? That way the user can just change the text file's year when the fiscal year changes.

How do I pass the year as a parameter into the SQL query?

I am using SQL server management studio (SQL 2008).

Thank you.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
How to read from a text file in SQL query ?
DataStageBarTenDer DataStageBarTenDer
February 20, 2012 04:03PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.