Build your Microsoft SQL Server expertise with technical deep dives for your database journey. Free PDF eBooks from Microsoft SQL Server eBook series Get the technical resources and documentation you need to explore SQL Server 2017 – a comprehensive, mission-critical database for demanding workloads. With this series of technical eBooks on SQL Server, you’ll learn […]
You are browsing archives for
Tag: SSIS
Beta Testers Wanted CFA Bushfire Warnings and NSW Police Alerts
Now we need your help in fine tuning our bushfire warnings. We are in the process of adding CFA Bushfire Warnings and NSW Police Alerts to EWN. We will be adding other states soon after. We are working hard on this now and want to get it right the first time. These alerts could help […]
Converting SSIS Data Types to .Net Data Types
If you use Scripting tasks, the CLR or build components for SSIS, you will need to convert values from their SSIS types into .Net types. Here’s a quick list of the SSIS data types and their .Net companion. Integration Services Data Types Managed Data Type DT_WSTR DT_TEXT DT_STR System.String DT_BYTES DT_IMAGE System.Byte[] […]
Generating a new SSIS Package GUID with the dtutil Utitlity
If you make a copy of a .dtsx file, the Package ID property remains the same. This value is logged as the SourceID, and to ensure it is unique, you should generate a new value for any copies of a package. dtutil /FILE "Copy of sample.dtsx" /IDRegenerate Or the short hand version dtutil /FILE "Copy […]
Simon Sabin’s SSIS Raw File Reader
Ever used a Raw File destination in SSIS ? They’re FAST! Writing rows from the pipeline to disk as quickly as possible. Raw Files are useful for increasing the throughput speed of a data flow task by using them in Extract / Transform procedures. The reason they are so efficient is they stored the data […]
Limitations of SQL Server 2005 Express Edition
The free version of SQL Server 2005 is the “Express” edition. Its a cut down version of SQL Server 2005 and is ideal as an upgrade from Access, for desktop use or small multi-user databases. Its not designed for large scale production use, and comes with a number of limitations. The most notable limitations are: […]
Using Expressions with SSIS Maintenance Tasks and SelectedDatabases
Its been noted by a few people that Expressions cannot be used to configure the Shrink Database Task at runtime. The problem is that the SelectedDatabases property is a collection which cannot be created by an expression. The same problem occurs in most of the Maintenance Task items of SSIS. Maintenance Plan Task components are […]
Sydney SQL Server Users Group – Mon 6th Nov 2006
SQL Server (Sydney) Users Group meeting has been moved to Monday 6th November 2006 when Richard Lees will present “OLAP, what is it good for?” Richard will show the insides (and outsides) of an OLAP cube created to assist in monitoring and managing a 6 node Oracle RAC database that sustains 600 transactions per second […]
No!!! Undo, Undo, Undo!!
Or rather, why is there no “undo” in when working with Integration Services packages? This has been something that has me puzzled me since working with Beta 2 of Integration Services. I guess I figured it would be fixed by RTM, and just worked around the issue by regularly checking in finalised changes, and saving […]
SSIS Lookup with value range
Joe Salvatore called out for help on an interesting use of the SSIS Lookup component: Can you lookup a row using a value within a range? Joe specified his criteria as: DataStagingSource.ModifyDate < DataWarehouseDimension.RowExpiredDate AND DataStagingSource.ModifyDate >= DataWarehouseDimension.RowEffectiveDate AND DataStagingSource.NaturalKey = DataWarehouseDimension.NaturalKey Easy! To show how it is done I’ve created a test database “SCRATCH” […]