Calculating LastXMonths Aggregations Using T-SQL and SSIS

by Valentino Vranken 26 August 2010 20:25

With the holidays I haven’t been able to write much. So I’ll make up for it with this +3000 words article. If you’re reading this early in the morning, you’d better get a double espresso first In this article I will demonstrate a method that can be used to calculate aggregations over a certain [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: integration services, sqlserverpedia syndication, t-sql, data, ssis

A Developer's Blog

Remove Unused Columns From The Data Flow

by Valentino Vranken 12 May 2010 16:25

Consider the following scenario. You’ve been developing some SSIS packages, nicely making sure that all errors and warnings are gone from the Error List window. So the next step is to deploy the packages to the server and schedule them. After some days you decide to have a look at the sysssislog table and discover [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: integration services, data, integration services 2008, ssis

A Developer's Blog

Importing Data Using The Wizard: Mixing The Wrong Ingredients

by Valentino Vranken 3 May 2010 20:39

A while ago I wrote an article about how you can use the SQL Server Import and Export wizard to import Excel data into a SQL Server database. In this sequel I’m going to show you some problems which you may encounter when using that wizard. Just like any good old wizard, he’s only as [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: integration services, sql server, data, excel, ssis

A Developer's Blog

Importing Excel Data Using Integration Services

by Valentino Vranken 20 April 2010 21:21

In a previous article I’ve shown you how to import data from an Excel sheet using the OPENROWSET() function. And I concluded by stating that it’s not the best option when automating your data import. Today I’ll repeat the Excel data import process by using SQL Server Integration Services, also known as SSIS. I’ll be using SQL [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: integration services, data, excel, ssis, tutorial

A Developer's Blog

Recursively Delete SSIS Folder

by Valentino Vranken 28 February 2010 22:12

A while ago I posted a query to create a list of all the Integration Services packages deployed to the MSDB. I am now using that query to take it a step further. If you’ve been using SSIS for a while you’ve probably noticed that the Management Studio doesn’t like to delete Integration Services folders that [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: integration services, t-sql, data, script, ssis

A Developer's Blog

SSIS: Adding Files To The Miscellaneous Folder

by Valentino Vranken 11 February 2010 22:20

Sometimes my posts are over 20 pages long when pasted into a Word document. That’s when I call them article, or tutorial. Other times I post real quickies about little things that have annoyed me in the past, because I had to spend too much time looking for a solution to a certain issue, or [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: integration services, data, ssis, tfs

A Developer's Blog

List All SSIS Packages Deployed On Your Integration Server

by Valentino Vranken 10 January 2010 22:23

When deploying packages to SQL Server Integration Services, it’s advisable to set up a folder structure so that you can easily distinguish packages belonging to different projects. Furthermore it may be interesting to create subfolders under the main project folder to separate packages according to the different phases in your ETL (Extract, Transform, Load) process. [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: integration services, t-sql, data, etl, ssis

A Developer's Blog

SQL Server Day 2009 videos now available on Chopsticks

by Davy Knuysen 16 December 2009 10:10

Microsoft has made the sessions presented on SQL Server Day 2009 available on Chopsticks Opening Keynote by Wesley Backelant and Ritchie Houtmeyers Best Practices for SQL Server Consolidation by Tom Van Mulders Breaking the ETL world record with Integration Services by Henk van der Valk Designing Effective Aggregations in Analysyis Services 2008 by Chris Webb [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: .net, analysis services, bi, event, events, excel services, integration services, mdx, moss, office, powerpivot, reporting services, sql 2008 r2, sql server, sqlug.be, chopsticks, sharepoint

Davy Knuysen

Fun With Strings

by Valentino Vranken 4 October 2009 11:07

Initially I was going to call this article "Struggling With Collation: The SeQueL", but it just doesn’t have the same ring to it as "Fun With Strings". In that previous article I showed how you might get different results when loading data from a temporary table or table variable and I suggested that one way [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: sql server, t-sql, collation, data, integration services, ssis

A Developer's Blog

Connect to SSIS Service failed: Error loading type library/DLL

by Davy Knuysen 18 September 2009 09:44

After installing SQL Server Integration Services on an existing 64-bit SQL Server, I was unable to connect to SSIS using Management Studio. The database engine and Analysis Services was already installed on this server. I added the SSIS service without Service Pack and applied SP3 afterwards. When trying to connect, Management Studio returned the following error [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: bi, integration services, sql server, uncategorized, data

Davy Knuysen

Blog N-Technologies

Calculating LastXMonths Aggregations Using T-SQL and SSIS

Remove Unused Columns From The Data Flow

Importing Data Using The Wizard: Mixing The Wrong Ingredients

Importing Excel Data Using Integration Services

Recursively Delete SSIS Folder

SSIS: Adding Files To The Miscellaneous Folder

List All SSIS Packages Deployed On Your Integration Server

SQL Server Day 2009 videos now available on Chopsticks

Fun With Strings

Connect to SSIS Service failed: Error loading type library/DLL

RecentPosts

Blog N-Technologies

Tag cloud

RecentPosts