T-SQL.dk

A blog on code, coffee & curiosities

Search
  • About
  • Contact
  • Engagements
    • Delivering BI Continuously
  • Volunteering
Skip to content

Tag: SSIS 2008

Programming

Microsoft Visual Studio is unable to load this document

Jens Vestergaard12/06/201412/06/2014 Leave a comment

This issue has actually been on my TODO list for quite some time. Now I had to go back to an old SSIS package and do some changes, I got reminded of how annoying this bug is. The scenario is SQL Server Integration Services 2008 R2 combined with loading an Excel file. This should in […]

Read the article
Programming

TBP – Tripple Businesskey Problem, the lesser known problem…

Jens Vestergaard12/02/2013 Leave a comment

I have come across a rather, for me at least, unusual data composition, and wanted to share the solution to the business problem. Given is one single source file that contains facts and some dimensional identification. In this case, we have a single measure, lets call it A, and several columns of data that is to […]

Read the article
Programming

Mit Microsoft Connect forslag er blevet implementeret

Jens Vestergaard30/06/2011 Leave a comment

Mit beskedne bidrag til næste version af SSIS er hermed i hus. I går fik jeg bekræftelse fra Microsoft om, at forslaget har fundet vej til enten næste version eller næste service pack.              

Read the article
Programming

Temmelig misvisende fejlbesked i SSIS 2008

Jens Vestergaard23/09/2010 Leave a comment

Har lige brug lidt tid på at finde ud af hvad i h#¤%” denne fejlbesked rent faktisk betyder: Failed to set property “OutputColumnLineageID” on input column <bla bla bla> betyder reelt set, i hvert fald i dette tilfælde, at der er mismatch mellem to datatyper. I mit tilfælde opstod fejlen ved en Union All hvor […]

Read the article
Programming

Maksimum 31.303 tegn (inkl. mellemrum) i Execute SQL Task?

Jens Vestergaard17/08/2010 Leave a comment

Det er ihvertfald det højeste jeg umiddelbart kan proppe ind i tekstboksen igennem UI’en. Er der nogen der ved hvilken grænse der officielt er på denne task? Lidt ærgeligt at man oven i købet ikke bliver advaret om at ens script bliver trunkeret…

Read the article

Categories

  • Coffee (9)
  • Community (56)
  • Entry Level (12)
  • Family (3)
  • Mixed (50)
  • Music (5)
  • Personal (4)
  • Programming (179)
  • Roleplay (6)
  • The Who (3)
  • tsql2sday (13)

Tags

.Net Analysis Services azure BI Business Intelligence C# Coffee Community D&D entrylevel Espresso FAIL Fejl Humor iot IWantToShare MCP MDX MsBIP MSConnect NFL Personal PowerBI Powershell Security Speaking SQL SQL2012 sqlfamily SQLPASS sqlsaturday SQLServer SQL Server SQL Server 2008 SQLTip SSAS SSIS SSIS 2008 SSMS SSRS T-SQL Teradata TSQL2SDAY VS2008 VS2010

LinkedIn

I am happy to connect on LinkedIn:

Jens Vestergaard

Subscribe

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Categories

  • Coffee
  • Community
  • Entry Level
  • Family
  • Mixed
  • Music
  • Personal
  • Programming
  • Roleplay
  • The Who
  • tsql2sday

Archives

LinkedIn

I am happy to connect on LinkedIn:

Jens Vestergaard

Social

  • View vestergaardj’s profile on Twitter
  • View vestergaard_jens’s profile on Instagram
  • View jvestergaard’s profile on LinkedIn
Theme: Ameno by BG Web Agency