Hi Is there a reason, why I wouldn't be able to transfer/export data, derived from #Tables, in DTS? Incidentally, the final query in the SP, is made up of a UNION statement, should this also be a factor? Kind Regards Ricky ...more >>

SSIS Have 8 million record table that my lookup transform is using, problem seems the entire table is loaded into cache before the task begins. This of course brings my ssis server to it's knees. Played with 'Enable mem restriction' on Advanced tab, this just limits the rows brought into...more >>

I am having an issue with importing Excel Data into my SQL 2005 Table. My first issue was the inablity to import mixed data types. Upon research I implemented to the following: In SSIS added IMEX=1 to the datasource string Modified Registry TypedGuessRows=0 Formated Column as Text This res...more >>

I am experiencing a problem when using a .UDL file to change the SQL server / database settings. Scenario: ------------- I am importing data through the use of a Text File Connection. The text file name may vary. The destination is a SQL 2000 server. I have a process table defined which h...more >>

In SQL 2005 SSIS - how would I be able to load data into a oledb destination table only if the record does not exist? I could load the data into a staging table then call a sproc to do an insert using a left join where dest_table.pk is null, however I prefer not to manage a staging table ...more >>

Hello everyone, I'm a beginner in SSIS and DTS stuff. I have tried to make a package to - create flat file by executing a process - port it to data flow control where it delimits it and sents it to a database through oleDB connection. I'm using SQL Server 2005 Now I want to add on to thi...more >>

I have three Stored Procedures in DTS, in which first stored procedure is writing header row in destination file with four column. Second procedure writing data into the destination file with 15 columns Third stored procedure writing trailor row in data file with 4 column. problem is if i map ...more >>

SQL Mail Task - may run it by table trigger and send email with insert information? Is it possible? Are anywhere examples? ...more >>

Hello, I have tried to create configuration XML file and it is working, but when I am trying to put configuration parameters into SQL table I have nothing in configuration table. I am using configuration wizard and I have no errors. What Am I doing wrong? Regards Luk...more >>

What is the best way to load records into a destination only if the pk value does not exist? tia chris...more >>

I want to use an Execute SQL Task to load an email address list from a table and use the variable as the TO field in the Send Mail Task. Got the list into a variable okay, but can't figure out how to make it work as the TO in Send Mail. Any ideas?...more >>

I'm trying to set up a dts package that will eventually run automatically every day. A sql query gets the data and formats it as a string and dumps it into a text file. It also concatenates a variable (that is not part of any table) to the beginning of the string. When I run the query in sql it ...more >>

I have created a DTS package which transform rows of one table from sql server to oracle. What happens is while transforming rows, if there is a error occured at 2100 row, It still writes 2099 rows into oracle table..how can i avoid it ? I want to write everything or nothing ? Pls let me...more >>

I am importing a flat file consisting of variable length records terminated by {CR}{LF}. The record sizes vary between 65 bytes and 79 bytes (the last field is a variable length name field). I am reading in the record as a single field and then using a modification to the Transform VBScript to l...more >>

Hi, I am trying to use a File System Task within a SSIS package to copy and rename a group of files. When I run the package from the Visual Studio GUI it completes with no errors. However when I try to run it via a SQL Server 2005 Job it fails with the following message: The task "File Syste...more >>

I am trying to transfer some AS/400 data into SQL 2005 using ODBC connection and "DataReader Source". In "DataReader Source", a SQL command has to be specified, for example, "select a,b from tbl". I understand I have to use "Data Conversion" to convert the default "unicode"(AS/400) to "non-u...more >>

Hi, I've got a windows service that creates a DTS task at runtime to export data to textfiles. After a certain time the service always crashes and gives this error in the eventlog: faulting module dtspkg.dll, version 2000.80.2039.0, fault address 0x000beb9c. Any ideas what this error...more >>

Hi, I'm using a data flow task having a raw file destination in a foreach loop. Basically it looks like this: file system task: delete raw file foreach .... data flow task: import data to raw file The raw file destination's write option is set to 'create once'. According to t...more >>

i only want to know /e. can anyone tell me ? thanx ...more >>

I put a SQL Statement in my ActiveX and I can't get the correct Textbody to be sent. The Sql Statement returns a 1 in query analyzer. However, when the email is sent from this DTS Task, it returns "No Errors Found" and there are no file attachements. Any pointers on where I am going wrong h...more >>

I have a large text file (3.5GB) that I need to import. Each record is terminated with a CR/LF. However, the length of each record varies (60 characters to 79 characters). The last field in each record is a name field that is not padded with blanks at the end. My different attempts to copy thi...more >>

