Using ActiveX to Dynamically set a Variable in an SQL Server DTS Package
From time to time, you will need to dynamically set a variable in the middle of your DTS packages. The […]
SQL Blogs
SQL and SQL Server database topics. Includes design, issue resolution and tips.
SQL Blogs
Using NOCOUNT, ANSI Warnings and Temp Tables in SQL Server
Here are a few useful code fragments that I use all the time. You see too many Rows Affected Messages.
Change a Date Format Using ActiveX and SQL DTS Transformations
Let’s say you are importing data from a flat file to SQL Server via DTS. Now, let’s say the date
SQL Blogs
Adding Foreign Keys after a table is created in SQL Server
Well, you knew exactly what you needed when you created a table. Only now when you created a child table,