Script Task/Component and Template Information

by Allan Mitchell 8 Dec 2009 06:46
The Script Task and Script component are often used by people developing SSIS packages because they are easy to use and now because SSIS could be perceived to be more developer friendly they are very powerful. That being said we should no be using them everywhere.  There are generally Tasks/Co... [More]

Currently rated 5.0 by 1 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags, , ,

CategoriesScripting | Tasks | Transformations | Configuration

E-mail E-mail |
Permalink | Comments (1) | Post RSSRSS comment feed

Downloading a file over HTTP the SSIS way

by Darren Green 2 Jul 2009 18:14
This post shows you how to download files from a web site whilst really making the most of the SSIS objects that are available. There is no task to do this, so we have to use the Script Task and some simple VB.NET or C# (if you have SQL Server 2008) code. Very often I see suggestions about how to us... [More]

Currently rated 5.0 by 7 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags, ,

CategoriesScripting

E-mail E-mail |
Permalink | Comments (14) | Post RSSRSS comment feed

Logging connection strings

by Darren Green 10 Jun 2009 21:44
If you some of the dynamic features of SSIS such as package configurations or property expressions then sometimes trying to work out were your connections are pointing can be a bit confusing. You will work out in the end but it can be useful to explicitly log this information so that when things go ... [More]

Currently rated 3.0 by 9 people

  • Currently 3/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags, , ,

CategoriesScripting

E-mail E-mail |
Permalink | Comments (1) | Post RSSRSS comment feed

Escaping In Expressions

by Darren Green 30 Oct 2008 17:18
The expressions language is a C style syntax, so you may need to escape certain characters, for example: "C:\FolderPath\" + @VariableName Should be "C:\\FolderPath\\" + @VariableName Another use of the escape sequence allows you to specify character codes, like this \xNN... [More]

Currently rated 3.8 by 6 people

  • Currently 3.833333/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags

CategoriesScripting

E-mail E-mail |
Permalink | Comments (0) | Post RSSRSS comment feed

Expressions

by Darren Green 28 Oct 2008 08:40
Data Flow Property Expressions Property expressions within the data flow are not immediately obvious. Whilst most pipeline or data flow components do support them for their properties, the expression is not generally exposed through the component user interface, neither is the Expressions property ... [More]

Currently rated 5.0 by 1 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags, ,

CategoriesData Flow | Scripting | Transformations

E-mail E-mail |
Permalink | Comments (0) | Post RSSRSS comment feed

Script Task Breakpoints in SQL Server 2008

by Allan Mitchell 23 Aug 2007 14:00
One of the things coming from our look at SQL Server 2008 Integration Services is that you are not going to see a lot of change visually. What you are going to see is things going on underneath the covers that makes SSIS perform better, and improved informational messages from the components. Just... [More]

Currently rated 3.0 by 2 people

  • Currently 3/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags

CategoriesScripting

E-mail E-mail |
Permalink | Comments (0) | Post RSSRSS comment feed

Generating Surrogate Keys

by Guest 4 Apr 2005 14:00
(By Jamie Thomson) Introduction Surrogate keys are generally considered fundamental building blocks of a data warehouse. They are used as identifiers for dimensional members and enable us to manage slowly changing dimensions. SSIS does not contain a built in component for generating s... [More]

Currently rated 4.0 by 2 people

  • Currently 4/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags, ,

CategoriesData Flow | Scripting

E-mail E-mail |
Permalink | Comments (1) | Post RSSRSS comment feed

The Script Component as a Transformation

by Allan Mitchell 2 Aug 2004 14:00
In this article we are going to assume a few things about the reader as we want to concentrate as much as possible on the Script Component itself and not the peripheral stuff The things we will assume are: You are happy with adding a Data Flow task to the designer in Workflow Yo... [More]

Currently rated 4.1 by 11 people

  • Currently 4.090909/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags, , , ,

CategoriesData Flow | Scripting

E-mail E-mail |
Permalink | Comments (4) | Post RSSRSS comment feed

Welcome to SQLIS.com our free SQL Server Integration Services (SSIS) resource site.

MVP

RecentComments

Comment RSS