User Profile

Collapse

Profile Sidebar

Collapse
DataStageBarTen
DataStageBarTen
Last Activity: Feb 22 '12, 05:46 PM
Joined: Feb 20 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • DataStageBarTen
    replied to How to read from a text file in SQL query ?
    in SQL Server
    Thanks for the reply.
    I already asked the users but since they sometimes run reports using old fiscal year even when the new fiscal year starts.
    So that's not an option.
    See more | Go to post

      Leave a comment:

    • DataStageBarTen
      started a topic How to read from a text file in SQL query ?
      in SQL Server

      How to read from a text file in SQL query ?

      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:
      Code:
      SELECT COLUMN_NAME FROM TABLE_99
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...
      See more | Go to post
      Last edited by NeoPa; Feb 20 '12, 11:08 PM. Reason: Added mandatory [CODE] tags for you
      No activity results to display
      Show More
      Working...