Who is online?
0
guests and
1
members
Member login
|
Become a member
Home
Articles
Forums
Blogs
Jobs
Events
Files
Spaces
People
login
register
Home
» search results
Search Results: Configurations
101 results found
SSIS Package
Configurations
Package Configurations allow you to write properties for the Package, Connection, Container, Variable, or any Task into a shared source that is outside of your BIDS environment. These setting can be stored into an XML file or SQL table and they are called
Author:
DonnyJohns
Date: 3/29/2011 Section:
Blog
tags :
Package Configurations
,
Pragmatic Works
,
SSIS
,
XML Configurations
,
Donny Johns
SSIS 2012 Catalog
In 2005 and 2008, SSIS required a lot of manual configurations regarding deployment, configurations, environments, etc. It took a lot of time just to set up the environment for proper performance. Microsoft came up with a term for this, and called it the
Author:
ChrisSchmidt
Date: 11/6/2012 Section:
Blog
tags :
2012
,
Catalog
,
Denali
,
SQL Server Integration Services
,
ssis
Protection Level In SSIS
Are you using configurations? If so, I would recommend using DontSaveSensitive, this way your configurations hold everything, then you safeguard your configurations. This way you grant the Windows account that the packages are running under access to the
Author:
m3crast
Date: 5/23/2011 Section:
Forum
tags :
encryption
,
protection level
,
SSIS
,
Configuration
Encrypting Sensitive Information in SSIS Package
Configurations
using BI xPress
One of the downfalls to SSIS package configurations is that it does not natively allow you to encrypt your sensitive information, such as a connection string or a variable, that you may be configuring with an outside package configuration. There are some
Author:
DustinRyan
Date: 7/18/2011 Section:
Blog
tags :
Package Configurations
,
SSIS
,
Encrypt SSIS Package Configurations
Updating connection managers
Absolutely, look at using expression and configurations. Watch this webinar (free) and it will walk you through all the various ways you can implement it. Once you've watched it and read up on expressions and configurations if you still have questions on
Author:
sqlchicken
Date: 8/18/2011 Section:
Forum
tags :
configurations
,
expressions
WinSCP from SSIS - secure FTP transfers
Intro: Free software - it's always right in everyone's price range and when one gets more out of it than one paid for it - there tends to be contentment. Recently when tasked with transferring some files via sFTP, the author found ( ok - Google found ) Wi
Author:
KeithHyer
Date: 5/5/2010 Section:
Blog
tags :
Secure FTP
,
SFTP
,
SSIS
,
StandardInputVariable
,
StandardOutputVariable
,
WinSCP
How I found my Expressions
I was working in SSIS today and was supposed to change some expressions in the packages. Well, I am really....really new to SSIS and didn't really know how to go about looking for expressions. One of my counterparts told me to use Expression Highlighter i
Author:
SMcDonald
Date: 5/7/2010 Section:
Blog
tags :
BIxPress
,
Configurations
,
Exressions
,
SQL Saturday
,
Pragmatic Works
Quickly Edit Package Configuration Values from BIDS
If you've followed my blog at least somewhat, you've probably read a blog post or two where I cover one or several of the really cool features of BI xPress . That's because, simply put, BI xPress is a very versatile and useful tool that no SSIS developer
Author:
DustinRyan
Date: 10/31/2011 Section:
Blog
tags :
BI xPress
,
SSIS Package Configurations
Quickly Apply SSIS Package
Configurations
to Multiple Packages with BI xPress
One of the most powerful features of BI xPress , in my opinion, is the Package Builder Wizard . The Package Builder Wizard allows an SSIS developer to create a template from a package or a from a few components of a package. The developer can then use tho
Author:
DustinRyan
Date: 8/13/2011 Section:
Blog
tags :
BI xPress
,
Package Configurations
SSIS Expressions And 4,000 Character Limit (2/3)
In Part 1 of this blog posting I demonstrated how a combination of SSIS package configurations and expressions can make your ETL process dynamic. In this posting I am going to discuss the dreaded 4000 character limitation in expressions for SQL 2008R2 (an
Author:
CraigLove
Date: 1/16/2012 Section:
Blog
tags :
Package Configurations
,
SQL Server
,
SQL Server Integration Services
SSIS Package
Configurations
This article will show you, how to configure the SSIS package.
Author:
smartkhilit
Date: 7/12/2011 Section:
Article
tags :
Configurations
,
SSIS
,
MSBI
BIxPress SSIS Configuration Wizard
Over the past year I’ve had the pleasure of creating/converting SSIS packages for clients. At the same time, I have also had the pleasure of using BIxPress to create configurations for packages using the SSIS Configuration Wizard. Whoa, whoa, whoa y
Author:
acoleman
Date: 8/1/2012 Section:
Blog
Build
Configurations
in SSIS 2012
Although not new in SSIS 2012, Build Configurations have become exponentially more useful with the introduction of parameters and the new project deployment model. Before we dive in to see how useful this feature is, let's take a moment to review paramete
Author:
cprice1979
Date: 3/6/2012 Section:
Blog
tags :
Tips and tricks
,
Visual Studio 2010
Secure SSIS
Configurations
with BIxPress
Below I will show you how BIxPress can protect sensitive information inside your SSIS packages such as passwords, connections strings, variables etc. As you can see below I have an SQL configuration table that contains a variable I created for this demo.
Author:
ChrisAlbrektson
Date: 1/15/2012 Section:
Blog
tags :
BIxpress
,
BIxPress Secure Configuration Wizard
,
SSIS Configurations
Its 10 PM, Do You Know Where Your
Configurations
And Expressions In SSIS Are? BIxPress Does And It Will Tell You Too.
With some of the more complex SSIS packages that we develop the number of expressions we use as well as the number of package configurations can become quite large. That can make remembering which component has an expression and what that expression
Author:
TomLannen
Date: 9/14/2011 Section:
Blog
Something different - building you own home NAS
A little about me: I’m a bit of “gadget geek” – I’ve been working with and on computers since 1982 when I got my first Atari 1200xl. I was hooked almost immediately. I spent hours typing in code listings and hours more waitin
Author:
KeithHyer
Date: 12/12/2011 Section:
Blog
tags :
FreeNAS
,
hardward
,
iSCSI
,
storage
Package Confurations
If you're using the environment variable to configure your connection manager to the Configuration Database, you only need one environment variable. That single environment variable can be referenced in all of the packages that need to use your configurat
Author:
DustinRyan
Date: 7/1/2010 Section:
Forum
SSIS Help
Yes. You should look into Package Configurations. They can be found and configured in BIDS under SSIS >> Package Configurations. Google "SSIS Package Configurations" and you will find plenty of articles that will help you make informed decisions abo
Author:
Daniel
Date: 7/24/2012 Section:
Forum
Package Confurations
Hi Veni. I was replying but there is some bidn issues, and you have the dustin's reply already. For more detail I advise you to take a look into books online. I will give you my professional experience. Environment variables - I dont use this a lot. For e
Author:
marcoadf
Date: 7/1/2010 Section:
Forum
ETL - How to set a default value in a global variable
This is precisely what package configurations are for. Create your desired variable in each package and then use a package configuration to set the value of that variable. You can control the value of the variable across all packages with the package conf
Author:
DustinRyan
Date: 10/19/2011 Section:
Forum
tags :
Package Configurations
Transfer Package from One Server to Other Server
You might want to look at this Blog post about package configurations. http://www.bidn.com/blogs/DonnyJohns/ssas/1698/ssis-package-configurations This lets you make some of your package settings ( such as paths, connections strings, etc ) external to your
Author:
KeithHyer
Date: 8/4/2011 Section:
Forum
tags :
package configurations
,
ssis
XML file holds parameters for batch file - how to read in
Sounds like you want to setup a package configuration file. Here's a good article on how to do that: http://www.simple-talk.com/sql/ssis/xml-configuration-files-in-sql-server-integration-services/ Additionally, here's a webinar on dynamic SSIS packages us
Author:
sqlchicken
Date: 1/26/2012 Section:
Forum
BI xPress 3.0 Launch
I'm excited to announce the launch of BI xPress 3.0 with new features including: an MDX Calculation Builder, encrypted configurations and deeper auditing framework. If you'd like to see the launch party video, you can see the recording here: http://www.fl
Author:
BrianKnight
Date: 2/3/2011 Section:
Blog
tags :
ssas
,
ssis
,
bi xpress
SSIS Variables and Expressions Webinar
Looks like it is that time again... for me to present a FREE webinar for good ol' Pragmatic Works today at 11AM eastern standard time. The topic today will be SSIS variables and expressions. I previously did a webinar on a similar topic that also included
Author:
BradSchacht
Date: 9/20/2011 Section:
Blog
dynamically execute child package
Not dumb at all! There are lots of ways you can accomplish this. One such way is to have a Parent Package Varibale Configuration in the child packages. You would basically create variables in the parent package that gets pushed into the child package. In
Author:
BrianKnight
Date: 12/21/2009 Section:
Forum
tags :
execute package task
,
variables
Page 1 of 5 (101 items)
<< Prev
1
2
3
4
5
Next >>
Go to page:
[Go]