SSIS Script Component using an Object Data Type Variable - Easy Demo!

preview_player
Показать описание

  1. Coopman Greg
  2. SSis
  3. script component
  4. object data type variable
  5. sql server
  6. greg coopman
Рекомендации по теме
37 Script Component 0:13:24

37 Script Component Transformation in SSIS

SSIS : Script 0:07:53

SSIS : Script Component

134 Create 2 0:16:10

134 Create 2 outputs from Script Component source in SSIS

SSIS Interview Questions 0:05:06

SSIS Interview Questions | What is the difference between Script Task and Script Component in SSIS

Intro to SSIS 0:17:20

Intro to SSIS Script Task and Script Component - 1

18 Script Task 0:08:31

18 Script Task in SSIS | Using script task in SSIS

SCRIPT COMPONENT IN 0:02:33

SCRIPT COMPONENT IN SSIS | Custom .Net Code in SSIS

SSIS Use Script 0:05:42

SSIS Use Script Component as XML Source

SSIS Script Component 0:11:29

SSIS Script Component using an Object Data Type Variable - Easy Demo!

SSIS script component 0:03:37

SSIS script component

SSIS Tutorial - 0:10:04

SSIS Tutorial - Script Task Vs Script Component

The SSIS Script 0:13:21

The SSIS Script Task

19 Debugging Script 0:12:18

19 Debugging Script Task in SSIS

Advanced Scripting Using 1:06:09

Advanced Scripting Using SSIS Script Tasks and Components

SSIS Interview Questions 0:01:52

SSIS Interview Questions | Scripting Languages for Script Task and Script Component in SSIS

SSIS Custom Script 0:04:45

SSIS Custom Script Task Read Text File Line Count

MSBI - SSIS 0:02:31

MSBI - SSIS - Script Component

135 Error handling 0:08:57

135 Error handling in script task ssis to sql table

Databases: Register dll 0:01:14

Databases: Register dll to use in SSIS Script Component

Script Task basic 0:18:31

Script Task basic Operations in SSIS

SSIS TUTORIALS FOR 0:01:16

SSIS TUTORIALS FOR BEGINNERS||15.SCRIPT COMPONENT WITH BREAKPOINT IN SSIS#ssis #msbi

Script Task in 0:12:26

Script Task in SSIS, Using Variables in SSIS, Using Parameters in SSIS

SSIS Tutorial - 0:20:50

SSIS Tutorial - How to use Script Component dynamically export data to multiple text files.

Generate Sequence Numbers 0:17:39

Generate Sequence Numbers using Script Component in SSIS

Комментарии
Автор

Hands down best tutorial on this topic. I searched all afternoon and finally bumped into this video. I'm a beginner with barely any C# skills and it worked. Thanks!

georgia
Автор

Hey Greg I am trying to do this exact thing however I am feeding 6 different queries to a for each to be executed on a DB ... A sql script task is executing each query and loading result to object type var. Now right after each query run I have data flow with a script component source and each time I run I get "object is not an ADODB.RecordSet or an ADODB.Record.Parameter name: adodb" any idea how to get passed this? script component code is exactly as you have it and it reading in a result set from and execute sql

seanralston
Автор

Bravo maestro! Fantastic explanation easy to understand.

JP-tdgt
Автор

Hi Greg, do you know anyway to have an ssis derived column expression add together both positive and negative numbers? So that a negative will actually subtract from the positive. Mine are zeroing out every time one of the added fields is a negative. I'm using decimal type .

johnk