Ir al contenido principal

BI - SSIS ( Basics II )

First Steps to create a Package\

Lessons on video are on



1) Create a Connection Manager
  • This will create a connection for the project or the entire solution.
  • This can e change in the properties.
2) Define the Control Flow

  • Define the tasks
  • Recommendation - Change the default name for something more explicit

3) Package Encryption
  • The XML by default have a default encryption using Windows user key
  • To change use, Properties Panel -> EncryptSensitiveWithUserKey
  • Review the encryption when deploy in a productive environment
4) Upgrade your package

Variables

In the blank space, left click and select Variables.
Then some window will be open to declare the variables.

Script Task

Examples of code:

  • In Visual Basic, creating a variable
Dts.Variables(“strFileName”).Value = strInternal
  • In Visual Basic, reading default variables.

Dts.Variables(“strFileName”).Value = “newvalue”
MsgBox(Dts.Variables(“strFileName”).Value)

  • In Visual Basic, displaying a variable
Dim strInternal As String
strInternal = “test”
MsgBox(strInternal)

  • In Visual Basic, modifying the Data Connection
Dts.Connections(“AdventureWorks2012”).ConnectionString = _
“Data Source=localhost;Initial Catalog=AdventureWorks2012;” + _
“Provider=SQLNCLI10.1;Integrated Security=SSPI;”
  • In Visual Basic, validating if a file exist
If File.Exists(Dts.Variables(“strFileName”).Value) Then
Dts.Variables(“bolFileExist”).Value = True
Else
Dts.Variables(“bolFileExist”).Value = False
End If
  • In Visual Basic, checking if the file is in use.
Try
File.SetLastAccessTime(Dts.Variables(“strFileName”).Value, Today)
Catch e As Exception
Dts.Variables(“bolFileInUse”).Value = True
End Try


Execute SQL Task

http://www.wrox.com/WileyCDA/Section/id-814197.html

You can execute a SQL command and the result be assigned to a variable.

Flat File Source

Use Fast Parse as best practice

1. Right-click the Flat File Source or Data Conversion Transformation, and
click Show Advanced Editor.
2. In the Advanced Editor dialog box, click the Input and Output Properties tab.
3. In the Inputs and Outputs pane, click the column for which you want to
enable Fast Parse (shown in Figure 18-18).
4. In the Properties window, expand the Custom Properties node, and set the
FastParse property to True.
5. Click OK.


Comentarios

Publicar un comentario

Entradas populares de este blog

C# Using tabs

To use tabs in C# use the TabContainer element from AjaxControlToolkit Include AjaxControlToolkit  Include in the Web.config file, inside the tag <system.web> the following code  <pages>       <controls>         <add tagPrefix="ajaxCTK" namespace="AjaxControlToolkit" assembly="AjaxControlToolkit"/>       </controls>     </pages>   Include TabContainer element First  include TabContainer element that is the section where all the tabs will be displayed. <ajaxCTK:TabContainer ID="TabContainerUpdate" runat="server"                 Height="800"                 CssClass="ajax__tab_style"> </ajaxCTK:TabContainer> Second per each tab include the following code corresponding to each ...
Publicar un comentario
Leer más

Rails - Basic Steps III

pValidations Validations are a type of ActiveRecord Validations are defined in our models Implement Validations Go to   root_app/app/models Open files  *.rb for each model Mandatory field validates_presence_of   :field Ex:   validates_presence_of    :title Classes The basic syntax is class MyClass        @global_variable                def my_method              @method_variable        end end Create an instance myInstance = MyClass.new Invoke a mehod mc.my_method class() method returns the type of the object In Ruby, last character of method define the behavior If ends with a question -> return a boolean value If ends with an exclamation -> change the state of the object Getter / Setter method def global_variable       return @global_variable end ...
Publicar un comentario
Leer más

Python create package

Create a root folder Create a sub-folder "example_pkg" that contains the funtionallity packaging_tutorial/ example_pkg/ __init__.py In the root folder create the following structure  packaging_tutorial/ example_pkg/ __init__.py tests/ setup.py LICENSE README.md in the setup.py contains the configuration of the packages your package is found by find_packages() import setuptools with open ( "README.md" , "r" ) as fh : long_description = fh . read () setuptools . setup ( name = "example-pkg-YOUR-USERNAME-HERE" , # Replace with your own username version = "0.0.1" , author = "Example Author" , author_email = "author@example.com" , description = "A small example package" , long_description = long_description , long_description_content_type = "text/markdown" , url = "https://github.com/pypa/sam...
Publicar un comentario
Leer más