Hi ,
There is a Sql query which is more than 4000 characters long hence I cannot assign it into the expression of the SqlCommand properties in the DataFlow Task which has Attunity as source to pull data from Oracle.
Is there any method to access this property inside a script task of the same package and change the sql command dynamically.
When I paste the query inside the SqlCommand the SSIS package runs fine but the moment I try to parameterize it it fails.
I have searched this site and googled too , every where it says that assign the property in the script task but there is no sample code.
The major problem is how to get the id of the the data flow task or the attunity source and then select the parameter to assign value , just like "setComponent" Property when we try to generate SSIS dynamically