Hi all, How can I have the result set of three different tables into one flat file. 1)Simple select statements from three tables 2)Fixed field data 3)Variable flat file name, eg: batch20031221.txt Thanks for your time and energy Vijay...more >>

Dear, I want to capture a date field from CSV file to the table (the CSV file have one date field only). But the table data (another field) import from another CSV file. How can i import the data field from CSV file and fit in the table? Many Thanks John ...more >>

Sorry for reposting a similar message but I really need help. I have a query that looks like that : SELECT DISTINCT A_CLIENTS.idclient, A_CLIENTS.CLICODE, A_CLIENTS.CLIEMAIL, FROM A_CLIENTS WHERE A_CLIENTS.IDSOCIETE=@idsociete AND TT.LOGDATE<@ddate I would like to generate a xls file ...more >>

Hi, How to pass variables into a dts and run the dts from a stored procedure ? I want to pass 2 variables to a DTS, one is a CodeID and the other is a filePath And of course, I want to change the current filepath with the new that I send. Thanks for your precious help Stan ...more >>

Hi, I have a huge DTS packege running right now, it's inserting 400 million rows into a table that have a clustered index and a non-clustered index on it. It has been runing for 54 hrs now and the tranlog has grown to over 160 gig. I bet there is a lot of inactive tran-log by now. Is...more >>

first of all, if i use the Data Sources (ODBC) administrative tool to set up a User DSN, one of the type/driver options is 'Microsoft Access Driver'. i'm pretty sure that's the option i want to use! however, when i start the DTS wizard, 'Microsoft Access Driver' (at least the English version!) i...more >>

Hi, we have a table 'tableA' in 'databaseA' that has 400 million rows and 60 gig big, without any index on it. We need to build a cluster index on tableA, and a non- clustered index on 2 of its columns. Hence we created tableB which is identical to tableA only tableB will with index bu...more >>

Hi, I am trying to refresh an excel spreadsheet from sqlserver. 1. I have setup the excel spreadsheet with external data source to the sqlserver. 2. I have an active x task as follows '********************************************************************** ' Visual Basic ActiveX Script '**...more >>

I have a developer that is trying to write an ActiveX script step inside a DTS package that calls a stored procedure which executes an UPDATE statement. After the update statement runs a select is executed to populate the output parameters of the stored procedure. The output parameters d...more >>

Hi @all, I've got an DTS Package that exports data from a table into a file. This Packege runs every day, so I want to make the name of the file variable like that: BackUp_20031219.txt The first part of the filename ist fixed and at the end I want to connect the actual date. How can I real...more >>

Has anyone built a simple interface to monitor and run SQL Agent Jobs from Microsoft Access? I have built several SQL Agent jobs and would like the ability for operations to be able to easily kick these jobs off if needed and monitor if they succeeded or not. Spencer Tabbert...more >>

Hi NG, i got two sql-servers (differents between them: german and engl. OS) On both servers i got identical dts-packages. The last step in some packages is an activextask. The packages are started by night with the dtsrun-command from a job by sqlserver-agent. On the german os anything works...more >>

I am running SQL Server 2000 Developer edition ver 0120.1 July 2003 on a stand alone PC, not connected to a server or network. I have created a number of tables in a new database. I need to export the table definitions and the data in them so that I can install them on another machine runn...more >>

I am new to DTS and I am trying to figure out how to do something I have written a routine that connects a local SQL server to a remote SQL server and does some data exchanges. The problem is that there are 40 remote servers that I need to connect to all with different passwords. In addition, the ...more >>

I have a DTS package with data pump task. After the end of the task I need to report the amount of rows copied. Can any one advise the ways to achieve it? Cheers, Sanka ...more >>

Howdy all, I'm trying to use DTS to output the results from a dynamically generated query into Excel and email the resultant .xls file directly to the requesting user (the users will be able to choose from a list of 'Reports' and supply values to be used in the WHERE clause). I've gott...more >>

