Hi, Does anyone know how to make this simple SQL query using a SSIS Data Flow Destination Task? IF NOT EXISTS (SELECT * FROM Table WHERE Username = @Username) BEGIN INSERT table(Username, Firstname, Lastname) VALUES (@Username, @Firstname, @Lastname) END I have tried both the OLE DB De...more >>

Hi, I'm new to sql... I want to transfer data stored in an MS Access database into SQL2000. When the process is complete I find that the dts process does not: a. convert autonumber fields into identity(1,1) columns. b. set default values for columns I can use enterprise manager to edit t...more >>

We've got DTS running to duplicate our data from our main Oracle server to our website MSSQL database server. Some of our jobs run as frequently as a 10 minute interval and 99% of the time it works great. These little jobs run quick (about 2 seconds long). Sometimes however, the jobs seem to ...more >>

Hi, I have set IMEX=1 and HDR=NO. I am referencing the excel columns as F1, F2, etc... The problem is sometimes in the excel files, not all the columns referenced containes data. Thus I got the following error "No Value Given For One Or More required Parameter" when the ExpandedColumnCount ...more >>

I am using an Excel connection in my DTS package. After running the package in DTS Designer, I tried to open the Excel file using the Excel application. I get a message saying "Excel can't access <filename>". Any ideas on what caused the error would be appreciated. ...more >>

Hello, I am trying to set up my first sql 2005 Integrations Services package and am having a problem. My package is set up to: 1.) Run two separate SQL queries to clear some SQL 2005 data tables. 2.) Run a data flow which copies data from an Microsoft Office Access database on a netwo...more >>

Hi, I want to know the purpose and use of Data Source Views in Packages. Is there some way to export data from the data source view to sql server table. Thanks, Imran....more >>

I need to backup my CRM databases to another SQL server 2000 computer using the copy wizard but i received this error message " there are 2 active connections to the database" so the database was not copied to the second server. Some of the databases were also referred to as replicated data...more >>

Hi, could neone plz guide me as how to get the exact error when job/step fails. My package runs fine in development but fails when executed as a job. The error gives no specific info. I want to enable log so that atleast I get a proper error info to work on. Error : Executed as user: myd...more >>

Hi, We have a scenario where in we have to import data from an excel and dump the data to the DB(SQL 2005). To give u a brief Assume you have this table in the DB EmployeeTB Columns are EmpID,(int,identity) CompanyID(int) Name(varchar) Active(bit) The rows in the Excel file are like thi...more >>

Hello members, i want to use DTS in sQL Server 2005 beta version. In the Buisness Intelligence Studion i am not getting the template for Data Transformation Service. So how i can make packages in SQL Server 2005 using BI. Also i want to know how to use SQL Server Management studio for crea...more >>

I have a lot of trouble in porting the data from iSeries /(AS/400) into SQL 2005. In the SQL 2005 installation, it mentioned the OLE DB Provider for DB2 from Microsoft. Does anyone know where can I find the OLE DB Provider for DB2? ...more >>

Hello: I have one table that for each row I have to insert various record in several table, and I want to in dts. This is example table1 -field1 -field2 -field3 I would like for each record or row of this table: insert table2 somevalue, field1, field2 insert table3 field1, fie...more >>

Hi all.... I'm programming a DTS package that transfers data from an Oracle database to a SQL Server 2000 table. Since some queries are heavy, I have separated them in more queries that I execute one after the other. This is the execution scenario. All steps are Transform Data Tasks fro...more >>

I just created a very simple SSIS package to retreive data from Oracle to SQL Server. I saved this package as a single file. I double click to open this package to execute, it works fine with no error. And then I created a new job in Management Studio for this package. I set the owner to b...more >>

Hi there, My question here is what is the best practice -- I have about 5 servers with different infomation such as Datasource,UID,initial catalog,password this infomation i am using Dynamic task to fetch this information at run-time to transport to a destination server,Is this a best practic...more >>

Hi, I try to import a text file (CSV formatted) into a table in SQL Server 2000. For doing so, I am using a DTS package. The problem is that all text fields are truncated after 255 characters. I spended a good part of last night trying to find a solution, unsuccessfully! :( I am using SQ...more >>

Hi there, Just a query , how do we use Dynamic Task properties to read from an .ini file all the server datasource, uid,initial catalog and password from multiple servers as sources to a single destination servers....more >>

err... how do I view all ssis packages in sql management studio. I know the packages are there but is there a way to view them in the sql 2005 object browser?? thanks ...more >>

Hello. We recently upgraded out cleint's SQL Server box by installing brand new hard drives. Before we took out the old hard drives, I saved all DTS packages by file format (and of course made a back up of the database). After placing the new hard drives and installing the Enterprise M...more >>

A while back we found a Stored procedure on the net from MS that allowed you to send mail. We used this SP in a few of our DTS jobs. We have a Table that we enter in all of the emails that we want the system to generate for us. Then loop through all the non-processed emails and send the inf...more >>

In setting up a datawarehouse we're starting out with about 30 tables that need to be transfered. What I would LIKE to do is build a lookup table that holds the Names of those tables in their source, and the names we are going to use in the warehouse, then cycle through that list with a ForEach...more >>

I have a series of excel file with several worksheets in each file. The data that I need to import starts on row 8. Is there a way to get the DTS to ignore the first 7 rows of data as they are just header data. Also how can I pull the info from each workbook? ...more >>

We are trying to use Meta Data Services as a way to help document our DTS packages. We can save the DTS as a Meta Data Services Package, and we can see it in the Meta Data Services group (under DTS). However, when we try to open the 'Meta Data' group (under DTS), we get the following error...more >>

>> how to call the scalar-valued user defined function from within an SSIS >> derived column expression << I'm setting up an SSIS package that needs to transform latituded / longitude degrees, minutes, seconds values to the decimal equivalent. I've created a UDF to manage the actual transf...more >>

hi i have a text file with firstrow 03 ex 12345678912345678912xxxxx9999988888 fifth row 04 gh 23564789122334788933zzzzz3333388888822222555556666688888 how to delimited my file? if i used fixed lengths, it is only taking first row number of charecters because each line has "return key...more >>

Hello! Using Dynamic Properties Task, how do I change db name at runtime using global variable? My DTS pkg has two connections. All I am trying is to change the db name at run time for a target connection. So, I set up a global variable "gvDB" on "Catalog" (is this correct?) on the target con...more >>

I need to develop a program to do large data ETL, however, the raw data, which is in Access mdb file, need to be checked and modified against the existed data in the database. - Any better way than loading the raw data into SQL Server? - Is DTS (or SSIS/ETL, I will use SQL Server 2005) st...more >>

Is it possible to skip a given number of records in the source dataset, not just one at a time? We are trying to replicate some old data in dbf tables. The only changes made to these tables from the source application are the appending of records, but there is no clear primary key. I want to...more >>

SqlPros, When debugging a dts package I get thrown into Microsoft Visual InterDev 6.0 as part of the Visual Studio 6. It throws up a line indicating where I'm screwing up. However, when I close the debugger I also lose EM. Is it possible to prevent EM from closing? If so, how? Thanks Dbdut...more >>

Hi I have created a DTS as part of my month end process to import 40 different csv files from our various sales offices. Each file contains the account no and purchase information for the entire month. eg 13245, box1, box5, box4 45897, box9, box3, box5, box2 98765, box1 The maximum n...more >>