dbTalk Databases Forums  

Sponsored Links


microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss in the microsoft.public.sqlserver.dts forum.



Post New Thread
Threads in Forum : microsoft.public.sqlserver.dts Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
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...
Vinny Vinn
11-30-2004 02:52 PM
Allan Mitchell Go to last post
3 48
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...
DavidM
11-30-2004 01:34 PM
Allan Mitchell Go to last post
1 59
Hi, I am a new user to DTS. I have worked in VB 6.0 to connect to Oracle before. I'm now trying to get some stuff done using DTS. I've...
Madhusudhan
11-30-2004 01:10 PM
Madhusudhan Go to last post
3 72
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?
Paulo
11-30-2004 12:29 PM
Darren Green Go to last post
1 65
How to read number of lines in a flat file using a DTS package? I am using SQL 2K. Thanks, Ram
Ram Achar
11-30-2004 12:20 PM
Darren Green Go to last post
1 50
How to read a file time stamp of a flat file using a DTS package? I am using SQL 2K. Thanks, Ram
Ram Achar
11-30-2004 12:17 PM
Darren Green Go to last post
1 65
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...
Moe
11-29-2004 04:40 PM
Allan Mitchell Go to last post
1 74
I am trying to import data from MSAccess. when I choose the data source and enter the userID and Password I get the following...
Al
11-29-2004 03:50 PM
Rand Boyd [MSFT] Go to last post
2 67
Hi. Some facts first: Win2003 64-bit and SQL2000 64 bit on 3 Cluster nodes Q: I have to do Deligation of DTS Pakages to the Developers without giving...
Baldini
11-29-2004 03:47 PM
Rand Boyd [MSFT] Go to last post
2 68
I have a problem importing data with SQL. I want to transfer data from one SQL server to another. Apparently I only managed to transfer data when the...
powerpoint@powerpoint.com.mt
11-29-2004 02:04 PM
Allan Mitchell Go to last post
9 69
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...
Nathan Truhan
11-29-2004 12:10 PM
Nathan Truhan Go to last post
2 80
I have a stored procedure written for number of updates, inserts to the database. This stored procedure takes too long to run. I have created...
raj
11-29-2004 12:50 AM
Allan Mitchell Go to last post
1 77
Hi, I am using Windows 2003 Server. The VPN works fine, but I want to FTP through the VPN so the connection is encrypted. The problem is each of...
Jason Robertson
11-27-2004 10:23 AM
John Bell Go to last post
1 71
I tried to export data from SQL Server to a Excel file within ASP. I use DTSPackage object library V2.0. I know that it can connection to a Excel...
X. Zhang
11-26-2004 07:55 PM
K. Som Go to last post
2 80
Hi, How to upload data from an excel sheet into SQL database? We are using ASP.Net Webmatrix and C# as backend. Thanks in advance. *** Sent via...
sangeetha saravanan
11-26-2004 11:19 AM
X. Zhang Go to last post
4 70
Hi all, i'll try to explain my problem in the best way! I'd like to create a DTS package that make a spreadsheet file where each sheet represents an...
clickout c
11-26-2004 10:43 AM
Francesco Anti Go to last post
1 63
Does anybody know how I can delete existing connections within DTS
PPega
11-25-2004 10:43 AM
Darren Green Go to last post
1 70
Hi All, Can any tell me how can i plan only get the rows that have been updated only after the last DTS Process. Thanks, Mansoor
Muhammad Mansoor
11-24-2004 12:37 PM
Darren Green Go to last post
3 78
Hi , i need an help . I need to import data from database access to sql server database , and this is not a problem . The really problem is that the...
Import data from multiple acces db
11-24-2004 05:15 AM
Import data from multiple acces db Go to last post
4 71
.....is done best how ? Have heard of Toad...or perhaps linked server and then use query analyzer ? But this way I cannot get a list of tables on...
Michael Vardinghus
11-24-2004 01:05 AM
Allan Mitchell Go to last post
3 60
I have .dts file from another sql server. I would like to import and install this file as a DTS package on MSDE and schedule it to run...
inquisite
11-24-2004 12:50 AM
Allan Mitchell Go to last post
1 72
I am getting burned in every direction I take to get around this problem. I have a loop in a Stored Procedure that reads records from a table to...
Jamie Carper
11-23-2004 03:03 PM
Allan Mitchell Go to last post
2 79
I'm trying to import data into my table and I'm received an error message that I've been unable to resolve. The message is: Error Source: Microsoft...
Scott Natwick
11-23-2004 02:25 PM
Allan Mitchell Go to last post
4 116
Hello everybody, I want to execute a dts from an ASP page. The problem is that this ASP is not in the same server where the SQL Server is. Is...
Javi
11-23-2004 02:14 PM
SqlJunkies User Go to last post
4 60
I have a DTS job that is scheduled to run once a day at 5PM. The job invokes a couple of batch files which in turn execute a java application and...
Dermot Grady
11-23-2004 10:24 AM
Dermot Grady Go to last post
2 56
In my dts I have a logic in activex task where if file exists then sucess else is fail. I wanted to have an outcome of DTS as sucess, becuase the DTS...
anonymous22
11-23-2004 09:42 AM
anonymous Go to last post
2 67
I have a Text File (Source) Connection object. I need to dynamically control the Record Length to properly read some non-standard CSV files. When...
Jamie Carper
11-23-2004 09:29 AM
Jamie Carper Go to last post
2 81
?I have a dts package which is run once per day and will fail on 1in6 attempts at execution with the above error. It is running on a dual...
mrsifteruk
11-23-2004 08:00 AM
Darren Green Go to last post
1 81
I have a stored procedure as follows :- Create Procedure GetNewYear_mnth as Declare @OldYear int, @OldMonth int, @NewYear int,
Ajay Garg
11-23-2004 07:57 AM
Darren Green Go to last post
1 78
Hi, I have several dts packages which I want to set from "export all records" to incremental export. I need to export these records once an hour, so...
Johnny Orson
11-23-2004 07:49 AM
Darren Green Go to last post
1 65
Hi everyone i have a package that have two tasks if the first one failed , it goes to the second task when i execute the package, it run...
Mariame
11-23-2004 05:41 AM
Mariame Go to last post
1 71
i have an existing sql database with data and i'm trying to migrate the data to another empty sql database. our software's been updated and the new...
mark_s_nospam@ev1.net
11-22-2004 05:25 PM
mark_s_nospam@ev1.net Go to last post
7 63
I am attempting to copy a table from one SQL 2000 server to another. I am using the Copy Objects/Replace Existing options. The task runs for about...
Wayne Wengert
11-22-2004 12:35 PM
Sue Hoegemeier Go to last post
10 132
I am trying to import IIS logs using a DTS package. I have everything working, except I cannot figure out how to tell it to do al the logs in...
Art VanDelay
11-22-2004 12:22 PM
Sue Hoegemeier Go to last post
1 58
I have a table with 40,000 keys on SQL Server. In a SQL Task I can create a recordset from that table as an output parameter in a global variable. I...
SqlJunkies User
11-21-2004 04:00 AM
Allan Mitchell Go to last post
1 59
hi I have around abt 10 fixed width text files in a particular directory of the hard drive . I want to automate the task of importing all these...
aki_aki
11-21-2004 03:57 AM
Allan Mitchell Go to last post
1 67
Hi, I use DTS FTP Task to ftp files. When i log in to the FTP site, i get into the Inut directory. How can i specify that i want to change Working...
Jo
11-21-2004 01:09 AM
Fany Vargas [MSFT] Go to last post
1 74
...anyone have a solution to this. Have 100 excel files stored in a table in binary format and need to export them...have an asp application where I...
Michael Vardinghus
11-20-2004 12:37 PM
Michael Vardinghus Go to last post
3 76
I have a package (A) which executes another package (B). The executed package B contains a custom task. Package B executes correctly when run by...
Martin Davies
11-20-2004 10:21 AM
Darren Green Go to last post
1 61
I can not get the Connection Property to close when trying to create a connection using an ODBC data source. I click the 'OK' button and...
Wayne Blosat
11-20-2004 01:51 AM
Allan Mitchell Go to last post
2 63
I have the following code where I am executing the steps. My problem is how do I not execute the steps and set the DTSTaskExecResult as Success? If...
anonymous22
11-20-2004 01:45 AM
Allan Mitchell Go to last post
9 155
I am running a DTS project that calls 10 execute packages in a workflow to create flat ASCII files from tables. I know that in order to change the...
David Borgo
11-20-2004 01:40 AM
Allan Mitchell Go to last post
1 56
Hello there, I have a VB6 application that runs over a SQL Server 2000 Database. Sometimes (most recently) i get the folowing error: Run-time error...
Marco Pais
11-20-2004 01:34 AM
Allan Mitchell Go to last post
1 67
I have created a DTS package. Now I have schedule the package to run under the SQL Server scheduler. When I execute the package manually, it runs...
John Criswell
11-19-2004 01:22 PM
Jack Peacock Go to last post
2 65
What is the ASCII Equivalent to the SQL 2000 NULL? Chr(0) would have been my first guess but it does not import into SQL 2000 as <NULL>. Chr(20) is...
Jamie Carper
11-19-2004 01:19 PM
Jack Peacock Go to last post
3 61
The Excel file are like this: Jan Feb Mar Cost 1 2 3 Sales 3 5 6 .... The SQL tableA have colunms named cost,...
cowboy
11-19-2004 11:32 AM
Francesco Anti Go to last post
4 177
Hi I currently have a DTS package scheduled to import some data from an odbc datasource into sql. The problem is that the data needs to be more up...
IT Dep
11-19-2004 04:40 AM
IT Dep Go to last post
3 53
Is it possible to trigger a replication job from witin a DTS Package? I want to do the following execute SP1 on complation execute replication job...
Nico
11-18-2004 07:03 PM
Uma Go to last post
4 89
hi, I have flat file with atleast 500,000 rows with fixed fields. But, the rows were divided into 5 different types of rows. First 3 columns are...
Sreenath
11-18-2004 06:53 PM
Jack Peacock Go to last post
3 63
I had originally posted this in the OLE DB forum, but perhaps that was the wrong place so I'm post here as well. Does anyone know how to force an...
Scott
11-18-2004 04:03 PM
Toney Go to last post
14 140
Post New Thread

Display Options
Showing threads 5451 to 5500 of 9524
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.