I want to know how to execute an existing SQL Server DTS package from within Microsoft Access 2000. Let's say I have an Access form with one control on it, a command button, and I want to execute the package when the button is clicked. Let's call my SQL Server "SERVER1", my database within tha...more >>

I really need a solution a.s.a.p. so I am stating my case from the stand point of what it is I am trying to do and what I have done. Overview: When a person comes into our website there is a feature that allows them to generate a text file of information based on who they are. Initial act...more >>

Hi, I am copying about 100 tables from Base A to Base B and more exactly pat of tables from Base A to Base B example copy 50 first line from A.dbo.table1 to B.dbo.table1 I use a loop that launches utility dtsrun with global variables that take the source name and the destination name ...more >>

Hello, I want to write the results of a stored procedure to a text file in active x task in dts. I have the code to write the text file but what I need is an example of executing a stored procedure with a parameter and the results writing to a text file. The parameterin question comes from th...more >>

I have an "Execute SQL Task" that reads from a table like this: select top 1 company_id,filelocation, filename from Supplier_Download_File_Locations where statusid = 0 I have created output parameters for the 3 column names. I need to create a text file based on the company_id, filelocation an...more >>

I am using "Execute SQL Task" to execute the following statement: Select top 1 companyid from file_locations where statusid=0 I want to pass the companyid as a parameter to a global variable in the package. How do I do this? Please show an example. Thank you Gary ...more >>

I have just installed SP4 and now when I try to create a new DTS package that imports data from a text file I get the error "not enough storage is available to complete this operation". The packages that were created before the SP4 install still work fine it is just when I try to create new on...more >>

Is it possible to empty (not erase) a text file after I have read it in? Thanks in advance, Stijn Verrept....more >>

i need to create a DTS that operates as follows: Table A resides on server I, DB X, and receives the new rows and updates based on values found in Table B. Table B resides on server II, DB Y, and contains a key value used to extract valid records from Table C. Table C is found on server III, B...more >>

Hi, I need to execute DTS Package from VB.NET by passing global variable to DTS Package. I can execute and runs fine if there is no global variable but not with Global Variable. Let me know at mustaq.hussain@hp.com Regards, Mustaq ...more >>

I have a text file I want to import, it has a column containing a name of a room. Now I want to import it but I want the ID of that room to be inserted and not the name. So I create a transform data task for the textfile to the table and try to define a lookup. I do: select RO_ID from ro...more >>

I am trying to set-up a Linked Server in SQL 2000 to AS400 iSeries. I would appreciate if anybody out there has the relevant syntax to facilitate this. I have tried and keep getting OLE DB Provider errors. Thanks....more >>

I am wondering if there is an easy way to script data into script. i.e. I want to create a script file. For each record in each table, I'll have a sql script like INSERT INTO MyTable1 (Col1, Col2, Col3)VALUES(1, 'myVal11', 'myval12') INSERT INTO MyTable1 (Col1, Col2, Col3)VALUES(2, 'myVal21...more >>

Hi there, I built a new DTS using the Export Wizard and saved it. Now, in order to have the data base dynamic, my code (visual basic) goes like this: MyPack.LoadFromStorageFile Fname, passwrd MyPack.Connections.item(1).DataSource = sServer MyPack.Connections.item(1).Catalog = sDataBase ...more >>

I would like to know if it is possible to start a job from a stored procedure? I have a DTS that I set as a job and would like to either call it from an ADP with Conn.Execute "EXEC msdb..sp_start_job @job_name = 'Volusia'" OR just strat it with a stored procedure and call the stored proce...more >>

Hi everyone, Is it possible to create and schedule a DTS with it sending output to a printer? We have a system that stores all its results in MS SQL, and all I need is a way to select all the data from the table and send output to a networked printer. Is this possible without getting into s...more >>

Hello, I want to process/Import a text file using DTS and i want to send the file name at run time.. is it possible to do OR i have to use vbscript to create package at run time Thanks...more >>

Hi, I have noticed a couple of times that when i use DTS to export data from DatabaseA.TableA on Server 1 to DatabaseB.TableB on Server 2 the row count is different in DatabaseB.Table B compared to DatabaseA.TableA after successful export. Ideally the row count should be the same as there ...more >>

Hi there, I am new DTS developer so I hope my question will be clear. I need to transform a table but the exact DB should be a dynamic variable. That's why I thought to use a global variable. The problem is that when I try to change the SQL to - Select station_code from [?].Station I get ...more >>

