how to use variable value from c # web application in a package SSIS?
I am developing a web application in c #. Net. What I need is to import
records from sql to an access db. I have no problems with the import, but
I need to filter the records imported by a variable that is in the web
application. I need to use as a filter variable "username" variable in c#
string username = (string) HttpContext.Current.Session ["Username"];
How I can send and use this variable "username" to SSIS package to do the
following filter?
SELECT ID, address
FROM my_table
WHERE (username = @username)
Thank you very much!
No comments:
Post a Comment