Hello, how can i send a file with the FTP Task direct from the SQLserver 2000 R Stefan ...more >>

I'm using sql server 2005. I'm trying to create a package that import data from Oracle 10g to SQL server 2005. in the Data Flow Designer the OLEDB Source is displaying a warining icon saying: The component reported the following warnings: Warning at {1C010C8E-2695-4214-BC94-067A57B1823E}...more >>

Hi there, I have a development server where I have tables that are bound to the dbo schema, I tried to use the "Transfer SQL Server Objects Task" to transfer these tables to my hosting providers SQL 2005 server. However for obvious reasons I'm not dbo over there. So when I select the tables h...more >>

I have windows2000 server running sql server2000 sp4 with sqlmail installed, configured, and working. Sql Server Agent is started using a dummy domain account with administrative rights for sql and the domain. I created a dts package that when manually run, works everytime. However when...more >>

Hi, I would like to create a dynamic package which exports results of different stored procedures with select statement and different number of columns to a .csv file. I've already got a script which changes SourceSQLStatement to 'exec ' + sp_name and and Connection DataSource property to the...more >>

We are having a website that generates postscript files when an order is placed on it. These files are placed in a folder on the network. I have been told to Load the postscript files into an existing sql database and then delete the file from the folder. If anyone has an idea on how to l...more >>

Is it possible to load a blank or empty file with a data pump task? We have a process that loads multiple files, and sometimes they contain data and sometimes they don't. We don't know which files will contain data and which ones wont. Instead of creating multiple packages to handle every p...more >>

Given: I'm using a DTS Package to import data into a table. Each row from a text file gets placed into a corresponding table. What I need to do: I'd like to modify the DTS Package to change the data saved to a table based on values in the records from the text file. In otherwords, if a ...more >>

Hi All, Firstly apologies for the obscure subject line. The task I am try to achieve is to copy information from Database A on Server 1 to Database B on Server 2. I would like this to be a DTS task (so that Many tables can be updated in the target database). However my knowledge of DTS is...more >>

I'm trying to implement an archive operation using DTS. In this case, data from certain tables I need to overwrite in the destination DB, so I'm using Copy SQL Server Object task, its fine. But for certain tables, I need to append the new rows. Here I'm using datapump task. In this scenario, w...more >>

We've been trying to convert an application from MSDE to SQLServer 2005 Express Edition. That application transfers some data form a SQLServer database to an Access database and the other way around. We have been using DTS, created/configured at run time by the application, to create the destin...more >>

Hi Using DTS Packages: I have to downlaod a file from ftp server which is not a problem, but this file is a zip file which consists of a mdb file. Now, is there a way to extract the mdb file from this zip file from the dts package. If there is, can you please give me some sample on how to do...more >>

Hi, All, I want to edit a package was created by sql server Import and Export Wizard. It did run great before. but I found there are some files or innerpackage.dtsx were missing which were located at temp folder later. this package just do copy data between two database. I want to add some...more >>

Hi I have DTS got 12 task, I am using on completion flow, even if task failed, i want to continue to run other task, My question is, is there any way to find out through workflow property, status of previous step, failed or success thanks kalyan...more >>

I need an activeX script that will: Query a table in my database: Select FailReason from ErrorLog where DateOfFileCopy = getDate() I want to store the result in a variable called flds. then: If Flds = 0 Then DTSGlobalVariables("ExecuteTruePath").Value = True Else DTSGlobalV...more >>

I have a DTS package that copies data from an Oracle db to a MSSQL db . When I schedule this package to run on the target server, it fails with the following error… Step Error Source: Microsoft OLE DB Provider for ODBC Drivers Step Error Description:[Microsoft][ODBC Driver Manager] Drive...more >>

I have a database that captures real time production data that I'm trying to keep lean 'n mean. We don't want our analysts querying this db all day. So, we've decided to have a second db that we will keep in sync with the lean 'n mean production db, and the analysts can query this until the c...more >>

I have the below table that I need to load about 1 billion records into. I was wondering if anyone could offer some tips on how to optimize the process. I load data_table via a staging table that could have 1000 records - 50 million records. I use a left outer join to ensure that no duplica...more >>

Hi, The fixed length column input file includes the data from next record if one or more of the previous record columns are missed. Tried all the row delimiter (CF,LF,CF&LF).Is there any solution to solve this issue? Thanks *** Sent via Developersdex http://www.developersdex.com *...more >>

Hi I am writing a package that i want to have email me on two possible success scenarios. essentially, this is the conditions: IF @result = 0 BEGIN EXEC master..xp_cmdshell @copyfile, NO_OUTPUT PRINT 'Operation Successful' END ELSE BEGIN PRINT 'This operation failed. Error Code:01....more >>

Hi I am writing a package that i want to have email me on two possible success scenarios. essentially, this is the conditions: IF @result = 0 BEGIN EXEC master..xp_cmdshell @copyfile, NO_OUTPUT PRINT 'Operation Successful' END ELSE BEGIN PRINT 'This operation failed. Error Code:01....more >>

