Hi... I hope if any one could shed light on my problem we had a hardware crash on our Database server (sql server 2000) and then Installed a fresh sql server 2000 installation and restored my database. But when I tried to restore the msdb file..it is not allowing me to restore the files ...more >>

Hi. I created a SSIS package using the Copy Database Wizard. The package copies four tables from a SQL 2000 server to a 2005 database on another box. (BTW, I installed the Business Intel Dev Studio on my local workstation.) So on the Data Flow tab in the package, there are four OLE DB sourc...more >>

Hi everyone, I tried to schedule a DTS package. I right click on the package and select "Schedule Package." I filled in the job frequence as occuring daily every 20 minutes. Then I clicked "OK." Well, when I opened the "Schedule Package" window again, none of the values I entered was sa...more >>

I get the following error when I try to parse the following ActiveX Script in a DTS package: Error Description: Error Code 0 Error Source=Microsoft VBScript Compilation Error Error Description: Syntax Error Error on Line 20 (Note that it doesn't state exactly what the syntax error is - it...more >>

Hello All, I have a list of topics/ questions I require help in understanding. Can we make an .exe file of the projects? How do we install the project at a customer site? How to move the projects between different drives( From c: to d: or e:) How do we move or install SSIS jobs on a produc...more >>

Hi All, Can temp tables(#) be used in DTS? If not, can you suggest something? I can't make it with one select. Thanks. Kolos...more >>

Can some one tell me what is domain data and where to read about it? thanks...more >>

I want to create a DTS package that will run several times a day, to check on the availability of remote SQL servers at customer sites. In the package I create a text file with the IP address, database name, User ID & password for each remote server. I read all of this into a ActiveX Script Ta...more >>

I have a SSIS package that loads the contents of a worksheet in an Excel document into a table. Simple process; 1) Extract from Excel using Excel Connection Manager 2) Insert into SQL2005 Database Table using OLEDB Connection Manager. I am using ExcryptSensitiveWithPassword and have set a...more >>

Hi all I can not find dtsrun on my 64 bit sql server (2000, sp4). Any idea why?? Thanks Rea...more >>

Hi, I am a complete Newbie to DTS, & while I'm currently educating myself with books, there are questions which I cannot find in any. Yet. I recently exported a table to an excel file using the wizard. It created an SQL script which included an ORDER BY clause, though I needed to delete t...more >>

Hi there, I have an activex script which loads up an xml file over http and transforms the results into a table held on the database. I'm not sure of all the technical nitty gritty (neither are the admins..) so hopefully someone here can help with my problem.. The problem is, I would like...more >>

What is the best way to use SSIS to UPDATE a record(s) in an oltp environment. No update tranform exists (unless mistaken) - will test a delete then insert but this seems extreme and seems can cause serious contention. Any ideas? tia, chris...more >>

Hi, I ran the scripts posted by Microsoft and I have received errors like the ones below, can someone povide some hints? Thanks ================================================ Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\Documents and S...more >>

I need to import a flat file as follows: Column1,Column2,Column3 1,2,3 4,5,6 (snip) 123,456,789 Downloaded from www.abcdef.com on 02/28/2007. Total1: 12344556 Total2: 234523 Total3: 56456 Copyright 2004-2007 by ABCDEF Group LLC. All Rights Reserved. The last line is some kind of sig...more >>

Hi, I'm transfering data from a MySQL to MSSQL 2005 server. all working but it takes forever ... its like its making some odd loops or so ... 700.000 rows transfered ... and thats all there is ... but it just keeps loading ... Using a ODBC connection to get the data from source, and sql ...more >>

Hey everyone, I am trying to download a directory via FTP and then import all the tables to a DB. The number of files and their names are unknown. I would probably need some technique to perform a directory listing. ( On the remote directory or its local copy). Do you know how this could b...more >>

Hi If I copy an MDF file, will this copy the DTS packages too? Kind regards Ricky ...more >>

I have never used SQL2k5 before and I have an urgent need to move a high volume of records between two sql2k5 dbs on the same server. I currently have a process using transactions in stored procs but it is way to slow to make a deadline. Can anyone help me or recommend a consultant available...more >>

SQL 2k, sp4 On one server, I have multiple environments, with dbs named accordingly; dev, qa and stage. I've created a DTS package that points to the dev db and I need to copy it to point to the qa db. My challenge is moving the DTS package that has transformation tasks. Is there an easy...more >>

All - I'm running into an issue where I'm trying to send a message using VB ActiveX script on SQL 2000. I have compiled the script and the package runs with no errors. However, I never receive any messages. I've verified that we can relay messages off of our SMTP server, but I'm stuck with...more >>

Error: 0xC02020A1 at Data Flow Task, Source -fileyouwantedtoload [1]: Data conversion failed. The data conversion for column "email" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.". Which code page will accept thos...more >>

Please tell me how to tell SSIS that I don't want to stop loading data if a field is truncated. It is much more important to get the good rows loaded than to stop for a bad row or two. I had this working before but I detoured to Reporting Services for a few weeks and now I have to be retraine...more >>

I need to prevent certain records from moving from the source to the target based on values in certain fields. I have a transformation that copies records from one database (not SQL server) to a SQL Server table. I connect to the source database using that provider's ODBC driver. The ta...more >>

Can run a package on windows services? As a package which download files from ftp, this package is running another machine from sql server. Is it possible to run this package on windows services? ...more >>

As the security reasons, our company have a set of packages (ftp, mail, network and etc. related tasks). We want to set an another server which only run as SSIS server. Is it possible? Is SSIS Server must run on the same Database Server? How to setup a SSIS server without database server? ...more >>

Here is the description of the strange problem I encounter: One XML Source node has about 20 SQL Server Destination sub nodes. It works well if all the table used in the SQL Server Destination don't have a primary key. Once I add the primary key in those tables, the package will fail with e...more >>

I'm trying to add a SQL Agent proxy for an SSIS package authentication on to an AS/400 IFS network share. I added the credential, but when I try to add that credential to a proxy, I receive the error message stating that the credential is not a Windows login. I need to authenticate a SSIS file...more >>

Hi, I wonder if anybody can please help. I am using SQL 2005 and I have generated a data flow which has a OLE DB Source which is retrieving a list of Ids. I then need to call another SP (with 2 output params) passing in the ID from the previous step. I have managed to execute the second SP ...more >>

Chicos cuando intento ejecutar un paquete SSIS me tira el siguiente error, tienen idea de porque puede ser. Aparecio de un día para el otro. Saludos y gracias. Javier El error: Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException was unhandled by user code HelpLink="#-1073672184" M...more >>

I am new to the notion of SSIS. I have a need to copy data from one server to another and also some queries need to do a join between tables living on separate servers. My client said that i need to use SSIS instead of Linked Servers on his way out of town for vacation. Maybe this question is ...more >>

Is there a way to bulk insert data from a file to a table without having to previously create the table? Thx, Hugo Figueira...more >>

Hi I'm using SSIS and need to import an flat file with data rows consisting of 32 fields pipe delimited. At the bottom of the file is the trailer record which only consists of 4 fields. When I import the file into a staging SQL table the trailer record is omitted as a 'partial row'. Is there...more >>