This script is an example of how to use the Sequence container, which is similar to Identity.
The Sequence number can be used just like identity, but the best advantage is visible when we don't want to on or off the identity property when we need to add explicity value in the column.
IF NOT EXISTS (SELECT TOP 1 NULL FROM sys.sequences where name = 'test01') CREATE SEQUENCE [dbo].[test01] AS [dbo].[HVCIDdt] START WITH 1 INCREMENT BY 1 MINVALUE -9999999999999999 MAXVALUE 9999999999999999 CACHE GO IF NOT EXISTS (SELECT TOP 1 NULL FROM sys.tables where name = 'T1') CREATE TABLE dbo.T1 ( ID [HVCIDdt]NOT NULL DEFAULT (NEXT VALUE FOR dbo.[test01]), Value INT ) GO INSERT INTO T1(Value) SELECT 1 INSERT INTO T1(Value) SELECT 2 INSERT INTO T1(Value) SELECT 3 select * from T1
As we briefly mentioned in the previous installment of this series, among features introduced in the SQL Server 2005 Integration Services there are For and ForEach loops, implemented in the form of containers that can be incorporated into the Control Flow part of a package design.
2005-07-12
1,793 reads
InfoPath forms can be saved to XML, these XML Files can later be used in SSIS XMLSource adapter to pull out the data in tables and columns. However, there are some common problems you may meet in these scenarios. This article describes how to work around these potential problems. The issues mentioned in this article is not only specific to InfoPath files, it can also be referenced in other similar situations as well.
2005-06-20
1,328 reads
The Data Trasformation Services are a powerful tool, and sometime its features are so useful that you’d like to invoke a DTS package not only from SQL Server but from an external program.
To do this you have several choices: you can use the DTSRun.exe tool or you can do it leveraging the SQL-DMO features.
Unfortunately if you’re developing a web application (ASP, ASP.Net or whatever you use) none of them seems to be the right choice: too much problems, too much effort and a very modest results. In addition none of these solutions can be called asynchronously: if you just need to implement a “fire-and-forget” technique, you just cannot do that!
2005-05-24
2,663 reads
One of the age old problems in DTS is moving packages between your development, test and production environments. Typically a series of manual edits needs to be done to all the packages to make sure that all the connection objects are pointing to the correct physical servers. This is time consuming and gives rise to the possibility of human error, particularly if the solution incorporates many DTS packages. Many companies have provided their own custom solutions for managing this problem but these are still workarounds for a problem that is inherently DTS's.
2004-12-14
1,761 reads
SQL Server 2005 has made it a lot easier for us to loop over a collection and with each iteration do something with the item retrieved. In this article we are going to show you how to iterate over a folder looking at the files within and doing something with those files. In this instance we will be entering the filename into a SQL Server table and we will then load the actual files we have just found into another SQL Server table. You will note here that there is still the need to load the file names into a table as an intermediate step just as we need to do in SQL Server 2000.
2004-11-17
2,506 reads
