I have a flat file with customer information that looks like: Name, Suburb, Postcode John, Adelaide, 5000 Mary, Adelaide, 5000 Mark, Melbourne, 3000 Elizabeth, Sydney, 2000 George, Adelaide 5000 Henry, Melbourne, 3000 I need to add the Suburb and Postcode to a related table...more >>

I'm trying to import user views from db to another. When I use the copy table and views option and select only the views it appears to copy fine and says so but the views don't show up in the destination. When I use copy objects and select only the view it generates an error that states "There...more >>

Hi all, i have a dts package that exports to an excel file, but the name of the excel file is defined at runtime. this is not a problem as i define the destination table for the excel file in the data transformation task before running the package. is there a way using vbscript to defi...more >>

I have a file with fixed-length fields and a table with matching length columns. I'm trying to use DTS to import the file but find that if a record in the file is a bit short, DTS doesn't import it. For example, if I had fields of widths: FirstName 5 LastName 4 Company 10 the file: J...more >>

Hi, I am having an issue with DTS's on a SQL Server installation on a server that is in a DMZ. I can create a DTS no problem and add whatever elements that are needed and can save it OK. However when I go to open the DTS package again from Local Packages it fails to open. The error message...more >>

Fellow SSIS Users: I have a package that (among other things) does these steps: 1) Backup a database. Let's call it: DatabaseStage 2) Run stored procedures which change DatabaseStage 3) Kill connections to DatabaseStage (so that the next step will work) 4) Restore DatabaseStage 5) Run store...more >>

OK, I'v created a new Integration Services Project. I then added a Data Flow task to the Control Flow surface, and attempted to rename the Data Flow Task and I get an error: TITLE: Microsoft Visual Studio ------------------------------ Could not get value for property '6422d93b-a711-4267-9...more >>

What data is SSIS expecting to be stored in an environment variable when you opt for indirect SQL Server package configuration? The documentation on this is....incredibly sparse....more >>

Hello, Guru's: I am new to the world of DTS; I am learning different methods of data import/export, using various tools. I do know and feel that data should be cleansed and scrubbed before intiating data transfer, using the various methods. Now, are there system stored procedures that one c...more >>

I created a config type 'Parent package variable' (ParentPackKey) in a parent package and successfully passed it to a child package. I successfully performed an INSERT into a table. The correct ParentPackKey appeared in the table. However this error appears: "Validation error. Update <<Pa...more >>

