Hi Everyone: Somebody to executed two DTS in parallel? If the answer is affirmative it can say to me like, plisssss? Thanks. ...more >>

I'm working on converting some of my SQL 2000 DTS packages to SSIS packages. I'm looking for some example packages to help me figure out some things. Thanks, Scott<- ...more >>

I have issues concerning calculated cell's performance. If I create 12 calculated cells in a DTS, the retrieve takes 7 minutes When I delete those 12 calculated cells and I recreate 12 calculated cells with the calculated cells creation wizard on the same cube with the same MDX, the retrieve t...more >>

Hello, I am trying to make a dts pakage that will upload files from a directoy to a sql table. Pleases note that the text file is tab delimated. also the name of the file keeps changeing. Its like i should be able to go through all files in a certain folder and upload those files to sql tab...more >>

I have a schedule DTS package that I want to track during execution. I've looked in the "sysdtdpackagelog" table and see an entry in the table about my package. When are entries place in the this table? i.e. when the package completes execution or when the package starts and then updated whe...more >>

I am trying to figure out how to run a simple dos batch file after a step within a DTS package completes... For example: A DTS Package uses a FTP TASK to transfer a file. If successful then Execute a batch file on c: called cleanup.bat Any suggestions would be much appreciated......more >>

I re-created my DTS package in SQL Server 2005. I now execute the package using: [ Exec Master..xp_cmdshell 'DTExec /f C:\Data\packagename.dtsx' ] It is working fine however, is there another way of executing this package in SQL Server 2005 without having to go to xp_cmdshell and run DTExec? ...more >>

Hi, I would like to confirm regarding DTS package execution. 1. Multi Threading is possible in DTS package? 2. Simultaneously can we call same DTS package, in more then one DOS prompt? If it is passable is their any effect on Global variable?...more >>

Dear All, I have a scenario as, One terminal is placing txt files in one folder, in each file I have data for all tables, and I am following the following steps Bulk Insert to that text file into a table with one column only BCP Out for One Table Data (by where clause with expr column like) ...more >>

Hello I have a view that will include any records that have the word fail in a particular field. Does anybody know what the code would look like to First check and count how many rows are in the view. (The View name is Test) Then, if there is at least one row in the view I want to go on...more >>

I have a package which copies a number of tables from SQL 2000 to SQL 2005. The tables are not being created with default values on their columns. Any ideas please? -- Michael Tissington http://www.oaklodge.com http://www.tabtag.com ...more >>

Hi All, I have a dts package (package A) which I can execute from SQL Enterprise Manager. I then created another dts package (package B) that runs package A. But, package B hangs when I try to execute it. Even if I hit the Cancel button on the dts status window it never cancels and I have to ...more >>

I'm trying to create a package to transfer data from a SQL 2000 database to a SQL 2005 database. The database already exists and containes data. I want to REPLACE the data but when I dod this I get an error because the package seems to be using TRUNCATE TABLE but all the tables have foreig...more >>

It appears that since nobody replied to my first post, DTS does not allow a view as the Destination for a Data Export or Transform. "Sometimes the answer is found in the silence." John Kotuby 11/18/2005 Have a good day everyone :-) ...more >>

I have a requirement to select records from a sql table that has email addreses in each record and send a formatted email to each person. There needs to be a separate salutation in the body for each email person, so each email body will be different for each person. Is there an article out the...more >>

Using DTS, we'd like to dump the data from a query to an Excel spreadsheet, and save it off with a user\date generated filename. We call the DTS from vb.net, and the problem is, DTS needs to have that spreadsheet present at all times or it breaks the transformation. What is the best way to d...more >>

I'm new to SSIS and have not been able to import a database from sol 2k onto 2005, however, I did manage to restore a backup from 2k into 2005. Now I'm practicing creating a SSIS package to copy all objects and data from this db in 2005 (db1) into a new db in 2005 (db2). I added a Transfer...more >>

