SSIS Execute SQL Task with Recordset GUID Variable

Posted on 2013-06-28
Medium Priority
Last Modified: 2016-02-11
Guys and girls... I've got one that I'm currently banging my head on.

I have an SSIS package within Visual Studio. I'm pulling data from a SQL server to a recordset in the DataFlow and then in the Control Flow I'm taking that DataFlow and pointing it to a Execute SQL Task.

The only data I'm pulling is a GUID using a SQL query in an OLE DB Source. From a watchtable I can see that the single GUID (I've narrowed my query down to just one) is getting properly transfered into the recordset.

I have two variables throughout the package (EntityID & rsDetails) with EntityID being my GUID. EntityID is a string and rsDetails is an Object.

The data flow appears to be working great.

On the control flow I'm taking my data flow output and putting it into an Execute SQL Task which runs a stored procedure. I'm using my mapped variable of User::EntityID in my stored procedure. I'm stating that User::EntityID is a GUID with parameter size of 36.

When I debug and run the package, everything goes green. The data does not show up correctly and essential my GUID is NULL.

If I run SQL Profiler while the package is running I can see where the stored procedure runs and where the GUID should be but it is completely blank. I just see two single apostrophe marks next to each other with the GUID missing.
Question by:LeifHurst
1 Comment
LVL 15

Accepted Solution

Aaron Shilo earned 1000 total points
ID: 39287961

read this for how to use guid in ssis

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question