I am calculating one column in derived column in DTF and then I want to use that column in variable as I want to use that value in my next data flow task.
Can you please tell me how can I do that?
I tired one method using script component as transformation is DFT.
In that, in readwritevariable, I gave one datetime user variable MAX_PBPS_EFFECTIVE_DT
and in I/p and O/p, I used that field 'MAX(MEP_EEFF_DT) '
and in edit script, I wrote below script
But when I ran the package it gave me error that no row assign to variable.
Please help me soon. Thanks in advance.
You need to post your question on the SSIS forum:
Kalman Toth Database & OLAP Architect
IPAD SELECT Query Video Tutorial 3.5 Hours
New Book / Kindle: Exam 70-461 Bootcamp: Querying Microsoft SQL Server 2012
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?