THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SSIS » nugget » flat file source   (RSS)
  • FileNameColumnName property, Flat File Source Adapter : SSIS Nugget

    I saw a question on MSDN’s SSIS forum the other day that went something like this: I’m loading data into a table from a flat file but I want to be able to store the name of that file as well. Is there a way of doing that? I don’t want to come across as disrespecting those who took the time to reply but there was a few answers along the ...
    Posted to Jamie Thomson (Weblog) by jamiet on March 31, 2010
  • Parsing flat files using SSIS : SSIS Nugget

    Often when using SQL Server Integration Services (SSIS) you will find there is more than one way of accomplishing a task and that the most obvious method of doing so might not be the optimal one. In the video below I demonstrate this by way of an experiment using SSIS’s Flat File Source component; I show different ways that you can pull data from ...
    Posted to Jamie Thomson (Weblog) by jamiet on March 24, 2010
Privacy Statement