Today, I wasted six hours trying every way I could think of to transfer data between a remote SqlServer2000 server and a local SqlServer2005 server. Prior to "upgrading" to this ridiculously poorly designed piece of trash known as SqlServer2005 that process would've taken about 3 minutes, most ...more >>

I have created four "worker" packages and one "Leader" package in my solution explorer. My intent is to use the "Leader" package to invoke the worker packages for parallel execution. The "worker" packages have been tested, have logging enabled and have updated package IDs. So I was confused wh...more >>

No matter how I place my objects in SSIS Designer it won't save the layout. It always does Auto Format and displays objects in one long column. Really distrubing! Anyone knows how to solve this? Thank you, Robert *** Sent via Developersdex http://www.developersdex.com ***...more >>

Hi, I am working on DTS. I am transforming data from Excel to SQL Server through DTS. The problem I am facing right now is, in excel I have some value as 0.10665 but that cell is formatted as to take up to 3 decimals so its coming as 0.107 but while transformation I want 0.10665. Simple solut...more >>

Hi, I've created an SSIS package by using the Import Wizard and saving the package to the file system (since Integration Services will not install on my server). I have noticed the package creates several connections to temp files and stores the SQL it needs to run in these files. eg ...more >>

Hi, I am exporting data to a worksheet "Data". The worksheet "Result" is based on the worksheet "Data", and has a pivot table. When my users open the workbook, the pivot table gets refreshed which changes the state of the file to "modified". When they close the workbook, they get a messa...more >>

Hi All, I open a new project and select Business Intelligence Projects, but i don't see Data Transformation Project? I am using VS2005 prefessional edition and Microsoft SQL Server Management Studio version 9.00.1399.00 Thanks Nick...more >>

I have my packages organized into Solutions and Projects. When I click the Start Debugging button on the toolbar, it starts up ALL PACKAGES FROM ALL PROJECTS in the Solution. In other Solutions, clicking the Start Debugging button only starts the one package that is open at the time. Wha...more >>

I want to do a simple DTS export of a database. From a SQL 2005 database, export it to Access or Excel (both 2003) I'm running on Windows Server 2003 SBE I create a blank Access/Excel file and am unable to export to either Access or Excel. The DTS Errors I recieve when exporting to Exc...more >>

Sorry if this isn't the right place for this but I got this problem dumped on me, and I'm more of a mainframe guy. We have a package that each week uses HTTPS to log onto a secure website and download 3 files. I then unzip these files and run a SQL2000 DTS package which drops a bunch of tables...more >>

Hi, I have a dts package which contains serveral steps and recently it has been failing in one of the steps. Is there any way I can trace why it fails? Thanks,...more >>

Hi, I have a dts package which contains several steps, Is there any way I can view what exactly each step does---the code for each step? Thanks, ...more >>

Hello, I have a series of fixed width flat files where the character length of each record is 384. The problem is that there is not a carriage return after the ends of some of the records. There is research under way to find out just exactly why this happens, but in the meantime, I need to f...more >>

Hi, is it possible to split data (Space Separated Values format) in a column into several rows? I have a datasource/data extraction where a column has multiple values separated by space. Those values should be in a row record by themselves. I was planning to connect the data to Script Comp...more >>

Is there a way to execute a single DTS task using VBScript in SQL 2000? TIA, Alex ...more >>

After installing sql server 2005 as second instance on top of 2000 instance the dts package with ActiveX Script in 2000 instance hangs on execution Does anyone experience such problems Any solutions Thank you, ...more >>

Hi, I need to connect to Oracle 9i Server & Sql Server 2005 datasources dynamically, wherein the connection strings needs to be retreived from an text file specified. I am trying this by using Expressions and specifying that in the Connection Manager-->Expressions box, but no luck. Does...more >>

How does one supply parameters to the SSIS call when using a .NET assembly? The code snipet I am using allows me to call a SSIS package, but I do not know how to supply a parameter value for a SSIS package variable defined in a package configuration with a parent package variable. Here ...more >>

