What?
A super quick article on how to pre-select the pipeline on deal creation within CRM based on the department specified on a user's profile.
Why?
A client asked that when staff create a deal/opportunity ...
What?
I started getting this error:
The task with the name "Data Flow Task" and the creation name "DTS.Pipeline.2" is not registered for use on this computer
Why?
We use a combination of MS Visual ...
... VALUES ( @StringValue )
END
RETURN
END
Now we want to modify this slightly so that it converts a string of words delimited by pipes to a table:
CREATE FUNCTION dbo.[ufn_PipeStringToTable]
(
...
... country of domicile with the pipe delimiter as the example:
&G[entity.dictionary: |:
Select the exchange fields (or container) to apply this to
Select the "Export Format" tab and click on the chevrons ...
What?
This article is so that I don't spend so long in googling what the TxScript referenced assembly is when creating an SSIS custom component.
How?
This is simply the "Script Component" under ...
... Visual C# 2008.
* ScriptMain is the entry point class of the script.*/
using System;
using System.Data;
using Microsoft.SqlServer.Dts.Pipeline.Wrapper;
using Microsoft.SqlServer.Dts.Runtime.Wrapper;
using ...
... + "/" + SUBSTRING(This_Date,7,4))
Known Issues
[Convert Date [4228]] Error: An error occurred while attempting to perform a type cast.
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. ...
... pictures. If you are batch processing a text file, you need to separate the website address and the given name with a pipe character ("|" - see "TEXT file example" mentioned earlier). It ignores space ...
... port is 3306.
Specifying port
Server=myServerAddress;Port=1234;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
Named pipes
Server=myServerAddress;Port=-1;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
It ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.