microsoft.public.sqlserver.dts

Date Index

Re: Record Length of DTS text file, Narayana Vyas Kondreddi
Re: Start and stop a Windows Serrvice on a Remote machine, Ilya Margolin
File splitter, karenmiddleol
- Re: File splitter, Darren Green
- Re: File splitter, David J. Cartwright
RE: SSIS Connection, Peter Yang [MSFT]
- Re: SSIS Connection, Michael Tissington
  - Re: SSIS Connection, Peter Yang [MSFT]
    - Re: SSIS Connection, Michael Tissington
Re: time based import, Allan Mitchell
Re: transforming dollar amounts, Allan Mitchell
Change the file location dynamically?, Test Test
- Re: Change the file location dynamically?, Panch
  - Re: Change the file location dynamically?, Test Test
- Re: Change the file location dynamically?, Allan Mitchell
  - Re: Change the file location dynamically?, Test Test
    - Re: Change the file location dynamically?, Test Test
DTS Import Table Issue, Scott
- Re: DTS Import Table Issue, Allan Mitchell
  - Re: DTS Import Table Issue, Scott
SQL 2005, Michael Tissington
- Re: SQL 2005, Allan Mitchell
  - Re: SQL 2005, Michael Tissington
    - Re: SQL 2005, Allan Mitchell
Re: I need URGENT help about **Lost DTS password**, Ross Presser
AS400 - MS SQL -> Function did not complete successfully, LAB
where dts package runs, prefect
- Re: where dts package runs, prefect
  - Re: where dts package runs, Panch
  - Re: where dts package runs, Panch
    - Re: where dts package runs, Allan Mitchell
    - Message not available
    - Re: where dts package runs, uykusuz
How to find the package using a task, karenmiddleol
- Re: How to find the package using a task, Allan Mitchell
  - Re: How to find the package using a task, karenmiddleol
Re: How to use stored procedure output as data source, Panch
Re: Import from Excel with variables, Panch
DTS Package problem, kibagami23
Re: How to backup DRS packages, Kevin3NF
- <Possible follow-ups>
- Re: How to backup DRS packages, steve.hughes@xxxxxxx
  - Re: How to backup DRS packages, michael v
Re: DTS JOB Schedule Help Me, Darren Green
Export data to mySQL, Sara T.
- Re: Export data to mySQL, Thomas Bradshaw via SQLMonster.com
Re: How to read 2 lines as 1 record from delimited text files, Allan Mitchell
Re: Transforming Into Multiple Rows, Allan Mitchell
Text file import is dropping records, gtm808
- Message not available
  - Re: Text file import is dropping records, gtm808
    - Re: Text file import is dropping records, AK
Re: File naming issue, Allan Mitchell
- <Possible follow-ups>
- Re: File naming issue, Darren Green
Oracle Import Package Runs fine in designer, but when run with dtsrun in a schedule sql agent job it failes., David J. Cartwright
setting DTS Global Variables, Leo
- Re: setting DTS Global Variables, Darren Green
  - Re: setting DTS Global Variables, Leo
conditioned creation of view, michael v
- Re: conditioned creation of view, Darren Green
  - Re: conditioned creation of view, michael v
Dynamic Properties Task in 2005?, stevewest1
- Re: Dynamic Properties Task in 2005?, Darren Green
trouble using index optimizer, michael v
- Re: trouble using index optimizer, Allan Mitchell
  - Re: trouble using index optimizer, michael v