Suppose my server name is MyServer001, but in order to access it from my remote vpn, I need to refer to it in the package as MyServer001.ca.ge.org. Will the package still run properly if scheduled? (being that the server doesn't need to refer to it with the ca.ge.org when run locally?) And...more >>

Hi - I'm new to SSIS in SQL Server 2005. I've spent hours reading documentation, viewing webcasts, etc., but my scenario seems to be pretty unusual, so the example code I've been finding has not helped. Perhaps I'm not looking in the right place, of course...but I would appreciate any and ...more >>

Hi, I have a flat file that I'm sending through a derived column transform, and into sql server. There is a column in my flat file that returns null values. In this case, I'd like to send a NULL value to SQL server instead. I started making a derived column as follows: UnitNumber == ""...more >>

I want to import access database to SQL server daily. Every day the source i.e. access database filename (.mdb filename) is different. How to design a DTS package which will dynamically find the .mdb file and import it into SQL? Thanks in advance.. ...more >>

I have a DTS Package that drops local tables, recreates them and then pulls new data from a database on a different server. At first I couldn't get the package to run as a scheduled job at all I read KB article 269074 and made sure the job would run on the server and that SQL server agent runs ...more >>

Doing a .csv import and getting this message at row 1,167,918. I see from googling the archives of this newsgroup that people often see this error but that it may actually occur a long ways away from the reported row. I've got a lot of rows. Any great ideas as to how to search for it? ...more >>

When I copy/paste an existing package, it inherits all the IDs from the exisiting package. I generated a new ID on package level for the copied package (but other level objects still share the same ID ), then I made some modification on the new package, and let two packages run in parallel in...more >>

I want to use DTS Wizard to map columns between a source table and a destination table and then extract the sql statement created. For example, I want the insert sql statement from table Source to table Destination which I use DTS wizrad which columns from Source should insert into which colu...more >>

Hi, How do I transfer DTS package from one server to another.SQL2k---the fast way THanks,. ...more >>

Can you recommend a book on Integration services in sql server 2005? Thanks...more >>

We collect data daily from 300 branches via DTS. Each branch connects to our server and uploads their data into our server by running a DTS package that is on the server. They can do this, because each branch has the (free) MSDE database installed, which includes DTS.dll and this allows th...more >>

I am using an OEDB source in my Data Flow. My Sql Command is a complex sql batch logic instead of a single sql query, which looks like this: " SET NOCOUNT ON Declare @Table1 Table(GroupId Varchar(10) NOT NULL, GroupName Varchar(50) NOT NULL, TAT Int) INSERT INTO @Table1 (GroupId, GroupNa...more >>

Hello, I am using Transfer SQL Server Objects Task Manager to transfer tables. I am somewhat unsure as how to proceed. I want to replace tables that are in one database with tables from another database. If the table exist, the Transfer SQL Server Objects Task Manager works fine when I s...more >>

(SQL Server 2000, SP4) Hello all! I've got a DTS problem that's driving me batty: I have created a DTS package (structured storage) that uses two UDL connections: one using an MS-supplied OLE DB provider for SQL Server, the other using an Oracle-supplied OLE DB provider for Oracle. ...more >>

When I try to open my DTS Wizard in my program list under MS SQL Server/ import export wizard, I get the following error message "DTS Import/Export Wizard Error: GetSourcesRowset then in the box it says Class not registered. If I click OK, it brings me to the wizard, but the data sources in t...more >>

Hi, I have a SQL Task, that has two seperate "On Success" Workflows coming from it. I want to know if there is a way of setting my first "On Success" workflow to have priority over the second workflow. i.e. So One task runs before the other... I've looked at the RelativePriority Prope...more >>

I am using an LOEDB source in my Data Flow. My Sql Command is a complex sql batch logic instead of a single sql query, which looks like this: " SET NOCOUNT ON Declare @Table1 Table(GroupId Varchar(10) NOT NULL, GroupName Varchar(50) NOT NULL, TAT Int) INSERT INTO @Table1 (GroupId, GroupN...more >>

Hi, I'm using SSIS for the first time but I'm no novice about unicode and non-unicode. This time I really don't see why SSIS is bothering me with a DT_STR to DT_WSTR conversion problems. I simply need to insert a new column with Derived Column of datatype nvarchar(2000) based on 3 concate...more >>

Hi, I m running the SSIS package by scheduling it in a job. When the job is started, SSIS package is also started. But now we can able to delete that SSIS package when it is running Is there anyway to stop the deletion of package while it is running and How to know that SSIS package is r...more >>

Hi Everyone I am running a scheduled stored procedure that executes a package, this is run multiple times with different parameters. This runs for a few days and then I get an error LoadFromSQLServer failed, I get this message every time the stored procedure is run until I stop and restar...more >>

Exec SQL step retrieves field from table. Output is full result set, goes to global variable of object type. ForEach loop set for ForEach ADO Enumerator. ADO object source is the global object variable from above, "Rows in first table" selected. Variable at index 0 (the only field in the...more >>

Hi everyone: I'm making a DTS for SQL Server 2000 and I need to know if there is a way to set the Connection task Server property to something like 'local' or something like it so I don't have to change the Server property everytime I Install and run the DTS on a different server than the o...more >>

I have a data conversion which redirect truncated rows to a recordset. What in reality I would like to achieve is to "fail the component" after redirecting the rows. That is, I am insterested to know which rows are causing the truncation, but when this happens, I would like to roll back ...more >>

Hi all, I have the following situation: I want to import a MySQL Database into a SQL Server 2005 database. I have the structures yet created in the SQL Server database. So now I am doing an import table by table. It is all the time the same cause my SQL-command is always "select * from ...."....more >>

Hi, I want to use dynamic properties task to set the valuesfor the global variables in SSIS 2005 In SQL 2000 this task is named "dynamic properties task". I can't found this task in SSIS 2005 enterprise or standard. Is there elsewhere in SQL Server 2005 ? The migration task from DTS...more >>

Hi, I am seeing some basic problems with SQL 2005 Import Data feature. We have some text files that needs to be imported into SQL Tables. Using SQL 2000 we were able to import the files without problems but with 2005 it does not work the same way. For example String Identifier does not iden...more >>

My Execute SQL task is set to use a query that retrieves customer numbers from a table: SELECT custID as thecustid FROM custTable WHERE [criteria] The result set is set to “Full Result Set”. On the Result Set tab, I have Result Name thecustid mapped to User::g_custID, which is a globa...more >>

Hi I'm using SSIS to import data from Excel files into a SQL 2005 database. What I've noticed is that sometimes it inserts NULL's where there should be data (I am doing a straight insert into holding tables) For example, I have a column for the version of a software entry in the excel fi...more >>

I realize that DTS isn't supported in 2005 Express. Is it possible to use the DTS facility on an existing SQL Server 2000 installation in order to push data to the Express installation? Many thanks - ...more >>

Greetings, I am trying to convert some data from an Excel spreadsheet into a format suitable for a data warehouse. Of the many steps required, one concerns a pivot of the Excel data. So I am trying to use the Pivot Transform, but without getting the results I am expecting. There are fi...more >>

I have an SSIS package that imports data from an MS Access database. I have it running inside a job with a single step. If I manually run the job, it will succeed only if I'm logged into the SQL Server box with my network user account (note that I don't need to be logged into SQL Server, just ...more >>

Hi, I have a dts package that is scheduled to run at 9am and have the dts log files that show it running at that time. When i right click on the package and click on 'schedule package' and then input a different time, the package does not seem to run at this time - nothing appears in the...more >>