Is there a way to pass a users input through a DTS parameter that has a integer data type without puting a constant in the value column. Ex A string parameter accepts a ? for an input. However a @id (Integer(small) will only take a number in the value rather than accept a placeholder for user in...more >>

Hi there Please forgive the very basic question. I have two SQL Server 2000 databases. The source database contains data I need to port, and the destination database is a mere shell of tables ready to accept the data. Once it's all in my new ASP.NET should be up and ready to run with live ...more >>

Hello, I have a need for a web application to request a stored procedure to be run and then the results emailed to the user in Excel. My web applicaiton is in ASP.C#.NET. But I want to use parameters to supply the stored procedure name excel file name email address Should I use the DTS d...more >>

Hi: I have setup DSNs before to text files with some success. I am having problems with a file I have to parse to pump into SQL Server via DTS. It appears to be fixed length (what does the 'length' refer to normally-the text plus the spaces to get to the first character in the next column?). ...more >>

SQL Server 2000 DTS Questions 1. In a DTS package, I am using an ODBC connection as a destination for a transformation task. The destination table name uses the format [databasename].[owner].[table name] When I have modified the databasename within m...more >>

i can't find out where does the sql server save my DTS packages. i have seen that there is something in the msdb DATABASE about DTS but i couldn't find my DTS package over there. any ideas? Regards, OreN101...more >>

I have a .csv output from a database which does not use text qualifier. any commas or backslashes in the data are 'escaped' I.e. Field1 Field2 Field3 123 a,b\cd grey would come out like: 123,a\,b\\cd,grey I want to DTS this .csv file into SQL Server, but i n...more >>

Hi, Can anyone tell me why there are no icons for me to use in the Tasks toolbox, even when I open a package that has constraints and a data transform task in it. I also keep getting a DTS Designer Error saying 'The extended attributes are inconsistent', even when I try to create a new packag...more >>

How can I recover a DTS without recover a old msdb database over current msdb ? ...more >>

I have a query, which selects three columns from an inner join. The last two columns are SUM and the first one is GROUP BY. Now, I would like to add another column that will be the multiplication of the second and third columns. I have tried many ways but I am not very sure if what I have co...more >>

Run package to execute the 'CopyProcedures' proc as follows: exec master.dbo.xp_cmdshell 'dtsrun /S (local) /E /N CopyProcedures ' , OUTPUT CopyProcedures contains a Copy SQL Server Objects Task that: Copies several stored procs from (local) to a destination server The CopyProcedures e...more >>

Can you guide me how to set up alert for MSDTC service, My goal is to get notification when MSDTC is failed. thanks kalyan...more >>

Hi, The following error message is received during the transformation of data from a text file (262 columns) into SQL database. "Not enough storage is available to complete this operation" Is there any specific reasons? Thanks *** Sent via Developersdex http://www.developersdex.com...more >>

Hey eb My dts step log is growing to much. I want to add a step to this dts which will shrink it by deleting records from table msdb.sysdtssteplog (keeping records that are no more than 1 week old). Is this possible?? Are there any other ways to keep this log economical while it is being used...more >>

Hi I created some FTP dts on a client machine using enterprise manager and the FTP task and they worked fine when I created them . Later I discovered when I opened them on a client machine in Enterprise Manager it brought up an unspecified error and the package won't open or run. They can st...more >>

I'm trying to print a job to a specific network printer. I'm using an ActiveX Script Task to execute to execute the print job. However, when I compile the code, I get an error on the Dim statement "as printer". However, when I go to my VB reference book, it notes that "as printer" is a vali...more >>

I need to insert data returned from an ActiveX vb script into a table. Can I do this w/o writing the data into a text file (inside the vbs), then importing the text file into a table? Right now I out it in a file, then load the file into the table. I'd like to go straight from the vbs scrip...more >>

I had the following request given to me by my boss and am coming up empty on finding an application or script that will do this for us any help would be very appreciated: "I would like you to research if extracting the documentation from a DTS package is possible. Basically looking for someth...more >>

First off, I'm an ASP.Net developer and not a SQL DB admin. One of my clients uses a program that uses a SQL Server database. They want to run intensive intra-day reports against a replicated database on a different server as to not affect their mission critical operations. I was going to set ...more >>

Using DTS, I imported a bunch of tables from Access to SQL. All the tables have been transferred except but two that are giving me similar error messages: "Error Destination for Row number 58. Errors encountered so far in this task:1. Insert Error, column 10 ('Block From Date', DBTYPE_DBTIMES...more >>

I am running this activex script on a server which searchers for a file b.txt and renames it as ba.txt on the c drive of a server.I get the error vb script error error code 0 when executing the movefile step oFSO.MoveFile sSourceFile , sDestinationFile. Both these files exists on the server....more >>

Hello, my sql instance stopped working! I was able to save all the mdf and ldf files, but have no idea where the dts are. Please any help will do!!!...more >>

I created a DTS package & CAN run it (successfully) from Enterprise Manager and from a command prompt. When I try to schedule a job for this DTS package under SQL Server Agent Jobs it gets the following error: ATTRIBUTE_TYPES to [ThankYouAcknowledgements].[dbo].[ATTRIBUTE_TYPES] Step D...more >>

I have a table in Excel with about 4000 records which I need exported to an Excel Spreadsheet. This has to be triggered via an ASP.NET app via the web. I have been trying to use DTS but some wierd things happen. 1) All the numeric columns in the table are recorded as strings in Excel. Thus ...more >>

