Rating Thread / Thread Starter	Last Post	Replies	Views
LoadfromSQLServer hangs at OLAP task Hi, I try to load in a ActiveX script a DTS Package containing Analysis Services Task. But the "LoadFromSQLServer" command hangs before retrieving... hvstein	04-15-2005 10:31 AM fsanchez	2	75
Problem with data load from Excel to SQL Server I am experiencing problems with data load from some of the excel files. We get the excel files from a particular vendor everyday and some times the... Yunus's Group	04-15-2005 08:37 AM Ilya Margolin	3	80
Exporting to excel file from sql dts How can I create an excel file dynamically and export data to a specific sheet from sql server dts?. Karunakaran Karunakaran	04-15-2005 07:57 AM Darren Green	2	71
Field trunceted while exporting Hi All, While exporting via DTS one of the fields gets truncated. It is an nvarchar(1000) type, but after 256 characters the rest disappears when... Kolos	04-15-2005 07:33 AM Darren Green	1	64
Re: Monitor individual tasks within a DTS package You will need to use a separate mail task or "error handling task" per worker task. Use an On Failure constraint to link the two.... Darren Green	04-15-2005 07:32 AM Darren Green	2	60
Explain Error Message I am trying to use DTS to copy tables, using copy objects, from one DB to another and after about 10 min of processing I get an error: "...EXECUTE... Wayne Wengert	04-15-2005 06:09 AM Wayne Wengert	3	48
Active x Script Hello, How Could i send mail using vb script in Active x Script Task??? Mariame	04-14-2005 03:48 PM Dave	2	67
Re: Call VB.NET app from DTS? If the VB.NET app is compiled into an *.exe then you can use a Process Execution Task in the DTS package to run the VB.NET application. You can even... Yunus's Group	04-14-2005 03:23 PM dj	2	76
Creating a diff table from new and old tables Hi all. I am new to DTS and I would like some advice on how I should proceed with my project. Basically, I have a text file that is tab delimited,... Jiho Han	04-14-2005 01:13 PM Jiho Han	0	61
Table I have an interesting scenario. I have to exact table structures for 2 identical systems that function the same way. There are 3 tables that are... James	04-14-2005 12:29 PM shumaker@cs.fsu.edu	1	72
problem with Execute SQL Task I'm trying to use the Execute SQL Task to call up a batch store procedure that takes typically 1 hour to run. This batch procedure involves... Nestor	04-14-2005 03:29 AM Nestor	5	71
DTS does not exlude non-selected tables I'm trying to use DTS to build test databases. I'm attempting to copy my production data with the exception of one very large transaction... JP	04-14-2005 12:36 AM Allan Mitchell	1	60
Re: schema_name What version of SQL Server to what version? Try reregistering SQLDMO.dll Allan "new MSDN user" <newMSDNuser (AT) discussions (DOT) microsoft.com>... Allan Mitchell	04-14-2005 12:28 AM Allan Mitchell	0	61
DTS structure Hi All I'm aware that you can do something with the naming conventions so it's easier to spot which packages concerns the same topic but do you save... Michael Vardinghus	04-13-2005 03:38 PM Allan Mitchell	3	76
Global Variable Use in Process Execution Task The only info I can find on syntax for using global vars is in activex script or in an sql query. I have already added a global variable and set a... shumaker@cs.fsu.edu	04-13-2005 02:52 PM Allan Mitchell	1	81
xp_cmdshell I was able to run DTS using xp_cmdshell. In my dts I have 3 global variables which I would like to pass. Can I pass a variable values using... anonymous	04-13-2005 01:57 PM Allan Mitchell	3	88
sql task Hi, I was wondering if it is nessesary to use the statements 'begin transaction' and 'commit transaction' in a sql task within a dts. I have a task... Jason	04-13-2005 01:24 PM Allan Mitchell	1	53
Collation help Hi Anyone than knows how to change the collation name for a database. Or can you only do that when you create a new one?? /Anett Anett	04-13-2005 01:20 PM Allan Mitchell	1	52
Difference between data Driven task and Datapump I'm using a datapump task to transfer records from a CSV file to a table,I am doing validation while tranforming and when it's done ,I use an... RayAll	04-13-2005 01:18 PM Allan Mitchell	7	71
Execute a DTS from Excel We created a DTS package that imports data from an Excel file to a Temporary table and then does an Update to the primary databse table. The DTS... Jazz	04-13-2005 01:17 PM Allan Mitchell	1	96
DTS Multiple Columns Having problems with multiple columns in ActiveX script. I've tried everything I've found on Microsoft website, numerous newsgroups and websites. I'm... Stuart	04-13-2005 08:26 AM Darren Green	1	83
Execute send mail task in the Active x Script Hi everyone I have a package that contains 2 Task (Active x script & send mail task) In The active x script task there is a loop in it for a... Mariame	04-13-2005 08:20 AM Darren Green	1	83
DTS problem with floats Hi I have some DTS-package that import textfiles. When I run then manually everything works fine, but when i schedule them the fields containing... Anett	04-13-2005 03:34 AM Anett	0	51
Setup For a DTS I have many DTS stored in a Structured Storage File. I'm looking for a tool or procedure that can store my DTS in SQL-SERVER like a BATCH. Thanks Luca	04-13-2005 03:11 AM Luca	0	62
Error 80040E37 when Exporting Tables To Oracle Hello to Everybody, I've been using the Export/Import DTS wizard to export some tables (40) from my database to an Oracle instance. The process is... David Grant	04-13-2005 02:22 AM David Grant	0	64
Using Global Variables in SQL Task Hello: I'm trying to use a parameter in an SQL Task. The task's data connection is just to the local SQL Server. It should be simple enough: DELETE... tabladude@gmail.com	04-13-2005 12:39 AM Allan Mitchell	1	103
Export to Excel: Text fields When I export to Excel the Text fields are getting a ' character in front of the text Excel recognizes the the cell as text with or without... gmancuso	04-12-2005 06:09 PM gmancuso	0	68
Substring gets ADO error My DTS package has an SQL statement to select data from an Access database table. Adding the substring to the SLQ causes "ADO error: ." to... TACIR	04-12-2005 02:50 PM Allan Mitchell	1	64
Existing connections are more than actual connections in dts package. I accidentally renamed my connection (Text source) and now I have two connections in the list of existing connection (when I add a dynamic property,I... RayAll	04-12-2005 02:35 PM RayAll	5	64
DTS Dependencies Hello Is there a method of determining which objects (particularly tables) are including in DTS packages? We have a requirement to rename a table... Steve	04-12-2005 01:25 PM Allan Mitchell	1	75
Reformatting the date in DTS Hello My DTS transformation is fighting with me. I am exporting a smalldatetime field from a SQL Server table to a text file. The requirements of... Steve	04-12-2005 01:22 PM Allan Mitchell	1	57
DTS Package Load schedule issue We have a DTS package that loads 46 text files from an FTP server into the database on a database server at 6:00 AM. every morning. The files are... Tom	04-12-2005 12:46 PM Simon Worth	4	56
DTS bulk insert We're needing to load some tables with up to tens of millions of rows. This will usually be monthly but occasionally will be needed on demand. We'd... MarkA	04-12-2005 12:42 PM MarkA	0	59
FTP Log File I get an error when I try to pipe to log file using the Execute Process Task. When I set the Parameters like this it runs fine: -i... Chris White	04-12-2005 10:54 AM Chris White	0	60
DTSPackageLog Import into SQL I work for a company that does not allow access to msdb tables. I log to file and would like to know if anyone has create a script to import and... Peter	04-12-2005 09:11 AM Peter	0	64
DSO script to archive and restore a analysis Services database Can somebody please help me with the DSO script that enables me to backup or restore a specific AS2000 database. Thanks Karen Karen Middleton	04-12-2005 06:01 AM Darren Green	1	50
Transfer of Unicode Data From SQL Server to Oracle Can Unicode data stored in NVarchar or NChar data types in SQL Server be exported to Oracle using DTS ? Is there a workaround for this? TIL MSCOE	04-12-2005 04:54 AM TIL MSCOE	0	56
Error Handling --- Hi I have 2 Activex Script (one assigns variables from recordset and other is loop ) In the first one i have the following code Function... Guru	04-12-2005 12:34 AM Guru	1	71
importing files using dts Hi I am using looping,importing and archieving example for importing multiple files into sql server database. here is my code create table -----> ... chinna jambu via SQLMonster.com	04-12-2005 12:26 AM Allan Mitchell	5	85
sql server agent job step that runs a dts package fails - urgent Hi I have a stored procedure which runs for one and a half hours when executed from sql server agent job. The same stored procedure runs for 10... Uma	04-12-2005 12:25 AM Allan Mitchell	6	168
Generating a personalised report for every vendor and mailing out the same I have the following reporting scenario. I have a table which contains a list of customers/vendors and each record in this table as the... Karen Middleton	04-12-2005 12:22 AM Allan Mitchell	2	65
DTS packages or stored procedures? If the source database is a SQL Server database and the destination database is a SQL Server database, do you need to use DTS? Is it possible to use... imani_technology_spam@yahoo.com	04-11-2005 02:47 PM Allan Mitchell	3	73
Package Status when using Execute Package Task I'd like to end a called package (by Execute Package Task) with a KO status so to have the chance to set the workflow properties "on failure" onto... Paolo Fiore	04-11-2005 02:31 PM Paolo Fiore	0	64
Date validation script I'm trying to convert date text to date time. I can use dateserial sucessfully as shown below, however it is not uncommon to receive bad dates in... Gary	04-11-2005 02:19 PM Allan Mitchell	3	69
Executing DTS package on Win XP/2003 I had a question on executing DTS packages on Win XP/2003. We developed a DTS package in VB 6 to copy data from an MS Access (97/2000) database to a... male hit	04-11-2005 01:17 PM Allan Mitchell	1	63
A DTS step freezes (status is just "Executing Job Step 'job name'") Hi I have an issue with some SQL Jobs: Mostly they quit with success after 30 sec, but sometimes they just freeze. For hours (and days) the Status... Joakim Olesen	04-11-2005 07:22 AM Ilya Margolin	3	107
Numeric Overflow of Column of datatype Money Hi, I'm trying to load a table from a dts job that selects all the records from sybase table and imports it into an equivalent MS SQL 2000 table. I... SQLCluster	04-11-2005 02:55 AM Mike Epprecht (SQL MVP)	1	57
Type Mismatch: DTSLookups? I have Transform Data Task that I want to Lookup some company values from another database based on a code from the source and insert them into... Dave	04-11-2005 12:45 AM Allan Mitchell	1	134
dts query and export to excel Hi, has anyone an eyample for vb wo to do an query and afterwards export this query to exel? reg bxandi xandi	04-10-2005 05:04 AM Allan Mitchell	1	99
DTSPackageLog.WriteStringToLog Hi, I am wondering the WriteStringToLog will write the log to the windows log or sql server log? THanks Ed Ed	04-10-2005 01:56 AM Allan Mitchell	2	169

Page 135 of 258

135

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	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