Hi, How can I execute a DTS Package and send parameters to it . The execution must be performed via TSQL commands, not from a client app (e.g from a job). Thanks in advance, Leila ...more >>

Hi, Thanks for your replies. I have a query related to passing parameter to a stored procedure in a DTS package. The code below is whatI am using. Basically, the code does not seem to be picking up the 'EndDate' parameter that I am passing to the 'usp_PaymentExt' SP. Could someone please h...more >>

We have a database server (DWPROD) running Windows 2000 with SQL Server 2000(sp3) and mdac 2.7 sp1 refresh. We are migrating to a new database server (DWSQL) with Windows 2003, SLQ Server 2000 (sp3) and mdac 2.8. I have been unable to open dts packages (either structured storage files or l...more >>

Can a DTS package be added to a server via the command line using OSQL? Thanks in advance John...more >>

Is it possible to write and compile my own class libray in c#, compile it and then reference it in a script task in SSIS? How would I go ahead and do this? Thanks ...more >>

Hi, I am trying to create a DTS package wherein the data from the sql server is transfered to a text file. I am using the Transform Data Task to transfer the data.In Transform Data task properties, I build the query and able to preview the data but when i click OK in the Transform Data ...more >>

I'm loading data from a flat file into an Sql Server table ... using "Flat File Source" and "OleDb Destination" controls. In between I'm using a number of derived column controls to add and transform data from the flat file. I need to derive a payment_type value depending on the contents o...more >>

Hi, I have a ASP (classic) wepage the running a SQL Server 2000 DTS package which creates a text file and drops it in a specified network folder. I need to know which user needs to be given write permissions on this folder so that they can drop the file in the folder once the DTS package is e...more >>

I have a DTS/ETL package that is running perfectly. The data from the data marts is currently imported into SAS/SPSS for cleaning and weighting. The SAS/SPSS jobs are kicked off manually. I want to be able to schedule these SAS/SPSS jobs so that they automatically execute after the DTS package...more >>

Hi, I have an SSIS ackage that I have setup to import multiple flat file sources. Each flat file source is different since the number of columns and formatting (tab or comma) vary from file source to file source. Now, in a perfect world this would work assuming a file is always true to its ...more >>

I have a problem using DTS (SQL Server 2000) to export to a text file. If I try to create the DTS using the designer if I am exporting from a table with more than 16 columns when I come to define the columns in the text file Enterprise Manager consistantly crashes. The steps to reproduce are a...more >>

Hi! this is my case. I have an ini-file containing info about server location, password and database name. My "dynamic properties task" reads from the ini-file and the specified values. My next step is a SQL Execute task where I want to create a database based on the name from the ini-fi...more >>

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 >>

Hi Everyone: Somebody to executed two DTS in parallel? If the answer is affirmative it can say to me like, plisssss? Thanks. ...more >>

I'm working on converting some of my SQL 2000 DTS packages to SSIS packages. I'm looking for some example packages to help me figure out some things. Thanks, Scott<- ...more >>

I have issues concerning calculated cell's performance. If I create 12 calculated cells in a DTS, the retrieve takes 7 minutes When I delete those 12 calculated cells and I recreate 12 calculated cells with the calculated cells creation wizard on the same cube with the same MDX, the retrieve t...more >>

Hello, I am trying to make a dts pakage that will upload files from a directoy to a sql table. Pleases note that the text file is tab delimated. also the name of the file keeps changeing. Its like i should be able to go through all files in a certain folder and upload those files to sql tab...more >>

I have a schedule DTS package that I want to track during execution. I've looked in the "sysdtdpackagelog" table and see an entry in the table about my package. When are entries place in the this table? i.e. when the package completes execution or when the package starts and then updated whe...more >>

I am trying to figure out how to run a simple dos batch file after a step within a DTS package completes... For example: A DTS Package uses a FTP TASK to transfer a file. If successful then Execute a batch file on c: called cleanup.bat Any suggestions would be much appreciated......more >>

I re-created my DTS package in SQL Server 2005. I now execute the package using: [ Exec Master..xp_cmdshell 'DTExec /f C:\Data\packagename.dtsx' ] It is working fine however, is there another way of executing this package in SQL Server 2005 without having to go to xp_cmdshell and run DTExec? ...more >>