Hello Everyone. I basically want to do an insert. Here's my insert script which works when the database is empty. In the destination table i created another index (siteid). ' Copy each source column to the destination column Function Main() DTSDestination("wexchid") = DTSSource("ex...more >>

Hi, I´m having problems with a DTS that reads a text file from a Unix Server and loads data into a table in SQL Server Enterprise and sometimes it Fails with error -2147024882 (8007000E) Error string: Not enough storage is available to complete this operation. If someone have a solution f...more >>

All, Is there any relief from what happens when DTSing an Excel spreadsheet into SQL 2000 and the zip + 4 values import as NULL? Thanks. -- jl...more >>

Hi, I have written a SQL server Agent job that deletes some rows in a table that meets our criteria. It works perfect. But I have a question, is there any way that after the job it tells me that it has deleted so many number of rows? my sql statement is delete from xxxtable where datedif...more >>

Hi! Following code works just fine, until the global variable is set to true Function Main() Dim oPkg Set oPkg = DTSGlobalVariables.Parent If DTSGlobalVariables("UPGRADE").Value Then oPkg.Steps("DTSStep_SQLExecuteSQLTask_2").Value =DTSStepExecStat_Inactive oPkg.Steps("DTSSt...more >>

I'm trying to do a copy database from 2005. The source server is sql server 2000 and the destination is a sql server 2005. I can copy the db over without a problem, but every column that I have setup as Identity=true on the source comes over to the destination as Identity=false. Any ideas...more >>

Hi! Forgive me for my ignorance. Iv'e been looking at following webpage But I can't figure out how to skip SEVERAL steps/tasks in a workflow. ( http://www.sqldts.com/default.aspx?214,1 ) I have following workflow series Step 1: DTSStep_ActiveScriptTask_1 Step 2: DTSStep_SQLExecuteSQL...more >>

In the Expression property of a variable in the designer, you can't get to the Expression builder. This just has to be bug? Apart from pulling expression builder up against another property page and cutting and pasting, is there an easy way to get it up? -- Regards Chris...more >>

I have a parent package which i am scheduling to run every month. The parent package has 6 child packages and they inturn have many steps. Assume Task 3 or package 2 fails. The support person will rectify the error and he will re-run the package. Now when he re-runs I want the package to st...more >>

Which of the below mentioned query will be faster ? and will the result of both the queries is same ? A. select * from authors INNER join pubs on authors.pubid=pud.id where pub.active=1 B. select * from authors INNER join pubs on (authors.pubid=pud.id and pub.active=1) ...more >>

Hello: I have 3 table with this description: Table1 -------- id: int value1: int Table2 -------- id: int value1: int title as varchar(80) Table3 -------- id: int norden: int text : varchar I have to transform data from Table1 to Table2 but get some value from Table3 too,...more >>

I need to import over three years of IIS log files into a SQL Server database. Is there a package out there that is publicly available and already does this? Are there MS recomended sites that provide complete DTS Packages for importing common MS Application data files into MSSQL?...more >>

I am trying to use the package migration wizard to transfer a package from Sql Server 2000 (DTS) to Sql Server 2005 and I get the following error no matter what I do/change. Any help would be great. This wizard will close because it encountered the following error: (Microsoft SQL Server) ...more >>

Hi, I'm setting up quite a few DTS packages to transfer in records from remote sources into local reporting destinations. After a given Transfer Data Task completes succesfully, I'd like to insert a record into an auditing table to specify the current date, host names and the number of row...more >>

Hi all! I'm launching a dts that has to load a file into a db table and when I'm executing it a failure is raised: Server could not load DCOM. any idea ? thanks! milly...more >>

I'm Currently working on a custom pipeline component wich write specific text file so I need to convert each columns into string. We've many DataType in SSIS for DataType Enum : ____________________________________ DT_BOOLA Boolean value. ..... DT_UI1A 1-byte, unsigned integer. DT_UI2A 2-b...more >>

In AxctiveX Script I was dynamically changing the server and database of an existing connection as I was looping through a recordset and then executing a SQL Task that was set to that exisitng Connection (see code example below). Everthing worked beautifully as long as I was switching databas...more >>

Hi again (and again) guys... I have just read an article in the SQL Server magasine which says that its recommanded to have 1 file by processor for the tempdb database. does this recommandation is good for a data warehousing solution? I'm suffering some disk issue and I have a lot of CXPack...more >>

Hi! As the subjects says i wish to find out if a spesific database exist in my sql server. I wish to write following statement. if not exists (select * from information_schema.databasename where database_name = 'myDB') Create Database myDB GO But I know i'm missing something.... P...more >>

I have step in my package that copies database from the server to my local machine. I am doing it so I can back up database - I am using hosting database. The problem is that coping of data fails if I specify in options that I want to copy Primary and Foreign keys. I would like to copy that ...more >>

What I want is a way for an Execute SQL Step to get access to a package global variable so that I can do decisions based on it and I cannot figure out how. What I have is a global variable called "LogDebug". I need this to be used in an Execute SQL Task in the following manner: IF DTSGlob...more >>

Hi, How do I retrieve a package which I saved during the import (using import wizard) in SQL Management Studio as SQL Server package??? ...more >>

I am having problems importing text values from an Excel file. Numeric fields are loading fine, however. Below is what my spreadsheet looks like APP_AGE 1 1 2 2 3 3 4 4 5 5 I am doing a straight copy column int...more >>

I can run my dts package directly. However, when I schedule the package as job, I get the following error message: Executed as user: WIN\cis50SQL. ... OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DT...more >>

By default, are the sql statements in DTS in TRANSACTION?...more >>

How can i get a row no column in a query... i just want to check if a row no of a row is more than a constant number than set some flag in another column ...more >>