|
|
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 DTS and Staging Area ... Posted by Muhammad Mansoor at 11/30/2004 11:17:03 PM Hi All,
Currently we are implementing an ETL Process via DTS. There is some
confusion regarding Staging Area.
As far as my understanding is concerned, i feel that the Staging Area
(SA) is the area where where i _EXPLICITLY_ store data from my legacy
system, the reason to use a SA can or can...more >>
Parameters problem Posted by CBarry at 11/30/2004 8:17:01 PM I'm trying to create a transform data task using the following query:
select * from Code_Authorizations_phi where Authorization_pkey in (Select
pkey from Code_Authorizations where dir_pkey = ?)
When I click the 'parameters' button or 'Parse Query' button I get the
following error:
Error Sou...more >>
Copy Database Wizard Fails to Copy Files Posted by Robert at 11/30/2004 5:17:01 PM Running SQL Server 2000 SP3a on Win2000 Server (fully patched).
Trying to get a simple example to work for copying a Test DB (which has one
simple table) on ServerA to ServerB. DB does not exist on ServerB, both
Servers running as services with identical accounts (made administrators; not
...more >>
Transfer DTS packages between servers Posted by Reg Besseling at 11/30/2004 3:31:01 PM Hi all
What is the best way to transfer a DTS package from one server to another?
TIA
Reg
...more >>
Import a DTS Package? Posted by DavidM at 11/30/2004 1:14:51 PM Hello -- I have a file named mypackage.dts that was e-mailed to me. I need
to install this DTS package on my SQL Server box. How do I accomplish this?
I do not see an Open or Import option on the DTS local within Enterprise
Manager for me to add package.
Any help would be appreciated.
...more >>
Transfer Sql Server DTS Packages !?! Posted by Vinny Vinn at 11/30/2004 10:37:02 AM How can i transfer a DTS Package from one machine to another?(Is there a file
containing the script that runs the package that must be moved?).
Thanks In Advance,
Vinny...more >>
XML and DTS Posted by Paulo at 11/30/2004 10:05:04 AM Can I specify a XML file as a Source file in a DTS package? How? If not, what
is the best way to map XML data to my relational database?...more >>
DTSrun Posted by Jeff Ericson at 11/30/2004 9:07:03 AM When I encrypt a DTS package that has global variable using DTSrun, I cannot
use a package password. Any DTS package saved with an owner password fails
with below even though the owner password is set on the dtsrun command line
using /m. The package has sensitive info in the global variables...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
export data as SQL text? Posted by dlm at 11/30/2004 9:01:01 AM Does anyone know of a SQLServer tool or other, such as DTS that allows me to
export my SQLServer data to a SQL text file (or perhaps less preferably to
XML)? The resulting file would assumidly look like a bunch of "INSERT"
statements for the putting the rows of data back into their respective ...more >>
FILE Line Count.... Posted by Ram Achar at 11/30/2004 8:52:10 AM How to read number of lines in a flat file using a DTS package?
I am using SQL 2K.
Thanks,
Ram
...more >>
File TimeStamp... Posted by Ram Achar at 11/30/2004 8:51:35 AM How to read a file time stamp of a flat file using a DTS package?
I am using SQL 2K.
Thanks,
Ram
...more >>
Loop to another task at eof? Posted by mo NO[at]SPAM idcomm.com at 11/29/2004 2:10:17 PM I've got a DTS package that creates several excel spreadsheets, and
stores them with their last name and date. I use a global variable for
distinct HR names from an Execute SQL task output parameter.
The package loops thru each record in the rs and skips the data pump
if there aren't any recor...more >>
Reset Failed Status on DTS Posted by Nathan Truhan at 11/29/2004 6:37:06 AM Hello,
I have written a couple of DTS packages that pull information from an FTP
web site to a directory on the local SQL server then imported into the
database and processed. Seems fairly simple, however. The files are placed
in the FTP server from our Mainframe, and occationally, they a...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |