I am converting DTS to SSIS, in DTS there are 3 package global variables & dataflow task which is taking data from CSV file into table, our requirement is that we have to assign the value from the csv file to package variables which is passed to stored procedure as a parameter, in DTS they have used the following code
DTSGlobalVariables("as_of_date").Value = Trim(DTSSource("Col001"))
DTSGlobalVariables("file_type").Value = Trim(DTSSource("Col013"))
DTSGlobalVariables("product_type").Value = "BBLN"
In SSIS I have taken a Script component & wrote in following way
Dts.Variables("as_of_date").Value = Trim(Col001)
but it gives syntax error like blue underline in Dts
Can any one help me that how to write this in SSIS or suggest any other way?