i have a table called customer. I am trying to export the data in the table to text file. In DTS designer i have selected the server and text file and i have filled all required data. In transform task, in destination tab, clicked on define column button. its showed the columns in the table. clicked...more >>

I have a DTS that updates 2 tables from a VB6 application or from text files stored on the server . I am executing the DTS from a Visual Basic project using the code below Dim oPkg As New DTS.Package oPkg.LoadFromSQLServer ServerName:="ServerName", ServerUserName:="UserName", ServerPa...more >>

We have two separated machines, one for MS SQL Server and another for web server. The problem is that I wrote an asp file to read DTS task titles on the web server which doesn't have SQL Server installed. However, because of absence of SQL Server, my ASP couldn't use certain components such as Ser...more >>

I currently have a product server and a development server, Once a week we transfer the production database to the development database. To do this we use a DTS package that uses the Copy SQL server objects task. This works but the job in sql is always flagged as failed. After looking ...more >>

Could any of you folks please tell me how I can get the hotfix mentioned in KB814113? I tried going thru 'Contact Microsoft' and although I have the license number for my client's SQL Server 2K package, I don't have the foggiest on where to find the PID......the contact form conveniently left off SS...more >>

I need to copy the actual package and not the data. ...more >>

Hi, Am trying to create an OLEDB connection to a Sybase symposium server (ASE 11X), I installed the sybase client on my machine and am connected to the sql server via enterprise manager. I have a DTS package on the Server that needs to get some data in from the sybase server. I tried c...more >>

Hi folks, I'm pretty new in DTS (actually it's my first DTS project at all) and thank you guys for every hint/help in advance. I'm using VB.NET and MS SQL Server 2000 I need to do the following: - Read data from SQL-Server and convert it to an excel file - the SQL-Source-statement is differe...more >>

I want to declare a global variable for uniqueidentifier type, which type I should choose for the variable? String doesn't work Thanks....more >>

I am copying a subset of data from our production warehouse to a test bed warehouse. I am using Execute Package Tasks in which I place a Copy SQL Server Object Task. This task copies a single table's data replacing the existing data in the test bed table. I also include logging features...more >>

I need a Package that loops through a recordset containing tablenames that have to be transferred to another server. I've so far created a task that returns the table names to a globalvariable, a task that loops through the variable setting a "createtable if not exists.." on a SQLTask and then...more >>

HI, I am loading a A SQL TABLE I am getting the following error any IDEAS? Step 'DTSStep_DTSDataPumpTask_1' failed Step Error Source: Microsoft OLE DB Provider for SQL Server Step Error Description:Unspecified error Thanks in advance SUNNY...more >>

could anybody translate this oracle specific sql statement to sequel server specific sql. pleassssse substr(enquirydetails,instr(enquirydetails,'Form Name:') +11,instr(enquirydetails,chr(10)) - (instr (enquirydetails,'Form Name:')+11)) thank you...more >>

Please help... On our production server, I have a DTS package which executes an exe which calls a batch file that invokes an osql session and runs a query (MS blocking script logger). When i run the dts package from my workstation, it creates the dos session on my machine... but when the pa...more >>

Hi I have a access database I am picking up values from access and putting them in SQL SERVER , It doesnt populate it Gives a error saying "Record Is Deleted" Thanks in Advance Sunny...more >>

Does anyone know if there's a hard limit to the number of columns you can import with BULK INSERT? Maybe 255? Any change between SQL 7 and current? Trying for 335, I get an error with what I believe is a correct fmt file; says "invalid column number", but doesn't say which. Thanks, D ...more >>

Each time I try to call another pkg the process fails. I am using the following logic to call the next pkg. ' ============= Call another DTS pkg ============== const DTSSQLStgFlag_UseTrustedConnection = 256 ' == Call the pkg which will read each file and process it. Set oPkg = Creat...more >>

