Dear all I want to give administrators of a datawarehouse a possibility to have a look at the extracts of the source systems a SSIS Packages puts in a datawarehouse. I thought the best way would be to let the package generates an Raw file with the extract and write a .NET windows applic...more >>

We are planning to upgrade to SQL Server 2005. We use lots of DTS packages. I undestand that SQL Server 2005 can run DTS, but will I be able to maintain then (add new ones and update existing ones). If this is not possble, can someone recommend a way to get around this -- besides re-buildin...more >>

This may be really picky, but has anyone else just had it with the limited way in which you can position the contrainst arrows in BI Studio? I'm one of the biggest ssis fans out here, but I'd prefer to be able to make my arrows so they don't run through other steps. The only way they seem to l...more >>

Is there a way to read a system table to determine if a specific table has an identity column? Derek Hart ...more >>

I have the following code which will give me all the tables, but I will need to dynamically generate the select list and explicitly name the fields - here is the code I received in another post. I would be grateful if somebody could give me the information of how I could create the list of fie...more >>

Dear all In SSIS I want to write the error rows in the dataflow of a package to a row file. This works well. But if I have no errors, I do NOT want to create a raw file. How can I achieve this? Regards, Marc...more >>

I have a DTS package on the production, where it takes about 30mins to run successfully and produce many excel reports.But sometimes it stops after running for 4minutes and fails. The tasks written in the job if run mannually in the same sequece produce the correct output. I would like to i...more >>

Dear all, How do i grant a user select permissions for ALL possible sets of a database such as tables, views, stored procedures, assemblies, ...etc. Is there a way to grant that user all of those permissions in a simple way? Ihave been selecting table by table, view by view, ..etc. for a us...more >>

I want to copy a table of data from a source SQL Server to a destination SQL Server. The destination will be empty. The destination may not have some fields that the source has, but the source will have all the fields the destination has. DTS seems to want to name every field, but I want to...more >>

I want to copy all the data from one database to another. The newer database gets built with a script, and has all empty tables. The older database has all the data in it. The newer database will never remove tables or fields, and will only have new tables and/or fields. I want to turn off ...more >>

I've researched this issue for half a day now and I can not find the answer. We are launching numerous DTS pages from our current ASP web page. We simply create a DTS.Package object, associate it correctly and execute it. We are looking at updating to SQL 2005 and I'm trying to find out the e...more >>

I'm trying to extract data from a table based on Today's Date using DTS. This job will run nightly and pull data from the five fields mentioned for that day and move it to another sql database on a different server. I'm not a programmer and am having difficulty getting it to grab the data. ...more >>

Trying to import FoxPro files from version 8. I think I've got the latest oledb drivers, but they don't seem to work with SSIS. I am able to use them just fine with DTS. Tried importing database file and individual files from the directory. Neither one works. Keep getting a "Parameter is Inco...more >>

Hi, I moved one of my DTS package from development to production using 'DTSBackup 2000' successfully and it also executes fine. However, when I schedule it to run as a scheduled task, it fails with the following error: Executed as user: TDBFG\SQL-SERVICE. DTSRun: Loading... DTSRun: E...more >>

Dear all, I am writing a SSIS package which own an ActiveX Script Task (Visual Basic Script code incide) but I haven’t idea or any clue about how do I set up global variables. Something like that: Dim strIdioma strIdioma = DTSGlobalVariables("strIdioma").Value … property “Scrip...more >>

Hi , I created a package in SQL Server and use VB6 to run the package. This package consist of a file transfer (excel) from local server C:\ drive and load the data into the database. It looks well when I run manually. When I run the package in VB on my PC , the package failed to run...more >>

Hi, I am trying to load an excel file into a table in mssql and was having problems. My excel file is in the following format: ID Name TermDate 1 JB '01/25/2006' 2 Jake ' ---' 3 Smith '05/28/2006' 4 Halal ' ---' ...more >>

Trying to upload some data from our SQL Server to our AS/400 via a DTS package and am receiving an error I have not encountered nor even seen before: "The number of failing rows exceeds the maximum specified. Query cannot be updated because it contains no searchable columns to use as a key...more >>

Hi, I'm trying to transfer a database from one SQL 2005 server to another, but it fails with the following error: OnError,APER,NT AUTHORITY\SYSTEM,XENON_SQL2005_APER_Transfer Objects Task,{77F5D8BC-6D0E-466E-B3D9-BF8BAF4649E0},{3AB546FC-9257-438F-A969-A3E81BD1356C},02/05/2006 11:35:09,02...more >>

I assumed I knew the answer but apparently not. When I execute a package from my w/station (using Enterprise Manager) and open the Task Manager I see the mmc.exe running at upwards of 97% on my w/station cpu (also causing a slowdown of other applications on my w/station). I had previously thou...more >>

I'm getting a really confusing error when trying to run a DTS package. = What I'm trying to do is truncate an existing table on the destination = server and then copy specified rows (via SQL) from the source server. The really odd thing is, there are 3 tables involved and I constructed = all ...more >>

I want a DTS packag ethat will query a table and, based on a couple of = conditions, create several text files. For instance, let's say that the fields in the table are Date, Server = Name and User. I want to create a separate text file for each = server/date combination that lists all the us...more >>

In honor of the help that I have recently received in this group, I thought I would post the answer to a problem that had been plaguing me for a couple of weeks in the hopes that this posting will help someone else. Like many people, I am in the middle of upgrading from SQL Server 2000 to 2...more >>

I am trying to figure out how to cause the JobStep to Error on a condition so i can have it retry later. The JobStep is written in ActiveX, VBScript. The JobStep basically does this: Dim oFso, oFolder, bErr Set bErr = 0 Set oFso = CreateObject("Scripting.FileSystemObject") Set oFold...more >>

I have a DTS package with about 20 steps. It's all simple tasks. Nothing elaborate. I'm working with 2 remote shared SQL servers. SQLA and SQLB The DTS package is saved on: SQLB The package empties 4 tables on SQLA (DELETE FROM tasks) Then populates those tables with a bit of data grooming. La...more >>

Hi, I have just started working with SSIS and to say I find it complicated is an understatemnet but from what I have read a lot of other people are having the same troubles, all I want to do is transfer some data from a Tab delimited file into a sql table which using DTS was nice, quick an...more >>

i have a dtsx package that runs fine from the the bus intelligence studio and runs fine from within SQL environment when run manually. however, when i try to shedule it via SQL Server Agent it fails. looks like it is trying to run it as server\SYSTEM which is probably why it is failing. ...more >>

I need to read the connection manager type from an SSIS Package object. It shows the connection manager type in design time, but when I look = for it at runtime, it is not there. I need to reset paths on connection at runtime. and need to know what = type of connection I've got.. Hel...more >>

I have a flat text file that is an exported data dump. It unfortunately has 5 tables inside of it and no way to modify the how the data is given to me. Each different table starts with an "!" and the table name. Comment lines are ";" and data is delimited with ":" For example data would loo...more >>