Hi,
How can I pass variables in select clause in oledb source and I am using sql command as data access mode.I am able to pass variables in where clause
I enclosed SSIS Package which I am using.In package i am creating a text file.The text file contains Header,detail Record,Trailer.check the data flow task(flat file generation) in my package
In header row .I have phone number column(804-217-7396).I want to pass it as variable @phone_number.
can any one help me