Sign in
|
Join
|
Help
Home
Blogs
WordPress Blogs
Media
All Tags
»
SSIS - Integration Services
(
RSS
)
MVP WordPress Blogs
Loading...
Tags
.NET
Advisories / Bulletins
ASP.NET
C#
Community
ConfigMgr 2007
Digital Media
Events
Exchange
General
General Security News
Media Center
Microsoft
News
Rants
Security
Sharepoint
SPPS03_Tips
SQL Server
System Center
Tools
VB
Vista
Windows 7
Windows Server
Browse Blog Posts by Tags
Showing related tags and posts for the
Blogs
application. See
all tags in the site
Bugs
Performance
Query Tuning
SQL Server 2005
SQL Server 2008
SSAS
Tips and Tricks
Tools and Components
Training
SQL Server Training in the UK–SSIS, MDX, Admin, MDS, Internals
If you are looking for SQL Server training they there is no better place to start than a new company Technitrain Its been setup by a fellow MVP and SQLBits Organiser Chris Webb. Why this company rather than any others? Training based on real world experience...
Posted to
SimonS Blog on SQL Server Stuff
by on Wed, Nov 23 2011
Filed under:
Filed under:
Training
,
Performance
,
Query Tuning
,
SSIS - Integration Services
,
SSAS
How to downgrade Integration Services 2008 packages to 2005
Courtesy of an unnamed source we have an app to downgrade a SSIS package from the 2008 version to 2005. Whilst it works with the common components any new components aren’t supported with the exception of the Lookup. 3rd party components are also not...
Posted to
SimonS Blog on SQL Server Stuff
by on Wed, Oct 20 2010
Filed under:
Filed under:
SQL Server 2008
,
SQL Server 2005
,
SSIS - Integration Services
,
Tools and Components
SSIS - character number "81" was not recognized
If you get the following error when trying to write an expression there is an easy solution Attempt to parse the expression "@[User::FilePath] + "\" + @[User::FileName] + ".raw"" failed. The token "." at line number...
Posted to
SimonS Blog on SQL Server Stuff
by on Thu, Mar 4 2010
Filed under:
Filed under:
Tips and Tricks
,
SSIS - Integration Services
SSIS - The expression cannot be parsed because it contains invalid elements at the location specified
If you get the following error when trying to write an expression there is an easy solution Attempt to parse the expression "@[User::FilePath] + "\" + @[User::FileName] + ".raw"" failed. The token "." at line number...
Posted to
SimonS Blog on SQL Server Stuff
by on Thu, Mar 4 2010
Filed under:
Filed under:
Tips and Tricks
,
SSIS - Integration Services
Error: The type of the value being assigned to variable ?? differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables of type Object
If you get the above error and you have no idea why (i.e you haven't changed the data type of a variable) then it is likely due to a data type inference issue with SSIS. You might think that SQL is returning a value of one type when in fact it isn't...
Posted to
SimonS Blog on SQL Server Stuff
by on Tue, Jan 19 2010
Filed under:
Filed under:
Tips and Tricks
,
SSIS - Integration Services
,
Bugs
Page 1 of 1 (5 items)