Avatar of coventri
coventri

asked on 

Passing Variables To OLEDB Source in SSIS

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

Thanks,
coventri
SSIS-packge.txt
PSP-Rate.txt
Microsoft SQL ServerMicrosoft Development

Avatar of undefined
Last Comment
stelth240

8/22/2022 - Mon