Hello, Currently I save a DTS as a storage file. I then run the storage file with VBA code in the .adp(Access Data Project). This works if you run the ADP on the Server but the users of the .adp will be opening it on the network from their machines. When they do it says missing custtask.dll a...more >>

Is it possible to create my own transformation pipeline component for SQL Server Integration Services using .NET? Where can I find a description of necessary interfaces and requirements?...more >>

I have an app that runs selected DTS packages when a trigger file arrives. They need to define what DTS package to run by entering the encrypted command-line syntax, right now that is done by them running DTSRunUI.exe and copping the generated syntax and pasting it in my app. I would rather not ...more >>

Hello, I import a lot of data from CSV files into SQL Server 2000 using the DTS Import/Export Wizard. I've just discovered a very worrying problem after a user reported that I wasn't reporting the financials correctly. After looking into the problem it turns out that the wizard is somehow s...more >>

SQL Server 2000 SP3. I'm having fierce trouble importing a csv file with only two fields. The columns are delimited with comma The rows are delimited with CRLF The text fields are delimited with double quotes. The problem I'm having, is any text field with a comma in it is causing the i...more >>

I see that there is a component to import a file via FTP. Is there a process that a DTS package can FTP TO a site? Thanks in advance...more >>

Hello, I'm trying to import a .DBS file into SQL Server 2000 but I don't know which Data Source to choose. The file is used by an application that has an 'SQL Engine' but unfortunately, that is all I know! Does anybody have any suggestions? Thanks in advance Brian. ...more >>

Hi, I have a problem because I'm new in DTS. I want to export table to many txt files I have a two tables, Employee and Location joined by Emp_ID, I need to set up a DTS package where I can export to different text files ext: table 1 Empid EmpName 1 John...more >>

This is what I am trying to do: I need to import data into a SQL 2000 table from a txt file when a user clicks a button in a Visual Studio .NET VB form. Both the file name and the path will change. There is a field on the VB form that contains the info needed to change the path and file name. ...more >>

What is the best way to export decimal values to a fixed format text file, so that the value is right justified as it should be? I'm getting values that seam to be centered within the field, which makes no sense at all. Help. Regards, Rob...more >>

I need to create a GUID from within an ActiveX control? Can I do this? I saw some examples but I don't understand what is going on in them! Thanks, Michael...more >>

I am trying to use the FTP task to download a file. We are using a static name and password to the ftp site. The download works from a coworker' s machine, but will not work on my machine or one of our servers. I am getting the error message: "One or more files could not be transferred." Does...more >>

, locally and remotely for both servers. I have rebooted and come back to this problem a few days later. I have tried used SQL and NT registration, but I cannot get the package to execute. The error message that I get states: "[Microsoft][ODBC SQL Server Driver][SQL Server]The login 'HGAC' do...more >>

Hello, I am trying to export a query to a comma delimited file. I set up the source & destination connections, create a transformation task. I enter the SQL, then go to the destination tab, there are no columns listed, when I click the define columns button it aborts the whole process & t...more >>

My DTS package outputs a TextFile from a table column that is varchar(2000). The Max(Len(Mycolumn)) is 1403. The file is written OK but it appears that the output records are truncated at about 256. Why? I need to output the full width of the data! No errors and no warnings. Dangerous! How ...more >>

Hello there I have database with many relationships In sometimes i need to transfare another data from other database to the current one, when the other database is in the same structure The problem now is that when i delete all data from the database and use DTS to transfare data from th...more >>

I am trying to import a file that is space delimited and new line as the row delimiter. Is it possible to import a file with a space delimiter via DTS - I tried a few things and was not successfull. We are running SQL 2000. thanks Meenal ...more >>

Hi all, I'm in the middle of a conversion so pressed for time. Real simple. I set up and ran a DTS package to copy data from two identical tables from server A event_history table to server b Event_history table. The server b table was empty at the time and created from script. Both table...more >>

Server: Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4) I am getting an error when I try to open DTS designer through Local Packages-->New Package in th...more >>

We utilize the Bulk Admin fixed role account on our SQL 2000 servers quite a bit. We also have some old SQL 7.0 servers though and it's been discovered they do not have this fixed role account. How can we give a programmer access to do the Bulk Insert function via DTS package without giving ...more >>

I need to create a DTS to transfer data from AS400 to SQL Server. I used this sintax: SELECT [nome_campo] FROM [SISTEMA_AS400] ..[SCHEMA_AS400].[UTENTE_AS400].[NOME TABELLA].[NOME CAMPO]. When I run this query I obtain only some records, not all. How can I do to obtain all records ? ...more >>