I am executing a DTS package every hour but I do not know if there is a better way of doing, the ms sql are in the factory floor they only hold for a week, so i need to send all the data to the main sql, i think the dts sends the whole database every time, Is that right? How can I send the...more >>

Can anyone explain what PrecedenceBasis Property is? and please, explain it like I'm 4 yrs old. Thanks. Cheers, GMG...more >>

In Execute SQL task, before the parameterized query, can I define some variable? For example, Declare @v1 uniqueidentifier Declare @v2 uniqueidentifier select @v1 = col1, @v2 = col2 from table_name where id = ? .......(the left) This can not be parsed in the Execute SQL task. What kin...more >>

Does anyone know how to set the next task in the pre-task-execute VBScript? That is, assume task1....task5. In task1, I check for a condition -- if that condition is TRUE, the next task should be task3, if it's false, the next task is task5. Does anyone know how to do that? Any help you could offer ...more >>

In the DTS package I am currently working on, I have to create 3 connections, but their properties (including server, login, password) have to be decided during run time. What options do I have to implement such a feature? Do I have to do it programmatically? Another questions is that I have ...more >>

Thanks Darren. I found in your mail much more than I found from myself ...... My problem is that I have a SELECT on an OLEDB connection to DB" and I want to write the selected records in sqlServer. I'd like to take only record with a PK beyond the last PK I wrote previously without selecting all...more >>

Hi all, i am very new to sql server. my question would be very silly pls bear with it. how can i import data from an XL to a table....more >>

Hi group, using dtsrun utility to run a structured storage file, how can one pick up the most recent version without specify the package_version_guid_string? Thanks for your response Quentin ...more >>

I am assigning the results from a query into a global variable rowset and then running another package and passing that rowset over. Can I in the called package use the rowset within a Execute SQL Task rather than having to loop through it programatically in an ActiveX. Cheers ...more >>

Can anyone point me in the direction to where I can get a copy of Yukon Beta to test/play with Cheers ...more >>

I keep getting the error The number of failing rows exceeds the maximum specified Insert error, column 53('DateX', DB_TYPE_DBTIMESTAMP), status 6: Data overflow. Invalid character value for cast specification. I have the following code in my VB script to capture invalid dates but it's ...more >>

Hi, I would like to use OSQL command to spool the output of a query to a text file. However, the length of the column in the text file is not same as the table column length declared. As I need to process the output file again , I would like to know exactly the start and the end position ...more >>

I have a DTS using an execute SQL Task which is importing data into two tables linked by field 1, From previous help, i thought it best to create a trigger on one table and then drop the trigger after the command has completed, rather than having 2 different SQL tasks ExecuteSQL Task is...more >>

Hi everyone, I have written a sp which calls a dts package which I have tested and works. I would like to schedule this sp so have put it in a dts package to call a second package. If the second package executes sql it works fine but if the second package is used to import data from a tex...more >>

I want to set schedule for data transfer from IBM AS/400 daily.Please show me the steps. Thank you....more >>

The data source file(CSV) is a 3-line text file. when the file has a row which violates PK_constraints, none of 3 rows is inserted. I want other two rows to be inserted. How can I do that? TIA. Error: Step Copy Data export to [Weather].[dbo].[tblWeather] Failure reported while processing...more >>

Hi, We have data in a sybase which I need to export into SQL Server 2000. I have never worked with sybase and don't have any idea how to do this. The database is on another server on the network... How do I go about it??? Please Help... Thanks Khan Imran ...more >>

I have a problem with a DTS. I'd like to use a global variable in query (where clause) of a transformation task (source side). SELECT * FROM AUTHORS WHERE STATE = global_variable Any help? Thanks, Rocco ...more >>

I now have this code in Delphi: { Create the Ole object.} OlePack := CreateOleObject('DTS.Package'); { Load the package.} OlePack.LoadFromStorageFile('c:\dossier\MedImportHyr.dts', ''); OleTask := OlePack.Tasks.Item(1); OleCust := OleTask.CustomTask; OlePack.Exec...more >>