i want to dynamic dts package on dotnet i can working on data from dynamic txt file to table in sql server .but txt and table name is changeable. can i do in vs.net ??(C#.Net) ...more >>

Hi everyone, I am using a flat file connection within my SSIS package to importing a .csv file containing double quotes (") as a text qualifier. The problem is, that some rows contain not only strings like "test" but also strings like "test". Debugging the project results in the error : The co...more >>

Hi everyone, I am using a flat file connection within my SSIS package to importing a .csv file containing double quotes (") as a text qualifier. The problem is, that some rows contain not only strings like "test" but also strings like """test""". Debugging the project results in the error...more >>

I am trying to write a Windows Script file that will update an exisiting DTS package. The objective is to add an additional mapping to the single transformation in a DataPump task. The existing transformation maps many fields, and I'm just trying to add a field to the list. The code I...more >>

Hi there I have a DTS package that will take records from a log file, insert them into a staging table, which is a real table in SQL. Then I want to insert these records into another results table which is a table to be used in a web application. How do I check, without using a cursor, if the...more >>

Hi I created at SSIS package in BIDS where I use the WMI Event Watcher to lookout for the creation of a text file, when I run the package from BIDS it works fine. Now that I'm done, I created a SQL Server Agent job with the package as a step, but when it "run" the job, it does nothing - no er...more >>

Hi, I had a dts package running fine on a sql server 2000 instance. An ActiveX component of that package stopped working when a 2005 instance was installed on the same server - but the package was still running on the 2000 instance. The script is just create a text file on a server. It r...more >>

I have a DTS package I created that is dadabase driven to process source data from multiple sources. Can I run several instances of this package in parallel for each source or would I need to create a copy for each source ? JavaWaba ...more >>

Hello, I would like to be able to pull daily main frame files into my SQL database on a daily basis. We have the code down in order to get the files from the mainframe, where we are struggling is with a DTS task to check and see if the file is for the previous day and then if it is, execut...more >>

I am trying to desing a series of SSIS packages that will read their Connection Manager's connection string property from a package configurtion. I anticipate databases migrating between servers in the near future and do not want to re-design or re-enter connection strings, etc. I set up a sin...more >>

I'm trying to implement an SSIS package but have run short of ideas on how to best do it. I need to send a group of uniquely named data request scripts (with file extension .req), to an FTP location. After a short (but unknown) length of time, a similarly named data file will appear at the ft...more >>

The scenario : I import a medical history table every day. If I delete the destination data table every day and import the complete table, it takes a hell lot of time (about 2 hours). I just want to import the refreshed(or new data) and not the old data. Let me explain with an example, say if ...more >>

Hi to all, I am new to dts and sql server and wish to know if this is possible. We want to know if sql server allows you to run dts's on different machines? What I mean is some sort of architecture that allocates a dts to a client machine that does the work and another dts is assigned to a...more >>

I am trying to deploy an SSIS package that I created. Within the SSIS package, there is an ADO.NET connection manager that contains my connection information. This runs fine from Visual Studio on my machine. However, after I deploy the package to the SQL Server 2005 machine using the manife...more >>

I am using SMTP Mail Task on a windows 2003 server and have the SMTP Virtual Server portion of IIS running with anonymous access enabled. I have a DTS package which consists of a single SMTPMail task that sends an email to myself via the server I just mentioned. When I run this task from an e...more >>

I appreciate people's help in advance. Here is my issue: I have created an Integration Services Package that contains an Execute SQL task with the following code: BEGIN SELECT * FROM dbo.TABLE WHERE Period+Year IN (SELECT (Period+Year)SearchOn from TBL_OUTPUT GROUP BY Period+Yea...more >>

Could I get the spreedsheet name and use it in DTS package using VBScript in ActiveX task...more >>

Hi. Does anyone know an alternative to SSIS Export/Import in Virtual Studio? I need this because i have customers who needs to copy or move their databases to other SQL servers. So if you have an util or a program that have these fetures please respond. Regards Rune. ...more >>

I am a newbie DBA. That being said, here is what I am running into trying to use the "Copy Database Wizard (CDW)". Yes, I have read that I can use backup and restore, attach/detach but I would like to know why this approach didn't work. Here is the scenario: Source server: windows server 2...more >>

Hi there, I am using DTS script for the conversion. I would like to get a database name as a parameter from the user (through a command line), assign it to the package global variable, and then use Execute SQL task to drop and recreate a database with such name. However, I have troubles passing...more >>

I'm new to SQL Server 2005 and I want to copy data from one db to another db. For source data flow object i want to use OLE DB Source Query bacause I want include variable in sql statement. SELECT Name,Tag,DDate, FROM ICRA_39_Dok WHERE (DDAte = ?) I have dat named package vari...more >>

Hi, has anyone experience problems with retriving wrong metadata info from store procedure? I have a stored procedure (SP) that joins three tables, I used SSIS OLD DB Source calling the SP, but the returned data type mapping is wrong and I can't seem to overwrite them with the correct on, t...more >>

Hi, we use SQL Server 2005. Every 3 seconds we get a string via TCP/IP which data have to be stored in our database. Is it possible to read the data directly from the port to the database or do we have to program a listener which gets the data and pushes them into our table? Sorry for ...more >>

Dear all, Is that DTS default Set Identity Insert off in SQL 2005? How can I start the DTS with default Set Identity Insert on? Ivan ...more >>

Hi, As a part of dts conversion, I need to convert tables between MS SQL databases. The sourse database, however, is not available at the time of running the script, so I have back it up in some way. At the moment, I am using dts to trasform those tables into text files, and load them at the ...more >>

Hello All, I was trying to create a Send Mail task.The SQLServer service account runs off of its own account. The SQLServer Agent also runs off of its own account. I login with my network login id (Windows Authentication). When I login to my workstation and create a DTS package with a send...more >>

I inherited some code that executes a DTS package that pulls from a site in Australia. Works great, unless someone in Oz decides to turn off our access, in which case login fails. When we run it from inside Enterprise Manager, we are dutifully informed what happened. When we run it from a...more >>

Hello all, I know others have posted for this topic (and i've read them all....), but haven't read a surefire answer. So please bare with me.... I am trying to execute a DTS package in SQL 2000 on a server from a remote client without SQL tools installed. I'm trying to get this to run wit...more >>

I would like to import a DTS package that has been saved as a BAS module into MSDE from within a VBA script. Is this possible? Thanks for your time. Craig Buchanan ...more >>

I am just about to put my first ssis package into production. Not only is it my first, its the first one where I am working. SSIS gives us choices about locations in which to store the packages. Would someone care to discuss the pros and cons of each? Any "war stories" of your experience are a...more >>

Running SS2K here...I have a DTS package that is scheduled to run as a Job under the SQL Server Agent. My job needs to pull data from a non-SQL server database every day and once (only) each day. I have a pre-set time when I can start to "poll" the source database to see if the data is ready t...more >>

Hi - I'm trying to import a file that has multiple record types in random order into various tables. For example: Record Type A Record Type B Record Type A Record Type C Each type has different fields and is of a different length, and obviously requires different logic to parse and inse...more >>