hi all, I have 5 source data that contain a table with exact schema, now I need to load data from all 5 database into one staging database table. I have created one ssis package that load data from one database, then I use dts object on my C# code to load and modify the connection and vari...more >>

I have created a DTS package which transform rows of one table from sql server to oracle. What happens is while transforming rows, if there is a error occured at 2100 row, It still writes 2099 rows into oracle table..how can i avoid it ? I want to write everything or nothing ? Pls let me...more >>

Hi, I have a small problem with tranformation. The code is: Function Main() a = DTSSource("ConfQuantity").value if DTSSource("CancelledConfirmationCounter") = 0 then DTSDestination("ConfQuantity")=DTSSource("ConfQuantity") else DTSDestination("ConfQuantity")= a *(-1) end if Main ...more >>

Hi, we have mssql 2000 SP 4 and one DTS with 2 c# custom tasks 2 vb6 custom task We have problem that DTS can be executed normaly by right click on DTS and execute, also task can be runned normaly by right click on Job an Start Job Job is scheduled to run every 1h, but afther 4-10 ru...more >>

can anyone help me ? thanx ...more >>

I need to create a DTS package that sends out an email based on a query. Query: [code] SELECT @Count= count(*) FROM employee WHERE site = 1 [/code] If @Count=0 I don't want an email to be sent. If @Count>=1 then the email should be sent out. How do I set up the package to reflect this?...more >>

Hi, I am able to execute a DTS package from a stored procedure just fine using the login credentials from SQL Server. How can I, in the stored procedure, change the identity to that of a WINDOWS LOGIN TO EXECUTE THE DTS PACKAGE?. You see, I am using the MSMQ in DTS, but, my queue is on a remo...more >>

I am new to DTS. I have one table which has password column in it. I would like to create the password from username.I one function which depends on the value of username. The return value of this function should be the password. I would appreciate if anybody can help me out finding the DTS so...more >>

Hello, Im trying to execute an XML Source task to SQL Server Destination. SSIS Creates a column [[ElementName]_Id] and makes it a type of DT_Uint8 - an 8 byte signed int. SQL Server doesn't seem to know how to convert this to big int, or even the default DT_Numeric that it sets up for the...more >>

I just using migration wizard in legacy->dts to import wizard from sql2000, it show successful. but where can i can the import dts? Can't find anywhere.. need advice soonyu...more >>

for example:get a rowcount to the DTSGlobalVariables and then check it in the ActiveX script. could any one help? thanx ...more >>

Hi I get a 'Object not supported error xl_app.Workbooks.Worksheets" when I add this line in the program: "If xl_app.Workbooks.Worksheets("Results").Range("A2:A2") is Null then" The sample code I am running is Function Main() 'References to Excel dim xl_app ...more >>

Hello, I would like to modify "Files" attribute of the Foreach Loop of type File Enumerator. This attribute is used to set the mask (for example *.txt) to specify which files to include in the selection. I need to be able to change this mask dynamically depending on package global variabl...more >>

SQL2K SP4. Howdy all. I've got a package that imports 7 .txt files into 7 different tables. When running the package, they say "Started" next to them, but the amount of rows shown imported next to "Running" only goes up in 1 table at a time. It is not until Table1 is completely imported tha...more >>

Hi I have a sequence container with TransactionOption = Required. In this container there is a number of task with TransactionOption = Supported and they therefore join the transaction started by the sequence container. This all works fine. Outside this container I have another task, w...more >>

Hi, I've got a SQL taks in DTS 2000 and a global var with a float number. I try to get the value of the parameter in the SQL task: declare @Total float update KPI set value=@Total where code=123 When I hit "Parameters" to map the variable, I get a message: Query does not contain any pa...more >>

i want to make a package, that it can get how many rows in a table. when the table get a new record. the dts will send an alert to the admin, or the record deleted, it will also send an alert to the admin. how can i do it. please give me some advices. thanx. ...more >>

Hi: I've been using DTS for awhile and soon will start using SSIS in SQL Server 2005. I liked DTS as an ETL tool and imagine I'll like using SSIS. Unfortunately when I work with customers who don't have SQL Server and aren't interested in buying they don't want to buy an entire SQL Server lic...more >>

I am trying to copy a SQL Server 2005 DB from one machine to another, but everything I try fails. The standard "import data" or "export data" that I used back in the SQL Server 2000 days now skips indexes and auto-id fields, despite me saying to it that it should copy that. So I tried the "...more >>