Rating Thread / Thread Starter	Last Post	Replies	Views
Stripping off header information Hi, I'm fairly new to DTS and I'm trying to import some flat text files into a sql server staging table, but the text file has up to 195 lines of... adam	04-21-2005 03:49 AM adam	3	66
DTS Export SQLto Access I am trying to export records from a table in SQL to MS Access for specific field (AccountID) in my table. I need to dynamically pass the value to... dhigdon	04-21-2005 03:35 AM Darren Green	1	88
Parameterized query fails syntax check when comments exist I am wanting to pass a global varible into a simple insert..select statement contained in an execute SQL task. The existing code has comments in... Jeffrey K. Ericson	04-20-2005 10:31 AM Francesco Anti	1	68
Help Using Regular Expressions in a column Transformation I'm still in learning mode with regular expressions and am attempting a few things during a Trasformation task from one table to another. Basically... getanothername	04-20-2005 08:53 AM Darren Green	3	78
Please help! "Error at Destination for Row number..." I've tried using DTS to copy my database tables from one database to another: by clicking on "All Tasks", then "Export Data". For most tables, they... Lena Tay	04-20-2005 05:27 AM Lena Tay	2	263
How do I encrypt a dtsrun parameter? I'm maintaining a database that uses a scheduled job to execute a DTS package (using the "dtsrun" shell command). The parameter being passed... Jason Barnett	04-20-2005 04:15 AM Darren Green	4	114
Execute a package? file = .bas A client sent me a dts file. He saved as a .bas file and emailed to me. How may I execute it now on my sql server? I don't have VB. Should he... Robert A. DiFrancesco	04-20-2005 12:36 AM Allan Mitchell	1	70
trim string transformation I take it there is no way to have the import wizard default to a transformation other than copy. Nor any way to replace the copy... M D	04-20-2005 12:35 AM Allan Mitchell	5	124
HOW TO or CASES IN vb script I'd like to OR three cases all together how do you say that in VB script.The following dosen't work select case var case "A","B","C" case "D" End... RezaA	04-19-2005 05:50 PM M D	1	50
Web service credentials from DTS object. I created a custom DTS object that does its work by calling a webservice. When you create the object in DTS, it lets you set the user/pw you want to... Backslider	04-19-2005 04:10 PM Syed	1	52
Transform data task dropping records I am trying to import a fixed length field text file using the transform data task. When I run the step not all of the records get imported. I get no... Galen Peck	04-19-2005 03:59 PM Allan Mitchell	1	62
DTS - Export from SQL to Excel I'm trying to export data thru diff stored procs to Excel files, dependent on contents of a table. That is the table holds the name of the stored... big__smile	04-19-2005 02:41 PM Allan Mitchell	6	117
VBScript Runtime Error: Object Required I am very new to DTS and ActiveX scripts. I had a package that was running without incident until recently. I honestly don't know if Network... Crazy about SQL Server	04-19-2005 02:38 PM Allan Mitchell	1	134
DTS noob questions Where can I find some good docs/examples of using a dts package to export data to an excel file, then move the data to another table with a completed... JasonMeyer	04-19-2005 02:36 PM Allan Mitchell	1	78
Wrong pathname in logfile of scheduled DTS package Hi all! I have a scheduled DTS package that transfers data from a table to a flat file every night. The package and job works just fine but I have... Jaana	04-19-2005 02:33 PM Allan Mitchell	1	72
scheduling package Hi all gurus If I create a package and schedule it for jobs and then if i delete the package and create a new package with same name. Then my job... AM	04-19-2005 01:54 PM AM	2	83
dtsrun Parameter Problems! Hi there I seem to be having problems with my dtsrun script which I am running from a scheduled job. The others work fine, but this one has a few... bungle@wizardbuy.com	04-19-2005 11:00 AM Jacco Schalkwijk	1	81
Please help in design of simple DTS I am in need of help for designing a very simple DTS package. I am just not able to get the design working the way I want it to... 1. Connect to an... jamesfreddyc	04-19-2005 09:30 AM jamesfreddyc	1	49
limit using select statement in dts package? Hello I created a simple dts package that ports data from one view to a txt file (sounds simple:) ) I created two datasources, one for the sql... news.microsoft.com	04-19-2005 04:34 AM GauiC	4	89
cannot run DTS with Process Cube function inside using C# I use C# to invoke DTS. The DTS run successfully if no process cube function in it. But after i add process cube function, the ASP.NET page hang. I...	04-19-2005 02:57 AM	0	83
Load a data to Fact Table hi i used SQL connection where i have data in Dimension Table but i want load the common fields in Fact table from all Dimension tables now problem... amit mota via SQLMonster.com	04-19-2005 02:42 AM amit mota via SQLMonster.com	0	55
Refresh copy of a table using DDQ? I want to refresh a destination or copy of a source table from a different sql server database. I want to: -update destination if there is a match... Dave	04-19-2005 12:43 AM Allan Mitchell	5	76
Filtering rows with a Multi Phase data pump Hello All, I get text files that have sensitive data like credit card numbers. We only bring te last 4 digits. I need to filter some rows that are... LP	04-18-2005 09:02 PM LP	0	61
Deleting Excel Table Hi Darren, I found this in one of your posts in 2000. CREATE TABLE `TestTableOne` ( `Col1` Long , `Col2` Long ) Is there a way to delete the table... big__smile	04-18-2005 08:02 PM big__smile	0	54
ftp says "invalid string format for filenames" Using the ftp task all by itself, in dev mode it seems to succesfully connect to the site and list filenames and sizes, and let me specify which one... JRStern	04-18-2005 06:19 PM JRStern	0	53
Renaming worksheets in Excel before doing DTS Anybody could help me ? I have 286 tables which contains only 1 worksheet - but the name is 30 char long and contains some spaces. I need to change... Senjaya	04-18-2005 04:30 PM Senjaya	0	57
Problems with importing Excel files into SQL Server First off, I have been to this webpage, and this does not help. http://www.sqldts.com/default.aspx?254 I have had problems for years now importing... bagman3rd	04-18-2005 02:49 PM bagman3rd	2	81
xpsql.cpp: Error 87 from GetProxyAccount on line 604 Hi, I am a web developer trying to execute a storec proc. The stored proc is : DECLARE @cmd nvarchar(500) SET @cmd = 'bcp DBNAME.dbo.TABLENAME... S	04-18-2005 02:43 PM S	0	108
Setting Primary Keys on tables Hi: I am pumping data from a Sybase database into SQL Server that will be run daily. I am trying to set a composite Primary Key on the destination... kayda	04-18-2005 02:28 PM Allan Mitchell	1	67
Set destination column to NULL if incorrect data type? Is there a way to set the destination column to NULL if there is a data type mismatch, like trying to insert a string into a numeric type column? ... Stefan Wrobel	04-18-2005 02:11 PM Stefan Wrobel	4	76
DTS Scheduled Package Fails but runs manually I have a tab deliminted task that imports data into a SQL Table that runs succesfully if executed. But when I shedule this task if fails. The... Lontae Jones	04-18-2005 01:59 PM Allan Mitchell	5	92
Error handling and sending email upon failure Hi: I want to write to a database when a task in my package fails. I would like the database record to look like: Status FailTime ... kayda	04-18-2005 01:40 PM Allan Mitchell	1	72
using ordinls instead of field names in datapump Hi All, I'm trying to pump a CSV file with 33 columns into a table.I read that using ordinals instead of field names helps boost the performance.I... RayAll	04-18-2005 11:52 AM RayAll	2	61
Execute Package Task continues after failure I have several packages that are called from one "loader" package. The loader package makes use of the "Execute Package Task" and joins all... LP	04-18-2005 10:58 AM LP	2	73
Exporting using UTF-8. We have a requirement where-in data has to be exported (using a DTS Package) into a text file from SQLServer 2000 in the UTF-8 format. DTS: For a... SQLCatz	04-18-2005 10:37 AM SQLCatz	0	76
DTS Workflow precedence I am having diffculty defining a workflow for my package. Normally this would be a simple execution of tasks, however should task 2 fail then... Filby	04-18-2005 10:26 AM Darren Green	2	75
Re: Sending Mail using xp_sendmail "Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote in message news:e30oqx%23QFHA.3140 (AT) tk2msftngp13 (DOT)... Paolo Fiore	04-18-2005 10:24 AM Darren Green	1	55
BCP I/O Error Hi, When i run the following command i get the following error , c:\bcp TSQL.dbo.abc in c:\val.dat -fc:\val.fmt -SServer -Usa -Psa SQLState =... Govardhan MV	04-18-2005 07:58 AM Govardhan MV	2	96
Changing properties dynamically with ActiveX Hello, I don't get it! I try to change properties dynamically by using the DynamicPropertiesTaskAssignment Object. I have no clue if this is the... Rene H	04-18-2005 04:51 AM Rene H	4	84
Execute Process Task - with Global Variables? Hi! I want to zip files by using Global Variables(holding folders). So I would like a function like - Execute Process Task now with... Olof	04-18-2005 02:57 AM Darren Green	2	69
Import XML file to SQL Server 2000 Hello, I received an XML export of a database from a program called Reference Manager. It is a single table. I need to import it to SQL Server... Veep	04-18-2005 02:37 AM Darren Green	1	69
BCP: how to perform partial copy? Hi there, I want to import data file into SQL Server using the BCP command. Some of the data records already exist in the database. How can I make... Li Jonathan	04-18-2005 02:29 AM Darren Green	5	58
Importing database Hello there I have database that i need to import data from one of the to the other. I have in one of my tables 15000 records and one of them... Roy Goldhammer	04-18-2005 02:24 AM Darren Green	3	69
Change dynamic properties with ActiveX Hello, Instead of defining a dynamic property task in each DTS I rather would have an ActiveX Script task changing the properties of a package. 1. Is... Rene H	04-15-2005 07:20 PM Rene H	2	45
Export to CSV file Hi, I have one table and i m trying to export it to .CSV file. i do have NULL values in one of column of table so when i do export to csv file, it... mvp	04-15-2005 03:48 PM mvp	0	67
Font Size in ActiveX Script Task Cany any one help me please. I cant read the default font in the Active Script Task properties box. I know how to change it, but ever time I... turbogator	04-15-2005 02:38 PM Stefan Wrobel	1	69
Re: 64 Bit : Sql 2005 and DTS I believe it will be dependent on edition http://www.microsoft.com/sql/2005/productinfo/sql2005features.asp -- Allan Mitchell MCSE,MCDBA,... Allan Mitchell	04-15-2005 12:49 PM Bob H.	1	69
I need help with SELECT statement Hi, Could you help me modify the SELECT statement below that would accomplish my final goal. SELECT col1, col2 FROM table1 WHERE col3 < @V In col1... Vanessa Lee	04-15-2005 10:51 AM Yunus's Group	2	63
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	79

Page 134 of 258

134

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