A brief history of SSIS evolution
Learn about the history and different versions of Integration Services (SSIS) in SQL Server.
2021-11-12
4,892 reads
SSDT
SSIS Basics: Bulk-Import various text files into a table
For this post I will show you how to bulk insert multiple files in a folder to a SQL Server database, regardless the file name or extension, this with the help of the ForEach Loop Container.
2018-10-09
12,173 reads
Installing SSDT and creating your first SSIS Package
SQL Server Data Tools (SSDT) is a toolset which provides an environment for you to carry out all your database design work in SQL Server. It can be used to build to build SQL Server relational databases.
2018-07-09
58,759 reads
RE: XML dump of major dataset
how does your 'quick and dirty' vbscript perform the operation?you could use a 'for xml' query to get xml data out into an ado stream and write it to a file. you could also open the recordset directly and perform a .save with adpersistxml flag set. or you could use a shaped recordset and save […]
2005-04-27
Can''t upload reports
I usually use the upload functionality to deploy reports. Today, when I click "OK" to upload the new RDL file, nothing happens. This worked fine for me last Thursday. The only change I know about is that 4 patches were pushed to my workstation on Friday, (KB840315,KB841872,KB841873,KB842526). I have looked these up and don't really […]
2005-03-28
2 reads
Date calculation trigger problem
I am trying to code an after insert, update trigger that will calculate a date but I am having a problem with my date variables being an invalid data type. I rightly or wrongly chose to try and perform this operation using a trigger because of a condition has to be tested and a few of the fields […]
2005-03-28
1 reads
Blogs
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers