i created an execute sql task and taking the particular column i need and storing it to a package variable(user::people) with datatype as object
Then i have a for each loop container in collection i select the above variable i selected and in variable mappings i created another variable...
I am trying to access web service and i am unable to use web service task component since i need to pass the input parameter from a table.
i thought of using script task, how do i take care of client certificate thru script task.
Please let me know
I converted sql 2000 package to ssis. I had flat file to table and i had some activex script for formatting of columns in the dts. hence when i migrated to sql 2005 ssis those steps are converted to execute sql 2000 package task and when i try to execute the package from vba all other steps...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.