Hello, I am new to using DTS. I have a spreadsheet which contains a list of all companies traded on the NASDAQ. I need to populate a table with this data. I can save the spreadsheet to an appropriate format. My question is how best to quickly load this data into a table. The spread...more >>

I am trying to run a SSIS package (called "Parent") that calls another package (called "Child"). The packages are stored in SQL Server (MSDB database) and are called from a console app by the code below: Public Shared Function RunPackage(ByVal server As String, _ ByVal userName As ...more >>

Hello, I've the following error, when i try to execute one job that invoques one DTS that was migrated from SQL Server 2000 to my new dev instance of SQL 2K5, i cannot understand on how can i avoid the encrypted password because in all the steps of the package i dont have any password. Bu...more >>

I'm using SS 2005. I've got an SSIS package. I'm trying to write some data to an Excel Destination. It keeps appending to what is there, instead of overwriting. So, I'm trying to give it a fresh file each time to write to, i.e. empty except for the column headings. I delete all rows excep...more >>

I'm new to SSIS, and am not sure of the best way to handle this situation: My destination table will combine data from 2 different databases on the same server. My main source is a table in database A. I have a dataflow task that pulls in that data and performs a couple of lookups from the sam...more >>

Hi, I have create a basic package to process a cube, but am at a loss as to where I need to save it. I can not find the locations shown in the list in the scheduled task on the server. Why can I not choose any local folder on the server? If I could find where the maintenanace plans were...more >>

I have previously posted two messages in this forum with questions about the SSIS "Message Queue Task", which no one seems to know anything about. For weeks I have searched the internet for samples and documentation - with very little luck. I have written an ASP.NET application which write ...more >>

I have created a stored procedure to handle xml data. One of the inputs to this procedure is xmldata which is basically the contents of the xml in a file. Now I would like to create a sql server 2005 SSIS package that takes the xml files from the network and uses this SP. Should I have a file...more >>

I am using SSIS to import data from a SQL server database to an identical SQL server database. I get the following error on almost all my tables. It looks like it is complaining that I have duplicate keys, but the source database is identical with the same constraints. Duplicate keys are not...more >>

Hi All, can any one tell me how we can handle transaction in DTS. thanks in advance. ...more >>

Sorry, this is from 12 year DBA, DTS rookie. I have a DTS package whichis simple. SQL to check for records. If there are rows of data dump to text file and email. All works, however I need it not to email if the rowcount is 0. This is where I am stuck ...more >>

I am trying to create a dts package to copy a FoxPro 6 table to SQL 2000. I seem to be having problems with the datetime fields. The usual error is something like this: Insert Error, column 22('<column name>, DBTYPE_DBTIMESTAMP), status 6: Data overflow. Invalid character value for cast ...more >>

I want to see if I can do the following as an automated process: 1. I need to copy rows from sql server 2000 and paste them into excel worksheets. 2. Each of the 3 worksheets that contain data, also have an associated pivot table with them. Thus there are 3 detail woksheets and 3 pivot t...more >>

Hi, does anyone know whether there is an option in SSIS to insert only difference? For example, I have an appended txt file to insert. I have inserted the first part of data a while ago so I only want to insert the new records this time. thank you! ...more >>

I am wondering how does everyone handle the records if the key is not found in the lookup table? I am thinking two ways: 1. Distinct the raw data field first and insert to the lookup table if the key is missing before running lookup; 2. Run importing first and send those error records to a file....more >>