Basics of XML and SQL Server, Part 4: Create an XML invoice with SSIS
This article demonstrates how to build an SSIS package that generates an XML invoice document from data stored in SQL Server and saves it to an XML file.
2012-03-28
3,935 reads
XSLT
Basics of XML and SQL Server, Part 3: Transform and Shred XML in SSIS
This SSIS package performs multiple XSL transformations on an XML document, then shreds the transformed document and inserts its data into a SQL Server table.
2012-03-21
3,674 reads
Basics of XML and SQL Server, Part 1: Streaming XML
This article demonstrates how to generate an XML stream from SQL Server using the 'FOR XML PATH' statement, and how to explore that XML stream interactively using an XSL transformation.
2012-03-07
7,756 reads
RE: Problem w/temporary tables in Stored Procedure accessed by SSRS
In addition to the fact that it takes less time to spin up on the Reporting Services, I trust the Database Driver for SQL to release connections (which I've been having no end to problems with Crystal), more of our people are familiar with the Visual Studio environment, etc, etc. Makes it more cost effective […]
2004-07-23
2 reads
RE: Import and export data
Can i do some thing like this?. SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE PROCEDURE EXPORT_IMPORT_DATA(@direction CHAR(20)) AS DECLARE @Table_Name CHAR(100) DECLARE @sql CHAR(200) DECLARE tablename_cursor CURSOR FOR SELECT name FROM sysobjects WHERE xtype = 'U' OPEN tablename_cursor FETCH FROM tablename_cursor INTO @Table_Name WHILE @@fetch_status = 0 BEGIN BEGIN TRANSACTION IF @direction = […]
2003-11-21
1 reads
2003-11-21
RE: How to import a .sql file with DTS
Replace filename with the name of the .sql file, eg if the file you want to execute is called test.sql in the temp directory of your c: drive then would use isql /S servername /U username /P password -d databasename -b /m-1 /i c:\temp\test.sql Remember to change the other parameters as well.
2003-11-19
1 reads
RE: DTS Connection - ANSI_NULLS setting
quote: I have had this problem before and the solution was to create the procedure from QA not EM. Do you have to create the proc from DTS? Could you not call the procedure from DTS? The point is to create the view dynamically and this is only one step in a very complex DTS […]
2003-11-19
1 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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