I am using the import/export wizard to import all the objects from one database into another. My problem is that any views that use User Defined Functions are failing because the view is being created before the UDF. I have searched for this error, and found the following microsoft article:...more >>

Hi, I am using a cursor inside a stored procedure to do some complex work on each row in a table. Looking at the execution plan everything looks fine (Always worry about cursors!!) and the Stored Procedure runs fine if I call it via Query Analyser. When I go to run the stored procedure f...more >>

Hi, I have an SSIS project, has a connection to tempdb (local sql2k5 server), 3 tasks, creating a table, populating the table, then deleting the table. of course when I test the connection i GET TEST Succesfull (I am using sa ...) Whenever I run the package, all tasks become red colored, I ge...more >>

I built a dts package that executes fine when I manually start it but it fails immediately (event view says within 1 second) when scheduled. this package copies elements of a db on the production server to the backup server. Help. Andre ...more >>

I am writing a tool to convert DTS packages by using the scripting model. I have to change the connections in multiple ways. Some packages are behaving weirdly with their connections: in de original package there are only the connections visible that are used in that packages, but in my conver...more >>

Using SQL Server 2000, I have a DTS job that imports data from a text file that uses 2 connections and a transform data task. Obiviously the first connection is the text file and the other is the SQL Server database. The problem is that the text file will not always be in the same directory ...more >>

Hi All, I have a package that sends a mail using VB as opposed to sendmail (I'm no expert on VB so apologies in advance). Basically it will retrieve the users that match criteria, insert images and information and send the mail. This works fine from DTS designer, but when run as a scheduled...more >>

Hi All, I have a DTS package that I launch from a C# application. The DTS package contains an Excel Connection. AS the location of the Excel file can change dynamically, I need to be able to change the value of the Excel Connection's "ExcelFilePath" property from my piece of C# code. The ...more >>

Hello All How can I change content of a source column in row by row basis on an ActiveX script. I use Transformation Data Task and when i want to change a source column this error appered: "ActiveX scripting transform does not allow a script to change source columns" Thanks for any Help ...more >>

The lay-out of the DTS packages is not preserved when opened and saved by using the DTS Object Model. I know that this is by design, see http://support.microsoft.com/?kbid=249901. But it is pretty annoying. So if anyone would know a hack for this one, thhat would be highly apreciated! TIA, ...more >>

Does anyone know how to recover a lost DTS package password? Someone has left and we don't know the password for quite an intricate dts package. Thanks,...more >>

Hi, I would like to be able to run a DTS from an ASP page (not an ASPX) giving the DTS package parameters on the fly. My goal is to be able to give a table name and to retrieve the table content locally in a text file. Thanks, BigFellow ...more >>

I've been trying to create a simple DTS Import package using the "Import" Wizard. I can get the package created, executed and saved but when I try to open it up in designer or even execute it again I get an "sa" login failure error from the "Microsoft OLE DB Provider for SQL Server". Any ...more >>

I am trying to write the contents of a nvarchar datatype field to a text file. I have set it up as a dts package where I first populate my global variable result set and then I access it from the activex script where i perform some processing and write the results to a text file. however t...more >>

I am confused as to how to do the following: Create master DTS package where I set the Connection for the servername, db, login and password. (I can do the previous part, but not the following.) Then assign those values somewhere; ini, etc to be used by other packages. A few constr...more >>

I have a package that exports records from a linked server into a table on the current server. I would like to add a piece of code to skip a row if that key is already in the table. I attempted this but got a type mismatch error on 'DTSSource'. Here's the code snippet I attempted: if (DTSSourc...more >>

We have a scheduled DTS package which transfers a database (tables, stored procedures, views, functions, etc) on a nightly basis. We specifically choose the following options: Create Destination Objects - checked Replace Existing Data - checked Include Extended Objects - checked Use Coll...more >>

when doing my wash of data I have no use of the transaction log. I take a backup before start of washing and alway wash all data. So what I would prefer was to disable the transaction logging. I already chose Simple as option of the database but that doesn't prevent the file from growing. I...more >>

Does anyone know why the "OLE DB provider for ODBC" won't show up in my Provider list when I try to set up a New OLE DB Connection? I do have this provider installed. Is my only option to write a script in order to connect to an ODBC destination? Thanks. Dave. ...more >>

Hi, in one of my DTS scripts I want to DELETE * FROM all the tables containted in an Access database. So I wrote a script like: DELETE * FROM [tabA]; DELETE * FROM [tabB]; DELETE * FROM [tabC]; DELETE * FROM [tabD]; But unfortunately Access doesn't allow me to put more t...more >>

Is there a way of repersenting this stagement in the EvalExpression @LoopCounter > @MaxRecordCount OR @RecordCountLeft > 0 @LoopCounter increments 1 each record @MaxRecordCount is the maximum records that should be in the record set @RecordCountLeft is the number of records left after the ...more >>