-
Recent Posts
Tweets
- @Azure_Synapse Hi, many thanks for your feedback and support. I cannot find the DM button in your profile 🙈 https://t.co/JSNIv4A0Ed 1 day ago
- "Security is a process, not a product." Pablo Endres #npm #pypi #cybersecurity #dangerousworkflow lnkd.in/eeQQCA9k 3 days ago
- In this article I describe an alternative way to parameterize pipelines in Azure Synapse. The idea is also valid fo… twitter.com/i/web/status/1… 4 days ago
- In this article I present an alternative parametrization for #AzureSynapse pipelines I used in some projects.… twitter.com/i/web/status/1… 5 days ago
- In this amazing video from @KasamShaikh you will learn step by step, with an easy-to-follow presentation and demo,… twitter.com/i/web/status/1… 6 days ago
Archives
Categories
-
Join 432 other followers
Meta
Blog Stats
- 274,774 hits
Monthly Archives: February 2013
Store file names and modified dates in a table without a Foreach Loop Task – SQL Server – SSIS
Last week I received a request from the project manager. I had to improve the performance of an SSIS package that reads a collection of files from a source folder, and then stores their name, extension, location and modified date. … Continue reading
Posted in Business Intelligence, SQL Server
Tagged files, shell command, sql server, SSIS 2008, xp_cmdshell
5 Comments