Personalized Community is here!
Quickly customize your community to find the content you seek.
Microsoft Customer Co-creation
Help impact how the tools and services you rely on are developed. Microsoft Customer Co-creation connects you directly with our engineers so you can provide feedback before a single line of code is written. Interested? Learn more at Microsoft Customer Co-creation
2022 Release Wave 2Check out the latest updates and new features of Dynamics 365 released from October 2022 through March 2023
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
Recently, while working on SSIS, we came across a scenario where we had to assign multiple values to multiple variables to use them in package later.
We used “Execute SQL Task” to assign those values to the variables. The SQL query we used, was returning single row with 12 columns. We wanted to store the values of 12 columns in 12 variables.
Below is the screenshot of the Execute SQL Task Editor:
Then, we mapped the columns returned from the select statement query to 12 variables using Result Set section on the left panel as shown below:
Then, while executing the task to see if it’s working or not, we got the error: “An error occurred while assigning a value to the variable“.
Reason: We were using varchar(max) as the data type of the column that we were selecting using select statement.
Fix: We changed the data type of those columns that we were selecting to varchar(7000) and it worked. All the column values got assigned to the respective SSIS variables.
Basically, SSIS variables are unable to hold varchar(max) or nvarchar(max) values. Hope it helps !!
Business Applications communities