Personalized Community is here!
Quickly customize your community to find the content you seek.
‘Better Together’ Integration forum available
We're launching a how-to forum where you can learn and engage about how Dynamics 365 integrates with other Power Platform products.
Read about Better Together forum
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 1 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming 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