Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by entrekken
-
Export Query
This is what I did: 1. I created a DTS package using SQL Enterprise Manager's GUI DTS package creator. I called it MyDTS. 2. I created the following stored procedure SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS OFF GO /****** Object: Stored Procedure dbo.spMyDTS Script Date...- entrekken
- Post #6
- Forum: Microsoft SQL Server: Programming
-
2 osql questions:
I figured some stuff out and thought I'd post it for the community: To resolve issue #1: I switched to using an isql command stored in a bat file. I call the bat file in a DTS package using the execute process task. I create a stored procedure to run the DTS package. Then I schedule the DTS...- entrekken
- Post #3
- Forum: Microsoft SQL Server: Programming
-
2 osql questions:
One Correction/Clarification: I noticed in the code I sent that the command reads isql. It should be osql. I tried both commands trying to see which one would be better and osql won!- entrekken
- Post #2
- Forum: Microsoft SQL Server: Programming
-
2 osql questions:
1. I am running the following osql command from within a stored procedure (I took out all sensitive info :) ). I get the following error message: '[ODBC Driver Manager] Data source name not found and no default driver specified' I checked my ODBC connection in the ODBC connection manager and...- entrekken
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
