Using Data Transformation Services, part 2: Using the DTS Designer Objects - Creating a connection to MS Excel

(Page 4 of 6 )

Create an MS Excel file (called MSA.xls in this example) in your file system. Drag and drop an Microsoft Excel 97-2000 connection from the Menu item, or from the Connection Collection on the left of the designer. This brings up the following window. Using the ellipsis button ... locate the MSA.XLS file. This of course assumes a New Connection.

Adding another Transform Data Task

Very similar to what we did earlier, we add another Transform Data Task. This time we start with the MS Access connection to the MS Excel connection. Each individual step is not shown, as the process is exactly the same. Now the three data connections with the two transform data tasks will appear like this in the DTS Designer.

Next: Configuring the Transform Data Task >>
 

More MS SQL Server Articles
More By Jayaram Krishnaswamy

Comments On: Using Data Transformation Services, part 2: Using the DTS Designer Objects

· This is a good article about using the DTS Designer to create DTS packages, but it...    · Everything about DTS is covered by Microsoft, including this one. While this covers...    · have read your articles regarding DTS, they are very useful, but still i have some...    · You seem to have two different servers, and looks like you need to write a trigger...    · Hi Jayaram,I am developer, i am not getting what you exactly saying?Please can...    · I have read your articles and they are very useful,but still i have some...    · The options I suggested are just possibilities. Can they work? I need to test them...    · Hi, I found your DTS lesson very helpful; I looked for a decent tutorial for DTS in...   >>> Post your comment now!