Hi folks, I have two tables CurrentNews and HistoricNews when a news item is created it is inserted into CurrentNews it is assigned a storyID (ST071) which it maintains through its life cycle. The story then gets reviewed and the reviewed column is set to true it is also given a version number...more >>

I have several DTS packages whose connection database is the test database. Is there some code I could write to go through all of them and change the database to the production db? If so, could you give me an idea of how to do it? Thanks. ...more >>

I using the DTS to transfer data from A server to B server , after that i make the schedule fot that DTS to run every 30 min. how i can check it whether DTS run successfully or failed?...more >>

I created an SSIS package in sql 2005 the package copy tables from Access database to oracle. the Access database is in a shared folder on a remote server accessible to account "account1". I published the package on the SQL server with "Package Protection Level" set to "Rely on server storag...more >>

Good Afternoon All, I'm compiling a list of reasons to justify the upgrade to SSIS from DTS. Below are the few reasons I've come up with during the limited time I've had to think about it. I would appreciate input from the group as well. 1) SSIS packages will migrate to future versions of...more >>

Hello, I created an SSIS package in SQL Server 2005 using theImport\Export wizard and stored the package in SQL Server. The package is scheduled and everything runs fine. Is there a way to go back and modify or at least view the package when it is stored this way. I've read some articles...more >>

I have set up a simple SSIS package to loop through several Excel spreadsheets located in a specific folder and followed the instructions in the MSDN publication 345182 - How to: Loop through Excel Files and Tables. The instructions lead to a corrupt package with the following error message ...more >>

Iv used the DTS wizard to copy data from one table to another on a different server suing a query Now I want to delete the data in table on the target server, I have added an Execute SQL Task but it runs after the copy. I need it to always ruun before the copy. How do I define the order? Than...more >>

Hi, Hoping someone could help me convert this data... ID Size 60203 M 60203 L 60203 XXL 30020 10 30020 8 ....into this... ID Size 60203 M,L,XXL 30020 10,8 Any help would be greatly appreciated. Thx, EightBall ...more >>

As the security requirements, We have a ftp download package which must run on another PC from SQL Server, When I deploy a package to client, run it using "dtexec". The error is display "The task "XXX" cannot run on this edition of Integration Services. It requires a higher level edition." ...more >>

Hey, I am an old timer with DTS now coming into SSIS. in DTS, the packages were stored on the server. it was easy to browse and edit them. now, I create a SSIS project, what i end up with is a *.dtsx file, right? and so, the packages are... just to be scattered around on the hard disk? not 'ins...more >>

Hi: I've written new SSIS packages to do what DTS packages did and the performance I'd say is about 20 times slower. In this package, I have a loop that loops through different servers based on server entries in a SQL database. Each loop pumps 10 tables. The source query is set by a variable ...more >>

Hi, I have to construct on Excel a worksheet, where users can write data on table. When they finish, they have to press a button. This button is calling a SSIS package on the server. What is the best way to proceed if i have many users? Thanks...more >>

How do you use DTS packages to create Header and Footer Records and incorporate onto a Fixed-Width Text File? So, in the Text file it will be in the order of Header record, Detail data records, and Footer/Trailer Record. Please help!...more >>

Hi: I need to turn off validation and I've seen some threads saying this is not possible but my situation has a twist. A customer needs the package to connect to different modem dialup connections to connect to different servers (they use dialup for security reasons). We have written two VB...more >>

Hi, Is there a way to remove an existing DTS package using VBScript. Thanks Saps ...more >>

Hi, I posted a message yesterday but do not see it on the newgroup yet so posting it again though with modification. My issue was I wanted to export selective rows from a SQL table and I was exporting it to a text file. Till here it's fine. The issue is when I want to import this txt file ba...more >>

DTS Active X script transformation properties box has ActiveX script text box on the right where you can change Active X script. SQL enterprise mgr is not showing this box anymore. It looks like that Active x script box is hidden somewhere but there is not maximize/minimize window. There is ...more >>

HI, I have a table in my SQL Server which has multiple rows. I was able to do a selective Import to Import only few rows to Access database. This is used by another program and the values in multiple columns are modified so I want these modified rows to be imported in SQL server back from the Ac...more >>

Hi, i have use a script to read the filenames from a for each file loop, so that i can perform certain tasks depending on the filename. does anyone know a good example that i can use? Simon ...more >>

The document referenced here http://www.microsoft.com/technet/solutionaccelerators/cits/interopmigration/unix/oracleunixtosql/or2sql08.mspx seems to imply that DTS can handle the transfer of CLOB fields from Oracle tables to text fields in a Sqlserver table. That is what I am trying to do, usi...more >>

I have been reading all morning looking for some answers as to how to open a migrated DTS package in BI Dev, Once I have migrated the Package from 2000 to 2005 and saved it in the MSDB Node. I can not find anything about opening from the SSIS MSDB node. CAN THIS BE DONE OR DO I NEED TO MIGRATE ...more >>

Hey all Is it possible to use vb6 programs, inside ssis programs/packages? These programs are now being executed from within activeX scripts in dts packages of sqlserver 2K. I want to continue on using them after upgrading to sql server 2005. Thanks alot Rea...more >>

It happens that if I run a SSIS package that copies data from one DB to another one it works OK but if I include that package in a scheduled job and run it manually it keeps saying "status: executing" and it never stops and it doesn't copy the data. Any help would be appreciated. Thanks Juan ...more >>