I have created a package that contains a script task that uses a connection manager. The name of the connection manager was specific to the data source and I want to make my package deployable, so I rightclick-renamed the connection manager to something more generic and stored the details in a...more >>

SQL2k I have a package that I would like to branch 1 of 2 ways, depending on the results of a step. My package works something like this: - determine the number of rows in a table. this is done by running a sql exec task and populating a global var. - based on the number of rows, I eith...more >>

I have 2 test machines in the same domain on my local network. using SSIS on machine A, I'm trying to import a database from machine B which is a sql server 2k database. both sql servers are registered using windows authentication. However, during the import process when prompted how to c...more >>

I'm trying to take a varchar field and convert it to numeric/decimal/float (not sure which is the best data type). I keep receiving an error on the conversion: Server: Msg 8114, Level 16, State 5, Line 4 Error converting data type varchar to numeric. This is the code I tried to use but see...more >>

Hello, I am using DROP TABLE and CREATE TABLE commands in a dts package when what I really need is to just use TRUNCATE TABLE command. I manually modified the DROP TABLE to TRUNCATE TABLE and saved the package. When I ran the package, it came back with " Error string: Invalid SQL sta...more >>

Hi, I have created a SSIS package that copy some tables from one SQL Server to another. If i run the package in Integration Services it runs OK. If i create a Job to run the package it gives me an error (The package execution failed. The step failed.) each time i try to run. Any idea? T...more >>

I need some help, I am new to Microsoft SQL Server 2005 Integration Services and I am having some problems running Reporting Services ExecutionLog Package in Integration Services. After setting up and running the package, I received this warning message : "Truncation may occur due to inserting ...more >>

I have a 3rd party application that stores its data in an Access .mdb file. I need to transfer this file to SQL Server several times during the day for some reports that are tied to other data on the SQL Server. I have set up a DTS job that does the following: 1. Removes the data from the e...more >>

Trying to convert a mySQL database to MSSQL. Using Import data in SQL Server 2000, it works fine, however I get no primary keys defined on any of the tables, am I missing something? Or is there a tool that would do this? Many thanks. ...more >>

OK I dont think I asked the right question. I am trying to bulk export data from SQL using T-SQL. Any ideas? The export needs to happen in a stored procedure that gets called at the beginning of the invoice run. Thanks Richard ...more >>

Hello, I have a DTS package that copies data from a sql server db to a visual fox pro file. The visual fox pro version we are using is very old (2.6a), and we actually use dbase 4 drivers to copy data to it. In the create table statement in the dts package, we define decimal variables as b...more >>

Hi I have developed a very simple package which copys a set of rows from 1 db to another. all works fine in the VS2005 BI and also can run the package.dtx from the desktop. But when I add this package to the the Jobs to schedule it to run, it fails on the first step. No reason why - ju...more >>

Hi, I'm trying to write a SSIS package to transfer data from multiple sources into a SQL database to use in our datawarehouse. I'm having speed issues with the Oracle data extract. I've tried using Microsoft's OLE DB provider, Oracle's OLEDB provider and also Microsoft's improved OLE DB p...more >>

Hi, Here, the scenario is: dimension members can be added/deleted on the fly. So depending on if any of the members are deleted from dimension table, I want to rebuild the dimension through DTS package. Is there any solution to this problem? Regards, Gayatri. ...more >>

Dear Everyone, I've problem with my SQL Server 2000. I've several DTS which have scheduled through SQL Server Job. All job successfully run, except 1 job. The job run very longer (62 hours). This problem occured since 6 days ago. It seems well before, with approximate finished in 6 minutes...more >>

Hi. I desgined a DTS which will load .XLS file which static file name. For instance, mydata.xls. I have a ASP.NET (vb.net) application which will allow user to "upload" the file from client machine to webserver. In the applicaiton, the uploaded file will be saved in the server as "mydata...more >>

Hi , What is the code to copy A.txt to another path and set it as A2005Feb20.txt ? I means that the file I copied I need to put "current date" to differentiate the file version ..Thanks -- Travis Tan...more >>

Hello, I don't know much about DTS, so I have a question: We have an SQL Server database where we have 18 DTS packages. As part of our disaster recovery plan we need to install these. Is there a way to do this by TSQL? Thanks, Ragnar ...more >>

SQL Server Enterprise Manager Recurring Job Schedule cannot run hourly I have tried a lot of things but cannot get this schedule to run every hour on the hour or every 10min How can I achive this? Example or link to example SBS2003 Enterprise edition SP3 TIA Sam ...more >>

I can make the BULK INSERT work with no problems. I need a way to bulk EXPORT data from a table to the server in a specified folder. What is the best way to do this? It has to be dynamic. The FROM table and the TO file name are supplied as parameters to whatever process ends up being the...more >>

I have: 1. A delimited text file with 2 columns (ID, Value) 2. DB table (ID, Value) I would like to create a Data Flow Task that: 1. Extracts the data from the text file 2. Compares Value from the text file using ID to bind with the DB table 3. UPDATES the non-matching (or changed)...more >>

I have an execute sql task , that only runs 1 sql statement, something along the lines of : Select * into dbo.tablename_old from dbo.tablename Is there a way for me to promote the rowcount info up to the package so it gets logged? I always get "Progress count in Step: 0" for this (since sql t...more >>

Hi All: I am a newbie at SQL, and I have a two-part question, that I am hoping you can help me with. Please bear with me. Original Issue: We have a non-MS-SQL database that exports data into many text files on a daily basis. We then use DTS jobs to import(append) the text files into MS ...more >>

I am converting a 2000 DTS script to SSIS and am having a problem in figuring out what approach to use in a specific task that I have. I previously did this with a transform data task. I am tring to copy data from an analysis service cube to sqlserver2005 using SSIS. As I understand it I s...more >>

I am trying to connect SSIS from the Management Studio, the connection is fine. Once i clicked on MSDB, it saying expanding the i am getting this errors, By the by our servers are cluster servers TITLE: Microsoft SQL Server Management Studio ------------------------------ Failed to r...more >>

Thanks ppl for your help. I actually need to create a DTS package runtime, add tasks to it (to convert text file to sql table) and validate the data in tables. Can anyone plz help me with runtime creation of package in C#.Net Thanks ...more >>

I am trying to connect to Oracle using ADO.NET / OLEDB connection in SSIS package, but the Oracle servers that we have here are not using the default port 1521, so how do I specify the port when using he ADO.NET / OLEDB Connection for Oracle. I have oracle client 9i installed on the box a...more >>

I'm using the Copy Database wizard and I'm getting failure due to a warning where a login is being copied but the login already exists. I get the message: The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs whe...more >>

Thanks all, Since, I am a rookie to this, can you give me a brief overview of the process I should follow right from importing the ..txt file , converting it into sql database and then validating it . I am using C#.Net at the front end and MS SQL server at the backend. Awa...more >>

Intalled SQL Server 2005 Developer on my PC and the Bussiness intelligence studio components for VS.net installed fine, except I don't see a template in there for Data Transformation Services (DTS) project. Is that no longer available or did I miss something on the install? And if the latter, ...more >>

All, I Get a wierd error after migrating all my DTS packages. I get an Execution Was Cancelled By User when running Inner DTS Packages. Yet when I run the Inner DTS packages on there own it all Works fine. I'm running SQL server 2000, SP3a. TIA...more >>

Hi, I have a package that I developed on my local machine and runs well. I run it through the command line on my production server the following way: D:\test\CMS_MoveContentToLive>dtexec /f D:\test\CMS_MoveContentToLive\CMSMoveIte mToLive.dtsx -de The -de option is because i changed th...more >>