Post New Web Links

Assign guid to variable in control flow

Posted By: Posted Date: October 12, 2010 Points: 0 Category :Sql Server

How do I assign a script task generated GUID to an ssis variable and then pass it to sql server via a stored proc? I've only been able to find info on how to do it in a data flow task (derived column)

There doesn't seem to be a GUID type in the Data Type drop down in the Variables tab

I get the following error whether I create the variable as an object or string & setting the data type of the variable to either object,guid or string in the parameter mapping tab of the execute sql task don't do much either

Error: 0xC002F210 at Log Fail, Execute SQL Task: Executing the query "EXEC dbo.spLogGenericExtractControlOnComplete
..." failed with the following error: "Conversion failed when converting from a character string to uniqueidentifier.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Task failed: Log Fail

What magic combination of settings do I have to use to make it work?

View Complete Post

More Related Resource Links

How To Map A GUID Variable And Use It In An OLE DB Source Data Flow Select Query

Hello,

I have a simple SSIS package that does the following.ÃÂ

On the control flow tab, there is an Execute SQL task that calls a stored procedure and returns a GUID.ÃÂ

I have a package scoped variable that stores a UNIQUEIDENTIFIER output from the stored procedure. It appears that the package variable data type does not include a GUID data type so I tried to use string instead.

Next, the Execute SQL task is mapped to a data flow task.ÃÂ

Within that data flow task I have an OLE DB Source which connects to a SQL Server Destination task.

On the OLE DB Source Editor screen I have a query that performs the following:

SELECT ID, SessionKey, ....

FROM dba_DroppedLoginsLog

WHERE SessionKey = ?

I have clicked on the parameters button to map the Parameter to my variable called User::SessionKey. This is the output variable from my Execute SQL Task component on the Control Flow tab. This value should be a GUID, but again, I don't see a data type for that.

When I execute the package it fails on the OLE DB Source with the following error:

[OLE DB Source [1908]] Error: SSIS Error Code DTS_E_OLEDBERROR. ÃÂ An OLE D

how to assign string value to a label control

When i do the following i am getting object ref not set to instance of an object:

there is value in string variable would like to assign to a label.

lblFilename.Text = strFilename

Thank you very much for the helpful info

SSIS 2005 Control Flow Task Priority

The short version is I am looking for a way to prioritize certain tasks in SSIS 2005 control flows. That is I want to be able to set it up so that Task B does not start until Task A has started but Task B does not need to wait for Task A to complete. The goal is to reduce the amount of time where I have idle threads hanging around waiting for Task A to complete so that they can move onto Tasks C, D & E. The issue I am dealing with is converting a data warehouse load from a linear job that calls a bunch of SPs to an SSIS package calling the same SPs but running multiple threads in parallel. So basically I have a bunch of Execute SQL Task and Sequence Container objects with Precedent Constraints mapping out the dependencies. So far no problems, things are working and initial testing looks like it will cut our load time significantly. However I noticed that tasks with no downstream dependencies are commonly being sequenced before those that do have dependencies. This is causing a lot of idle time in certain spots that I would like to minimize. For example: I have about 60 procs involved with this load, ~10 of them have no dependencies at all and can run at any time. Then I have another one with no upstream dependencies but almost every other task in the job is dependent on it. I would like to make sure that the task with the dependencies is running before I pick up any of t

How to declare variable and assign value in xslt

Hi, I am writing xslt to create HTML by using input xml data. The input XML looks like this ID Name Description 1 Name1 Description Something1 Name1 Description another text2 Name2 Some text2 Name2 Some text22 Name2 Some text2 Here Id is primary, where Name is unique as per ID. I want to show the output the following way Name1 * Description Something * Description another textName2 * Some text * Some text2 * Some text2 So I want to declare a variable in XSLT and make a loop in records and store the previous record ID. IF the previous record id is same, then no need to show the name. But when I declare in the following xslt, I am getting 'The variable or parameter 'xxx' was dublicated within the same scope' error<xsl:output method ="html" media-type="text/html" encoding="iso-8859-1" /> <xsl:template match="Details"> <xsl:variable name="counter" select="0"/> <xsl:for-each select="XMLParentNode/XMLDetailNode/XMLSubDetailNode"> <xsl:if test="$counter = 1"> <xsl:value-of select="NAME" disable-output-

Problem setting variable/param in XSLT for XML control in .NET 4.0

I am using an XML control in VS2010 with .NET 4.0.I am trying to sort XML data into a table. I have a drop list with the sort key, and a button that is supposed to display the table with a new sort.Here is the code the button calls:<div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">private void PopulateXML( Xml MyXML)</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: h

my custom control flow task's ui failed to create the task...