I want to be emailed on the success or failure of a DTS package. I have sent up a Send Mail Task at the end of everything which emails me on success. That works fine. At first I thought I could just set up a Send Mail Task at the end so if the job failed I would get an email. But then ...more >>

Can you, using a DDQ, execute a given task in a package multiple times? I know that a DDQ allows you to perform *something* dependent on the value of a given field in the DDQ's query rowset, but I don't know if that includes TASKS. Help!...more >>

Hi Does anyone know of a good third party alternative to DTS? I use DTS to do a straight copy of data SQL Server and Oracle (occasionally Sybase 5 or 7). I often find that DTS throws up errors during these transfers, and they can often be overcome by doing some of the transfer using the Or...more >>

Hi, When I import an Excel file using the DTS Wizard all text columns are automatically set to the 'nvarchar' datatype, is there are any way to change that to 'varchar' without going through every column(have the DTS Wizard set all text columns to 'varchar', is what I want)? Thanks!...more >>

I would like to automate my DTS package further. I would like to be able to enter one paramter that would be used by all the package elements (I'm assuming this would be a global variable?). The package elements are mostly sql type. I want the parameter data to be affect table names for...more >>

Hi, I have one requirement something like this. I have 13 dat files at one location. Need to copy the data from those 13 files into one SQL Server table at one time. I am planning to use DTS. But how to configure DTS package to get the data from those 13 files at a time and insert into one SQL Ser...more >>

Hi I know this highly improbably but by any chance is MICROSOFT ANALYSIS SERVICES available of free download on the net? Ravi ...more >>

I have my custom task - and inside my class code: public void Execute(object pPackage, object pPackageEvents, object pPackageLog, ref Microsoft.SQLServer.DTSPkg80.DTSTaskExecResult pTaskResult) { PackageLog packageLog = (PackageLog) pPackageLog; Package2 package = (Package2) pPackag...more >>

Trying to DTS a database from one server to another and received the above error during the loading phase with the failing username. Can't seem to DTS the database over. Thoughts? I've added the user to the Security section of SQL to see if that helps Jeff...more >>

Hello All - I am looking for a way to capture data in an email body into SQL Server. Can someone help me out? Thanks Kristina ...more >>

I'm installing the dts runtime files on a client machine. When I try to register the dtspkg.dll I get an error message that the specified procedure could not be found. I've done it a several times on different machines without any problems. They are all running WinXP Pro. Anybody else run in...more >>

I'm new to DTS. I have the following problem: Im trying to update a record with an Data Driven query, but each time i execute it, the following error ocurrs. "Syntax error converting the varchar value 'Main producer' to a column of data type smallint. the query is: UPDATE dbo.Distribu...more >>

There are 3 packages running on my server which are similar except for the path that an executable runs at. If I right click the package in Enterprise Manager and execute it, it fails. If I go into design mode and execute it, it intermittently picks the wrong path to execute on which I can see...more >>

In my DTS package I have (Execute SQL Task ) name test1. I would like to execute this task and skip other taks in the same dts. How do I do this?...more >>

I currently have a DTS Package with a SQL connection created (Destination), source Text file created and the execute SQL task created with the parameters but I can not get the info from the text file to the parameterized updated statement. How can I do this...more >>

I'm using a DTS package to transfer data using an ODBC connection from an Informix database. When this package is scheduled a error message pops up saying ************************** DTSrun.exe - Application Erro The instruction at "0x77fcc97c" referenced memory at "0xfffffff9". The memory coul...more >>

I'm running a DTS package which updates an Excel spreadsheet. I want to save the spreadsheet in HTML format. I've set the spreadsheet to publish so that the HTML page is updated when the spreadsheet is saved. This works when the spreadsheet is manually saved. I've written a macro which sav...more >>