We have this issue and have found that we're not the only ones; here is a quick description from http://www.developerdotstar.com/community/node/334: This appears to be a bug. I can't get the debugger to stop on a line of code in a script task in an event handler. Strangely, if I set a break p...more >>

Within Enterprise Manager, I created a DTS package on our database server and it runs fine from computer 'A'. I then went to computer 'B' to run the same DTS package that is located on the same database server and only half of the DTS package runs successfully. 5 of my 10 steps get the messa...more >>

I was told the max column name length for SQL 2000 was 128. I am trying to create a DTS package to create a table and import data from an excel spreadsheet where some of the column names are over 64 but under 100 in length but when finished creating the table and importing the data, I look at...more >>

Hi, I am trying to setup an DTS for other region to run the loading job. From that user's machine, I can expplor to that directorty (I even use \\servername\path formoat) and open the file from command line or explore. But, when I try to open that DTS from Enterprise Manager at that user'...more >>

How can I programmatically get a count of exceptions after the data pump has finished? Thanks. Josh...more >>

When I try to use the rowcount component with SSIS I'm getting the following error message: Error at Data Flow Task [Row Count [205]]: The component "Row Count" (205) has forbidden the requested use of the input column with lineage ID 320 Any help would be appreciated. I have been trying ma...more >>

Hello there I have 2 servers. On server1 there is huge file with approx 100,000,000 records. On server3 database exist that should get the file. On server2 the dts with fast load that load the file from server1 and place it on Server3 on this method, which server do what, and which ...more >>

Hi all, I just ran into some problems trying to import different text files using the fixed field file format tool. Some of the files get their records truncated. That is if the first record is shorter than any other records in the file, Teh limit is set at the end of the first record inste...more >>

We have a 2 processor box that we'd like to install SQL 2005 on. The question is if we buy a single processor license, can we specify that integration services use only one processor? I know you can tell the database engine which processors to use, but I don't see anywhere in ssis to specify ...more >>

Hi, I was wondering if anyone knew a way to "preview" the results of a derived column in SSIS, similar to how you could preview a transform in DTS, without actually running the package. Thanks, Jeff ...more >>

We are having an issue where SSIS dumps during execution. It creates a crash dump file on the C:\Program Files\Microsoft SQL Server\90\Shared\ErrorDumps directory. Is there a way to read this dump or figure out why it is happening? It seems to be intermittent. It happens to me once in a w...more >>

It seems that there are only two books on SSIS The Rational Guide to Scripting SQL Server 2005 - BETA preview Professional SQL Server 2005 Integration Services by wrox Has anyone read these or any other ones out there? Any thoughts on which to get? I am very new to SSIS. Thanks ...more >>

Hi, I have a number of DTS's that are executed each morning via a Scheduled Job. Sometimes I find that the Job has got "stuck" on a Step (DTS) and does not "stop" until I manually stop the job myself through EM. Question is: How can I give my DTS's a Maximum Expected Run Time? e.g. Job...more >>

Hi all, I am a newbie to SSIS.Need a solution to couple of issues I am currently facing while developing ETL in SSIS 1) Under SSIS Package Folder I have defined mappings for 17 dimensions. 1st Dimension say Account has been Set up as a startup object. Now when I run the package ir runs only...more >>

Hello, I want to do some data transformation from one Database to another. My source DB is a MS SQLServer to which I can connect using OLEDB/SQLnative. My destination DB is a different type of database to which I can connect using Connection Manager. But for data transformation I need a dest...more >>

I am trying to construct a DTS task which will purge data that is more than X months old. So, I have a line in my query that looks like this: DELETE... WHERE [dateObj] < DATEADD (month,?,getDate()) I am trying to use a parameter so I can simply set a Global variable to determine the number of ...more >>

Hi all, I'm having a problem with my DTS packages when they are run as scheduled jobs. Basically, I have a DTS that calls other DTS packages from within. When run through enterprise manager, it all runs fine, all internal DTS packages are called and run successfully. However, when I set up a...more >>

Hi All, I'm pretty new to SQL Server 2005 and I'm wondering how to organize my business rules efficiently. I'm willing to create a Package with several Data Flow Task in my Control Flow, each Business Rule will be encapsulated in a Data Flow task. I guess this is possible in SSIS but I can'...more >>

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 >>