Temporary table (#table), pm
- Re: Temporary table (#table), Ilya Margolin
Re: DTS Access Error, Allan Mitchell
Re: MapiLogonEx Failed due to MAPI error 273, Darren Green
- <Possible follow-ups>
- Re: MapiLogonEx Failed due to MAPI error 273, Darren Green
Active X script to read text file, tab-delimited, CD
- Re: Active X script to read text file, tab-delimited, Darren Green
  - Re: Active X script to read text file, tab-delimited, CD
DTS Error 80040005, Dave B
- Re: DTS Error 80040005, Allan Mitchell
  - Re: DTS Error 80040005, Dave B
dts and c#, myo zaw
- Re: dts and c#, Allan Mitchell
  - Re: dts and c#, Myo Zaw
DTS Errors, DKRReddy
- Re: DTS Errors, Darren Green
Re: Overrun of a scheduled DTS package., Sue Hoegemeier
DTS Package Call tree, Raj
RE: Can xml download be done w/o a browser using dts?, Dave
- Re: Can xml download be done w/o a browser using dts?, Darren Green
Textdatei Import - keine Spalten, Michael Kruss
- Re: Textdatei Import - keine Spalten, Thomas Bradshaw via SQLMonster.com
  - Re: Textdatei Import - keine Spalten, Allan Mitchell
Re: https connection using DTS, Darren Green
Re: Error while running a scheduled a DTS package, Andrew J. Kelly
DTS Package Timeout error, DKRReddy
Multi user capability, pm
- Re: Multi user capability, Allan Mitchell
  - Re: Multi user capability, pm
  - Re: Multi user capability, pm
Export Variable length field, Stephen Costanzo
- Message not available
  - Re: Export Variable length field, Stephen Costanzo
DTS Checking Constraints, Michael Tissington
- RE: DTS Checking Constraints, Michael Cheng [MSFT]
  - Message not available
    - RE: DTS Checking Constraints, Michael Cheng [MSFT]
Structured Storage File Woes..., jamesfreddyc
- Message not available
  - Re: Structured Storage File Woes..., jamesfreddyc
    - Re: Structured Storage File Woes..., Allan Mitchell
    - Re: Structured Storage File Woes..., jamesfreddyc
Re: How do I trackdown/debug COMException -2147220441, Spaz
Re: ActiveX Task - Status = Failure or Success, Darren Green
DTS won't run as scheduled job (DTSStepExecStat_Completed), Dave
- Re: DTS won't run as scheduled job (DTSStepExecStat_Completed), Allan Mitchell
  - Re: DTS won't run as scheduled job (DTSStepExecStat_Completed), Dave
    - Re: DTS won't run as scheduled job (DTSStepExecStat_Completed), Allan Mitchell
    - Re: DTS won't run as scheduled job (DTSStepExecStat_Completed), Dave
    - Re: DTS won't run as scheduled job (DTSStepExecStat_Completed), Dave
Re: moving a dts package, Allan Mitchell
Re: SqlServer 2005: Want to set up SSIS job to import flat file data into 18 tables on a nightly basis, Allan Mitchell
- Re: SqlServer 2005: Want to set up SSIS job to import flat file data into 18 tables on a nightly basis, frostbb
  - Re: SqlServer 2005: Want to set up SSIS job to import flat file data into 18 tables on a nightly basis, Allan Mitchell
    - Re: SqlServer 2005: Want to set up SSIS job to import flat file data into 18 tables on a nightly basis, frostbb
- <Possible follow-ups>
- Re: SqlServer 2005: Want to set up SSIS job to import flat file data into 18 tables on a nightly basis, Andrew Watt [MVP - InfoPath]
  - Re: SqlServer 2005: Want to set up SSIS job to import flat file data into 18 tables on a nightly basis, frostbb
    - Re: SqlServer 2005: Want to set up SSIS job to import flat file data into 18 tables on a nightly basis, Andrew Watt [MVP - InfoPath]
    - Re: SqlServer 2005: Want to set up SSIS job to import flat file data into 18 tables on a nightly basis, frostbb
dynamically read and create excel metadata, pm
- Re: dynamically read and create excel metadata, Allan Mitchell
DTS/Global Variable help needed!, scott . rick
- Re: DTS/Global Variable help needed!, Allan Mitchell
  - Re: DTS/Global Variable help needed!, scott . rick
Access .NET Library from DTS, Des Norton
- Message not available
  - Re: Access .NET Library from DTS, Des Norton
Re: Using a DTS to Append data, Darren Green
- Message not available
  - Re: Using a DTS to Append data, bob at zachys
    - Re: Using a DTS to Append data, Darren Green
    - Re: Using a DTS to Append data, bob at zachys
SET NOCOUNT e cursori, SuperPippo
- Message not available
  - Re: SET NOCOUNT e cursori, SuperPippo
RE: ErrorColumn in SSIS data destination, Wilfried Mausz
dtsrun, Andy
- Re: dtsrun, Darren Green
Re: Stop Developers from creating DTS Packages, Darren Green
How to skip the last n records in a text file while loading, karenmiddleol
- Re: How to skip the last n records in a text file while loading, Ilya Margolin
- Re: How to skip the last n records in a text file while loading, Thomas Bradshaw via SQLMonster.com
Re: Rights to run a DTS Package, Allan Mitchell
- Message not available
  - Message not available
    - Re: Rights to run a DTS Package, jaylou
    - Re: Rights to run a DTS Package, Allan Mitchell
    - Re: Rights to run a DTS Package, jaylou
Re: read in first line of text file, Allan Mitchell
Dynamically importing flat file in SSIS, Uwe
- Re: Dynamically importing flat file in SSIS, Allan Mitchell
  - Re: Dynamically importing flat file in SSIS, Uwe Kuhne
Re: Embedded Text Qualifiers no longer supported in Yukon ?, Frank
- Re: Embedded Text Qualifiers no longer supported in Yukon ?, Peter Yang [MSFT]
  - Re: Embedded Text Qualifiers no longer supported in Yukon ?, Frank
    - Message not available
    - Message not available
    - Message not available
    - Message not available
    - Re: Embedded Text Qualifiers no longer supported in Yukon ?, Peter Yang [MSFT]
Using DTS over a slow unstable connection, jensendarren
- Re: Using DTS over a slow unstable connection, Darren Green
  - Re: Using DTS over a slow unstable connection, jensendarren
    - Re: Using DTS over a slow unstable connection, Darren Green
- Re: Using DTS over a slow unstable connection, Ben Rum
Re: scrubber?, Sue Hoegemeier
DTS and Oracle, David J. Cartwright
- Re: DTS and Oracle, Allan Mitchell
DUP Primary Key, Luis Mena
- Re: DUP Primary Key, Allan Mitchell
  - Re: DUP Primary Key, Luis Mena
Version Issue Calling One DTS Package From Another, phldaniel
- Message not available
  - Re: Version Issue Calling One DTS Package From Another, phldaniel
    - Re: Version Issue Calling One DTS Package From Another, Allan Mitchell
    - Re: Version Issue Calling One DTS Package From Another, phldaniel
Re: SQL Server 7.0 DTS problem, Darren Green
bcp, Johnson
Re: Dynamic SQL Statement at Runtime SSIS SQL Server 2005, Andrew Watt [MVP - InfoPath]
Export to excel, Vikram
Re: Problem transferring Wide tables with DTS, Allan Mitchell
Re: No error before loading a 0 byte file..., Rodney Mullins
- <Possible follow-ups>
- Re: No error before loading a 0 byte file..., Rodney Mullins
DTS Example: Import CSV copy rename delete file..., JDP@Work
- Re: DTS Example: Import CSV copy rename delete file..., Rodney Mullins
  - Re: DTS Example: Import CSV copy rename delete file..., Allan Mitchell
    - Re: DTS Example: Import CSV copy rename delete file..., Rodney Mullins
    - Re: DTS Example: Import CSV copy rename delete file..., Allan Mitchell
DTS Error message -2147467259, Fab
- Re: DTS Error message -2147467259, Allan Mitchell
  - Re: DTS Error message -2147467259, Fab
    - Re: DTS Error message -2147467259, Allan Mitchell
    - Re: DTS Error message -2147467259, Fab
    - Re: DTS Error message -2147467259, Allan Mitchell
    - Re: DTS Error message -2147467259, Fab
    - Re: DTS Error message -2147467259, Allan Mitchell
Re: FTP to UNIX, Ilya Margolin
- Re: FTP to UNIX, Rodney Mullins
  - Re: FTP to UNIX, Allan Mitchell
Re: DTS Parameter on Execute SQL Task, uykusuz
- <Possible follow-ups>
- Re: DTS Parameter on Execute SQL Task, uykusuz
Re: Newbie, partha
Re: Source of DTS-packages, partha
- <Possible follow-ups>
- Re: Source of DTS-packages, Allan Mitchell
  - Re: Source of DTS-packages, Zekske
    - Re: Source of DTS-packages, Allan Mitchell
Releasing DTS from test server to LIVE, Ben Rum
- Re: Releasing DTS from test server to LIVE, Tom Moreau
  - Re: Releasing DTS from test server to LIVE, Ben Rum
    - Re: Releasing DTS from test server to LIVE, Sue Hoegemeier
Looping Excel Files in Transaction, Jordan
datefields on oracle server, michael v
- Re: datefields on oracle server, Sue Hoegemeier
Re: help pls! csv last row problem, Allan Mitchell
- <Possible follow-ups>
- Re: help pls! csv last row problem, Allan Mitchell
how to set up password for existing DTS?, nick
- Re: how to set up password for existing DTS?, Allan Mitchell
  - Re: how to set up password for existing DTS?, nick
RE: restoring the database from azip file, Allan Mitchell
Re: Automating DTS testing, Allan Mitchell
Re: Encrypt Password Field Using DTS?, Allan Mitchell
Re: DTS creating Excessive Sized Text Files, Allan Mitchell
- Re: DTS creating Excessive Sized Text Files, David Eaton
Convert & Cast in DTS Transformation Scripts?, vesta
- <Possible follow-ups>
- RE: Convert & Cast in DTS Transformation Scripts?, Allan Mitchell
Re: Changing DTS Job owners, Thomas Bradshaw via SQLMonster.com
- <Possible follow-ups>
- Re: Changing DTS Job owners, Thomas Bradshaw via SQLMonster.com
- Re: Changing DTS Job owners, Allan Mitchell
Text source Connection, CJMONGO
- Re: Text source Connection, Allan Mitchell
Re: Copying DTS Packages., Darren Green
Newbie question, Kevin
- Re: Newbie question, Tom Moreau
- Re: Newbie question, Ed Enstrom
- Re: Newbie question, Andrew Watt [MVP - InfoPath]
  - Re: Newbie question, Allan Mitchell
Re: Error Ehile Executing DTS task, Allan Mitchell
- <Possible follow-ups>
- Re: Error Ehile Executing DTS task, Allan Mitchell
Re: DTS GUIDs?, Allan Mitchell
Re: shecule job to run a dts package failed., Andrew J. Kelly
Encoding problem when trying to import from dBase files, mehal . box
- Re: Encoding problem when trying to import from dBase files, mehal . box
- Re: Encoding problem when trying to import from dBase files, mehal . box
Re: How can I overwrite an Excel file each day with a DTS package?, Yener
- <Possible follow-ups>
- Re: How can I overwrite an Excel file each day with a DTS package?, Ben Rum
- Re: How can I overwrite an Excel file each day with a DTS package?, Ed Enstrom
Create Excel From SQL Server, Christian Duffett
- Re: Create Excel From SQL Server, Allan Mitchell
  - Re: Create Excel From SQL Server, duffett@xxxxxxxxx
  - Re: Create Excel From SQL Server, synopsis
AWE + dts = system unresponsive during loading..., J�j�
Re: export XML to file, Darren Green
Re: Ignore Duplicates Index fails DTS Job, Allan Mitchell
RE: Invalid transformations detected. Verify and retry your transforma, Allan Mitchell
Can SQL Server import with errors?, kenkrum
- Re: Can SQL Server import with errors?, Allan Mitchell
  - Re: Can SQL Server import with errors?, kenkrum
Dependencies of stored procedures in DTS packages, Matt Williamson
- Re: Dependencies of stored procedures in DTS packages, Jacco Schalkwijk
  - Re: Dependencies of stored procedures in DTS packages, Matt Williamson
    - Re: Dependencies of stored procedures in DTS packages, Matt Williamson
    - Re: Dependencies of stored procedures in DTS packages, Jacco Schalkwijk
DTS connection speed, Ben Rum
- Re: DTS connection speed, Allan Mitchell
- Re: DTS connection speed, Darren Green
  - Re: DTS connection speed, Ben Rum
    - Re: DTS connection speed, Ben Rum
FTP Put, rather than fetch, tease
- Re: FTP Put, rather than fetch, Darren Green
  - Re: FTP Put, rather than fetch, tease
Re: Strange application pop-up error!, Sophie Guo [MSFT]
how to catch and handle errors in bcp or programme calling BCP?, Johnson
Re: DTS Package Job Failure, Darren Green
Primary Key Constraints, gaiams via SQLMonster.com
Re: Creating DTS packages with VB.NET and DB2, Darren Green
Invalid transformations detected. Verify and retry your transformations., jeff
Re: slow dts, Sophie Guo [MSFT]
- Re: slow dts, Sophie Guo [MSFT]
Re: Execute Proccess Hangs In SQL Server Agent, Resant
Re: Packaged Deleted But Still Running/Scheduled, Resant
Re: Derived Column in SSIS, Allan Mitchell
- <Possible follow-ups>
- Re: Derived Column in SSIS, Andrew Watt [MVP - InfoPath]
smalldatetime, Ferdinand Zaubzer
- Re: smalldatetime, Allan Mitchell
New To DTS; Import many databases, Stephan Zaubzer
- Message not available
  - Re: New To DTS; Import many databases, Stephan Zaubzer
    - Re: New To DTS; Import many databases, Allan Mitchell
Executing DTS package in c#, Francois
SQL 2000 SP4 - General network error??, techcs
- Message not available
  - Re: SQL 2000 SP4 - General network error??, DKRReddy
New to DTS, Fab
- Re: New to DTS, Allan Mitchell
  - Re: New to DTS, Fab
    - Re: New to DTS, Allan Mitchell
ActiveX Script Reusable, Luis Mena
Re: DTS Designer Error, Allan Mitchell
Re: Restoring a DTS Package, Allan Mitchell
Re: Problems with Excel data pump, Allan Mitchell
Re: SSIS - Dynamic Data Source, Darren Green
- <Possible follow-ups>
- Re: SSIS - Dynamic Data Source, Allan Mitchell
DTS Transformations, Eli Lawson
- Re: DTS Transformations, Allan Mitchell
  - Re: DTS Transformations, Eli Lawson
  - Re: DTS Transformations, Eli Lawson
    - Re: DTS Transformations, Allan Mitchell
SSIS - Programmatically add slowly changing dimension to data flow, Wilfried Mausz
RE: SQL -> Excel File, Andy
- <Possible follow-ups>
- Re: SQL -> Excel File, David J. Cartwright
Re: how to Execute DTS package in Store Procedure, Sue Hoegemeier
one table corresponds to one text file, Johnson
- Re: one table corresponds to one text file, Darren Green
  - Re: one table corresponds to one text file, Johnson
    - Re: one table corresponds to one text file, Darren Green
DTS'ing Comments in Excel, Drew
Re: Missing: hour/minute / second data (smalldatetime), Thomas Bradshaw via SQLMonster.com
- Message not available
  - Re: Missing: hour/minute / second data (smalldatetime), Andrew J. Kelly
    - Re: Missing: hour/minute / second data (smalldatetime), Beau Frusetta
    - Re: Missing: hour/minute / second data (smalldatetime), Allan Mitchell
Re: I want to collect all records older than 10 days from today from a, Jacco Schalkwijk
Install and uninstall DTS package using a script, McGeeky
- Re: Install and uninstall DTS package using a script, Darren Green
Re: Trimming Varchar data necessary?, Allan Mitchell
- <Possible follow-ups>
- Re: Trimming Varchar data necessary?, Allan Mitchell
Re: DTSRun.exe hangs after executing DTS package., Thomas Bradshaw via SQLMonster.com
'special' characters getting changed during SQL Server -> Oracle migration, jainamber
- Re: 'special' characters getting changed during SQL Server -> Oracle migration, jainamber
Re: ActiveX task working with Excel, Allan Mitchell
Re: DTS Data Source, Allan Mitchell
- <Possible follow-ups>
- Re: DTS Data Source, Allan Mitchell
URGENT:--Link Server and DTS issue, Nik
Problem with numeric data in an alphanumeric column, Amy
- Re: Problem with numeric data in an alphanumeric column, Amy Bolden
Re: CSV file import, Darren Green
Strange error when using named-query, Max Berghammer
- Re: Strange error when using named-query, Allan Mitchell
Distributed Transaction spanning Oracle and Sql DB in a single package?, Jens Weiermann
Re: Importing a 'Date' field via DTS Package, David J. Cartwright
- Re: Importing a 'Date' field via DTS Package, Conan Kelly
  - Re: Importing a 'Date' field via DTS Package, Thomas Bradshaw via SQLMonster.com
    - Re: Importing a 'Date' field via DTS Package, Conan Kelly
Turning off foreign key contraints, Charlie@CBFC
- Re: Turning off foreign key contraints, Allan Mitchell
Re: Table/View/Synonym not found (7519), Allan Mitchell
Frozen Lineage Problem, miguel.salles
- Re: Frozen Lineage Problem, Allan Mitchell
Re: DTS Package not running, Andy
- Re: DTS Package not running, Allan Mitchell
- <Possible follow-ups>
- Re: DTS Package not running, Thomas Bradshaw via SQLMonster.com
SQL 2005 .NET Stored Procedure - Returning more than 8000 chars, Per Schjetne
Re: Package executes as expected inside designer, but not from DTSRunU, Darren Green
Re: How to execute a group of tasks in parallel, Darren Green
Keeping Our Cupboard Cool, Ryan Bounds
- Re: Keeping Our Cupboard Cool, Darren Green
DTS question, Cupid Shan
- Re: DTS question, Darren Green
  - Re: DTS question, Cupid Shan
    - Re: DTS question, Cupid Shan
Re: How to execute a DTS script, Allan Mitchell
- Message not available
  - Message not available
    - Re: How to execute a DTS script, bnhcomputing
    - Re: How to execute a DTS script, Allan Mitchell
    - Re: How to execute a DTS script, bnhcomputing
    - Re: How to execute a DTS script, Allan Mitchell
Re: SQLServer -> EXCEL DTS. Destination Table problem, sreejith . ram
- Re: SQLServer -> EXCEL DTS. Destination Table problem, sreejith . ram
Text File Import - Need to Update if Exists?, scott
- Re: Text File Import - Need to Update if Exists?, Allan Mitchell
- <Possible follow-ups>
- Re: Text File Import - Need to Update if Exists?, scott
  - Re: Text File Import - Need to Update if Exists?, Allan Mitchell
using dynamic properties task in dts !!, atulpandey
- Message not available
  - Re: using dynamic properties task in dts !!, atulpandey
    - Re: using dynamic properties task in dts !!, Allan Mitchell
    - Re: using dynamic properties task in dts !!, atulpandey
    - Re: using dynamic properties task in dts !!, Allan Mitchell
Re: Scheduled Import, Allan Mitchell
Data Driven Query Task problem, Yener
- Re: Data Driven Query Task problem, Yener
  - Message not available
    - Re: Data Driven Query Task problem, Yener
    - Re: Data Driven Query Task problem, Allan Mitchell
Re: DTS Takes forever to save, Scott M
- <Possible follow-ups>
- Re: DTS Takes forever to save, Scott M
DTS as job hang on execute since SQL Server 2005 September CTP, jberkson
How to run a DTS package, KLV via SQLMonster.com
- Re: How to run a DTS package, knight.randy@xxxxxxxxx
Re: Is there a way to do a DTS load on type TEXT fields?, Allan Mitchell
RE: Export to text/CSV Append Data, Allan Mitchell
Uploading Files via DTS, Dazza
- Message not available
  - Re: Uploading Files via DTS, Dazza
    - Message not available
    - Re: Uploading Files via DTS, Dazza
    - Re: Uploading Files via DTS, SQL
Re: Plans for DTS Support in SQL 2000 64-bit, Darren Green
Main = DTSTaskExecResult_Failure does not raise an error, SJM
- Re: Main = DTSTaskExecResult_Failure does not raise an error, Allan Mitchell
  - Re: Main = DTSTaskExecResult_Failure does not raise an error, SJM
    - Re: Main = DTSTaskExecResult_Failure does not raise an error, SJM
    - Re: Main = DTSTaskExecResult_Failure does not raise an error, Allan Mitchell
    - Re: Main = DTSTaskExecResult_Failure does not raise an error, SJM
- <Possible follow-ups>
- Re: Main = DTSTaskExecResult_Failure does not raise an error, SJM
  - Re: Main = DTSTaskExecResult_Failure does not raise an error, Allan Mitchell
    - Re: Main = DTSTaskExecResult_Failure does not raise an error, SJM
- Re: Main = DTSTaskExecResult_Failure does not raise an error, SJM
  - Re: Main = DTSTaskExecResult_Failure does not raise an error, Allan Mitchell