|
I have a script component which I need to reference a global variable? I guess I can dtsconfig file. How do I set this and read it back out from my script component?
Started by Joe on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
In script task you can use like.
This will work only in script component of Data Flow task.
|
|
Is there a way to debug .Net dll from SSIS Script Component which is being referenced.
Thanks
Started by Nev_Rahd on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Click the "Select..." button next to the box....
You can attach Visual Studio to any local process (or a remote process if the remote debugger is set up .)
Open the DLL project in Visual Studio From the Debug menu (or Tools menu) select Attach to Process .
|
|
Hi all,
Is it possible to use a @Script component to render a script tag pointing to a js file hosted on a different server?
Basically, I need to inject a script tag such as:
<script src="http://otherserver.com/script.js"></script>
but I need...
Started by pstanton on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Assuming you're using a Shell component to wrap....
If you're using the Shell component , it's easy:
Shell.get(cycle).includeAdditionalContent( myHtmlForHead );
Or write a simple component that does that and reuse it in your templates.
|
Ask your Facebook Friends
|
I have an SSIS script component which takes in rows from input.
One of the rows on the input is a boolean which identifies if the row is of type A or B.
How do I get the script to load all of the input rows into the correct collection of rows.
Also any...
Started by Craig Warren on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Since the script component is using VB, it would be something like
If Column(type) = True-Nugget_3A00_-Multiple-outputs-from-a-synchronous-script-transform.aspx
He uses the script component to that executes when all ....
|
|
I would like to use Python to script an application that advertises itself as providing an OLE component. How should I get started?
I don't yet know what methods I need to call on the COMponents I will be accessing. Should I use win32com to load those...
Started by joeforker on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
You can find an example on this ....
Some examples:
from win32com.client.dynamic import Dispatch # Excel excel = Dispatch('Excel.Application') # Vim vim = Dispatch('Vim.Application')
And then call whatever you like on them .
You need the win32com package.
|
|
What is the best way to read system variables from Script Component.
Tried as below: Works fine when is User variable
base.PreExecute(); IDTSVariables100 variables = null; VariableDispenser.LockForRead("System::ContainerStartTime"); VariableDispenser....
Started by Nev_Rahd on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Ok got this done as
#region Class Variables int jobId; DateTime auditTimeStamp; IDTSVariables100 variables... .
Something like this
@[System :: PackageName].
You could create a user variable that is evaluated as an expression that references the system variable .
|
|
This is with SQL 2005.
I have a script component inside a Data Flow Task. I would like to read from the input columns and write the data to a global user variable.
I've set my input columns and added my global user variable as a ReadWriteVariable to the...
Started by MaxGeek on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
From MS:
In Script component code....
I figured it out.
Http://msdn.microsoft.com/en-us variable and listed in your ReadWriteVariables for that script task.
These methods, see Coding and Debugging the Script Component.
|
|
Hi there.
I'm trying to propagate an assignment to the data parameter of a sub-component through it's parent component's setter. Like this:
<CustomComponent xmlns:mx="http://www.adobe.com/2006/mxml" xmlns="components.*" > <mx:Script> <!...
Started by DyreSchlock on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
What Components are your custom component and sub component based on ? What do they extend ?
I've.
|
|
I have am OLEDB Connection configured in the connection managers and I want to use it in a SCRIPT. The script needs to call a stored proc and then create buffer rows. I have added the connection to the connections available to the script and this is my...
Started by Coolcoder on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
You need to use a managed connection provider..
This MSDN example implies that you using AcquireConnection incorrectly.
|
|
I definitifely like the one at stackoverflow, because it's clean and simple. Also the live preview with code/syntax hilighting is really helpful (and motivating).
What is your favourite Javascript Editor Framework and why?
Started by Andre Bossard on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
I just stumpeld over MarkItUp , which is JQuery based and adaptable for different... .
In my web-hacker days, I used Xinha quite a lot .
Hi!
I love tiny_mce
Goran
Simple Text Editor is a good one ( STE 1.0 ) .
TinyMCE looks good with lots of useful features.
|