hi, i have a serious problem that when i use DTS to move my data into vfp9, my tables were in vfp tables, but all records were missing! who can help me? ...more >>

Is it faster to move data between 2 tables using DTS or more of an insert <newtable> select * from <table> I would like to use DTS but it appears very slow. Is there any setting to make it faster ? Using the generic wizard to export data ...more >>

Hi. I have a dts package that loads data from a fixed length text file into a table. I would like to insert the filename into a column in the table so that I can track the records inserted from which source file. I have the script to get the filename, but I don't know how to pass this inform...more >>

The tables I need for the diagram have all been transferred using dts, Now I need a copy of the diagram using these tables in the new db, There are qwuite a few annotations in it that I don't want to have to ewrite. Thanks for any help. RD ...more >>

How should I debug my DTS packages in the production server where there is no script debugger. Thanks ...more >>

I am trying to print a document to a specific network printer in DTS using an ActiveX VB script. I found the code below in another group, however, I'm getting a compile error when I try executing it, and I'm unsure why. (Expected End of Statement on Line 14) JoeO:"You use printer collecti...more >>

I am calling a WINZIP process to extract a zipped file using the code below : Set oShell = CreateObject("WScript.Shell") strCommand = "WZUNZIP.EXE" & " -e -o- " & DTSGlobalVariables("gLocalImportFolder").Value & "\" & file & " " & strTempUnZipFolder oShell.Run strCommand The problem ...more >>

Is there a way to run a DTS package to import Access data when the MDB has an associated MDW file? I have a valid username and password, but I can't open the MDB within DTS . I can open the MDB, export the data to an unprotected MDB, then import the data from that, but I'd rather use the root f...more >>

Is there a way to do that? TIA! Stanko. www.milosev.co.yu ...more >>

Hi, I have a problem that I don't understand. I am trying to do a simple thing: Dim filesys Set filesys = CreateObject("Scripting.FileSystemObject") filesys.DeleteFile("v:\skarimTest.xls") from an activex inside a dts. The v:\ drive is mapped via "net use" to a directory on a different s...more >>

I have a little problem with a small C# Applikation that executes DTS. I don't know if this is the right Newsgroup. First of all here is what the Applikation should do. A FileWatcherObject is monitoring a Directory for new CSV files. If there are new Files, the files will be added to an hash-...more >>

Hi is there a way to dynamically set the name of the file to pick up using the ftp control, say from a global variable? thanks jc -- =============== Jonathan Crawford 01273 440018 07799 068570 fax 01273 380221 jc@tgsi.net =============== ...more >>

I m rtying to save a packahe from a COM structured file into sql server database *using a trusted connection" using the follwoing code: EXEC @rc = sp_OAMethod @objPackage, 'SaveToSQLServerAs' , null,@ServerName = @@ServerName, @Flags = 256, @PackageName = @PackageName but it returns : ...more >>

Hello, I have a DTS package to replicate data from one site to another. The first step in the DTS is to delete data in the Destination, then it inserts the source data into the destination. Sometimes, the first step ran OK but the second step failed, I was ended up with empty tables in the ...more >>

Hi I have a table which has about 60 fields(columns). When I create a DTS, in the destination tab after pressing Execute button, nothing happens. If I select only 25 fields It works and If I select them all its not working as I said earlier notthing happends after pressing executer butto...more >>

I have a report which I have to complete every quarter. The report is done in Excel and is called, "Agency Training Metrics Report". There are 20 categories which our training courses fall in. The report is broken into 2 sides, Supervisor and Non-Supervisor and lists all the categories in r...more >>

i want to use the dynamic task properties in a dts task. I want to use a datafile. i would like to know what the end of line delimiter is. thanks ...more >>

i wnat to use the dynamic properties task to fill in a value for the ftp task. i set it up to use an ini. when i execute the dts task i keep getting the error "invalid string for source file names". my ini looks like the following: [test1] myval=dba.zip Can anyone tell me if i am missin...more >>

SQL Server 2000 DTS crashed before exporting; Its is happening only after installing Visual Studio 2005 Beta 2. Any clue ? After reinstalling it started working back...more >>

I have the following error message "tep_DTSExecuteSQLTask_2 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_2 DTSRun OnError: DTSStep_DTSDataPumpTask_2,...more >>

I just got a new gig and they are yelling that one job isn't running. I see that I'm suposed to pass data to a SERVER that nobody here knows about? It's listed as our #1 client by name. They, being a bank, wouldn't open themselfs up for me to pass data, now would they? So if I can extract ou...more >>

Hello! Is there any way to pause execution (Sleep) in java script under DTS? WScript.Sleep() doesn't work. As I understand sure workaround is to build my own activex with one method Sleep(), but may be there is some simpler method. Any ideas? Thank you, Yaroslav ...more >>

I am trying to run a 3 step DTS package from VB .NET. It exports a SQL 2000 table to a dBase IV file. Step 1: Drop table: succeeds Step 2: Create table: succeeds Step 3: Transform Data Task SELECTS all columns from the SQL 2000 table & INSERTS it into the dBASE IV table. Fails with Erro...more >>

Dear gurus, I'm using sp_helpuser for obtain info about NT user. That's fine but i find a problem when I use with a group The name supplied (CM\52767641) is not a user, role, or aliased login. Does anyone know which would be the sp focused to groups?? Regards, ...more >>

Dear fellows, I've got a DTS which create two plain files on a specified network path using FSO object through a ActiveX task. AS usual that DTS is scheduled daily and working properly but this morning failed. I was wondering why, due to nothing has been changed. Just a little bit of t...more >>