Hi.. I hope someone else has seen this. The funny thing about the error is it reports on my version 1.0 task but if you hover over the task icon in tool box it clearly indicates I have load my 1.1.1 version from the gac. Thanks=================================== Failed to create the task. (Microsoft Visual Studio) =================================== The task user interface specified by type name 'MergeBuilderTaskUI.MergeBuilderTaskUIMainWnd,Version=1.0.0.0,Culture = Neutral,PublicKeyToken = 12345abc6789de01' could not be loaded. (Microsoft.DataTransformationServices.Design) ------------------------------For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2008&ProdVer=9.0.30729.1&EvtSrc=Microsoft.DataTransformationServices.Design.SR&EvtID=CouldNotLoadTaskUIForType&LinkId=20476 ------------------------------Program Location: ÃÂ ÃÂ at Microsoft.DataTransformationServices.Design.DtrTaskDesigner.InitializeTaskUI()ÃÂ ÃÂ at Microsoft.DataTransformationServices.Design.DtrTaskDesigner.OnNewTaskAdded()ÃÂ ÃÂ at Microsoft.DataTransformationServices.Design.DtsBasePackageDesigner.CreateExecutable(String moniker, IDTSSequence container, String name) =================================== The given assembly name or codebase was invalid. (Exception from HRESULT: 0x80131047) (mscorlib) ------------------------------Program Location: ÃÂ ÃÂ at System.Run

Gridview control Delete error -- Must declare the scalar variable "@GradeID"

Hi All,Pardon me if this seems redundant. I have searched the archives and found many references to this type of error. Most (all?) boil down to a mismatch between the token for the databound field and the sql parameter. I have stared at this code for a long time and can see nothing wrong with it. In fact, it is so simple that I started over from scratch using only the designer (ie I wrote no code), so I don't see how it possible to have a name mismatch. I would very much appreciate any help figuring out what is the problem here. Thank you very much in advance.-Roger Server Error in '/ssp/inet220a06' Application. Must declare the scalar variable "@GradeID". Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Must declare the scalar variable "@GradeID". Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

What type variable can I use to assign a possible Null or a string to?

Hi,

I am converting a VB6 app to VB2008 and are having problems with replacing Variant variables.

I used Variant in cases where the data might be string or Null.

Is there a way I could check for Null and just set the string to zero lenght?

Any help would be appreciated.

Ragnar

Data Flow Task failing to drag-and-drop onto SSIS Control Flow

This morning, I started having problems with Visual Studio 2005 on XP when I tried to create an SSIS project; I was getting an error message about the failure to create an SSIS runtime object, with the reference "Unable to cast COM of type 'Microsoft.SqlServer.DTS.Runtime.Wrapper.PackageNeutralClass' to interface type". Digging here and elsewhere on the Net, I used regsvr32 to re-register msxml3.dll, msxml6.dll, and dts.dll. This allowed me to create a new SSIS project, but I was unable to add a data flow task to the Control Flow pane -- when I dragged the control onto the pane, nothing happened, and when opened the Data Flow pane and clicked on the 'No data flow task has been defined. Click here to create a data flow task" link, I got a 'Failed to create the task. The designer could not be initialized." error. Searching here and on the Net, I uninstalled and reinstalled the SQL Server 2005 workstation tools.

After doing this, I am still unable to create a data flow task by dragging the task out of the toolbox; the pointer assumes the right form for the drag-and-drop, as it does for other tasks, but when I release the mouse button, nothing happens. However, when I go to the Data Flow pane and click on the 'click here to create a new data flow task', it creates the task, and I am able to use copy-and-paste to make copies of the data flow task

QueryExtender Control - Variable field name to search against

I have been alerted to the Query Extender control through previous posts, but I am still seeking the final part of my desired solution.

NB the following is written in conceptual English (programming specification) format, rather than actual asp code.

While I fully understand that I can use the QueryExtender control to pass a parameter from one web page to another, I do not see, and maybe this is not even possible, how I can pass a parameter of which field I want to select on.

Ideally I would like to be able to implement a query which is

SELECT tiles where 'Passed Variable Name' contains 'Passed Test Value'

such as would then generate, for example -

SELECT titles where 'Series Available' contains 'A'

OR

SELECT titles where 'Authors' contains 'Wyndham'

but I just can't work out how I can implement the varying search field.

Is what I am seeking for possible? OR

Am I going to be forced to implement an approach such as the following?

SELECT Calling Web Page

CASE "Series"

SELECT titles where 'Series Available' contains 'passed variable'

CASE "Authors"


Categories:

ASP.Net	Windows Application	.NET Framework	C#	VB.Net	ADO.Net
Sql Server	SharePoint	Silverlight	Others	All