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 » SQL Server Inte... » 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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement