Greetings and Salutations All, I am new to SSIS and am building a package that will take a denormailized flat file and move its pieces to a SQL Server 2005 DB. I have used the flat source in numerous earlier data flow (df) steps with no trouble, column 11 is checked off for all the previou...more >>

Hello, I'm in the beginning phases of rewriting a simple DTS package under SQL 2000 to SSIS under SQL 2005. My simple package today does the following: 1) Pulls a file down to C:\TEMP via FTP 2) Contains 15 Transformation Tasks (Groups) where each task is reading a date, time, group, an...more >>

Let me begin by saying my script runs perfectly from Windows. It fails within an ActiveX task on DTS run interactively from my workstation via Enterprise Manager: Set objConnection = CreateObject("ADODB.Connection") Set objRecordSet = CreateObject("ADODB.Recordset") Set objFS = Crea...more >>

Hi, I 've got a DTS package that imports a comma delimited text file. It started erroring out and I discovered that at the end of the file, there is a blank row, basically an extra carriage return. Is there a way to get the package to ignore the last line if it's a blank row? I don't know h...more >>

Hi. I need some help figuring out how to pass a user variable into an Execute SQL Task. I have a user variable counter that I am using in a for loop container Variable Information Name Scope Data Type Value Counter Package Int32 1 For Loop Container InitExpression @Counter = 1 E...more >>

Hi, I've posted this question to the datawarehouse group, but thought I'd post here as well.... I'm just getting my feet wet with SSIS, and I'm having some trouble with the Slowly Changing Dimension transformation. I'm processing Type 2 SCDs, and in addition to creating a new current dimensi...more >>

Hi: I know I can fairly easily import XML files into SSIS, but what is the best way using DTS--I'm pretty sure there are a few ways using scripting etc. Thanks, Kayda ...more >>

Hello, In my Data Flow Task, I have a Flat File source that I would like to use a variable. How do I accomplish that? I tried it in Advanced Editor & Connection Managers, but not sure where I could slide my variables for it to be recognized. Any help is appreciated, -Lawrence ...more >>

I have created a dts package (to simplify) with 2 steps 1) open an excel file & run a macro 2) send an email that the job ran. step 2 is dependent on step 1. I have step 1 set up via a batch file which opens excel & the specific excel file (which contains a macro which runs automatically...more >>

I am using SQL Enterprise Manager installed on my desktop to access a variety of SQL servers. The problem occurs on all the servers I connect to. We are on SQL 2000 although I wouldn't think that was pertinent. I was trying to change the table name on a DTS. The problem is that, when I t...more >>

My source connection is a SQL Server in SSIS and I use SQL Authentication. So I provide the user id and password in the source connection. When I check the object into Source safe and check it out, tha password is not saved. This was never a problem in the DTS world. Also, I dont want to give ...more >>

Hi, I'm exporting data from sql server 2005 to oracle 10g using the 2005 Management Studio. Source = sql server native client, dest = MS OLE DB provider for Oracle. In order for this to work properly, I create the destination oracle tables using an oracle script (I've done it many times on ...more >>

Hi, Sorry i'm a bit of a newbie with SQL. I'm using a Oracle linked server. When I use a openquery in the query analyse i get the desired results. When I try to use a 'View' in Enterprise Manager the gives the correct reults but when I try to save it I get: ODBC error: [Microsoft][ODB...more >>

I had several jobs scheduled to copy databases from a live instance to a development instance both running on the same server. On installing SP2, the jobs now fail with the error below. The packages referenced by the jobs are executed successfully using Visual Studio or the Management Studi...more >>

Hi all, I have developed a DTS package that saves the result of a query into a text file. I have choosed the file name using browser. The result is saved in a path (c:\result.txt) and the DTS is scheduled to run daily midnight. I want to generate the file name with current date as suff...more >>

Hi! I've recently migrated my db to Sql Server 2005. With Sql Server 2000 I could easily execute my DTS packages from an Excel's macro exploiting the following VBA code: Dim dtsp As New DTS.Package dtsp.LoadFromSQLServer _ ServerName:="Server_Name", _ ServerUserName:="sa", _...more >>

Any assistance is apprecaited. If there is any document, that would be great! Thanks! Peter -- good good good not too good bad bad bad not too bad...more >>

Pretty new to SSIS. I have a Table with columns containing OldFileName and NewFileName. I have created Variables called OldFile and NewFile. I thought I should use the File System Task to go to Directory then I want to Loop through each file and replace the filename with the result of a ...more >>

Hi, I'm using SQL Server 2000 to design DTS packages. Sometimes when I open a database in DTS Designer I can't see the full table name in the "Source" Tab - "Table/View" field and "Destination" Tab's "Table name:" field. This is really annoyed me as I have to guess the table name!!!. Could an...more >>

I have set... Imports System.Xml But it says type xmltextwriter is not defined. Anyone know why ? Thanks ...more >>

I have two products say X and Y. Both run on SQL Server. X is used to manage clients, client orders and payments. Y is used for fulfilment of these orders along with the client information and dispatch addresses. I have been given the job to integrate these two products so that the customer pe...more >>

I am exporting a table from SQL server 2000. To Access 2003 using a DTS package. when I run the package the data is exported successfully, but it is appended to the table in Access. I need the table in Access to be over written. how could I do that? thanks...more >>

Is it possilble that the script modify property of data source?...more >>

Hi I posted this question in the .server newsgroup yesterday, but apparently my cross-post to this newsgroup didn't made it, so now I post it once more. I'm having some troubles setting up an Oracle datasource on a SSIS installation running 64-bit. We have it setup in our test/dev enviro...more >>

I have a table, that has a column which determines the file name. I want to export a file and rename it immediately. For Ex: Select Id, count(*) from Mytable group by ID gives the following: ID Count 1 100 2 ...more >>

Hello, Can I supply a batch of fiels to be downloaded to the FTP Task instead of configuring it 2 download a single file? Or Do I hv to loop around the FTP Task in order to download mutiple files?? Thanks in Advance, Sachin R. Chavan....more >>

I need to import some excel files in the Database via DTS. The problem is, that I don't know the names of the Excel Sheets (there are multiple sheets in the excel file). Is it possible to get the names of those sheets? (via activeX or SQL Query or anything, but from a DTS package) ...more >>

Hi all, Just put on a project which I need to learn some ssis. Could someone provide an outline on how to approach this task. 1)In a sql table we have an xml doc stored in column of datatype "text" 2)I need to query the xml in the text col to pull out a value any info on how to start su...more >>

I want to set up a DTS package that will process the current version of a txt file located in a directory. When i create the package and the connection to the file, it works fine the first time the package is executed, however after there is a new version of the text file located in the same di...more >>

I have a problem with DTS - ActiveXScripting that it cannot initialize the script engine, I have the backward compatibility stuff installed, even tried a repair but still does not work. Many thanks for any help you can provide on this problem. Paul Error Information below: Date 17/04/...more >>

Does anyone know what this error code means and why it occurs? I'm getting it when running SSIS packages from a DOS script. The packages migrate data from SQL Server 2005 SP1 to Sybase. The error occurs randomly and often. Cheers....more >>

please recommend reading for someone who has zero knowledge of sql. is there a live group in New York City? /s/ Neal Weissman (212) 591-1531...more >>

Hi there. I am new to DTS transformations using ActiveX, and are experiencing a problem. Let me explain the problem. I want to import data; let's say invoice data, from an AS/400 to a SQL server 2000 every 5 to 10 minutes. However, only the latest invoices should be imported. Therefore, I stor...more >>

Hi, I have a text file but its content is not delimited. For example I know that first 4 characters are my first column, next 3 characters are second column and so on. What's the fastest way to import such files into a table? My files are very large and the speed is important. Any help will...more >>

Hi everybody, I haven't found any hint on this problem - which makes me little confused, cause i cannot believe I'm the first bumping into it. When you have a variable defined and set the value inside of a data flow task to a new value, you cannot see this new value in later steps of the ...more >>

Hello, I have a SQL Server 2000 DTS package that pulls down a file from an ftp location, and contains a script task to make sure a file got pulled down. If the file did not get pulled down, I need to fail the package, and send an email. I wanted to use xp_sendmail in a SQL Task, but I don'...more >>

Hi, How I can configure the SSIS file system task to copy all files which is less than 1 days old in c:\test folder to C:\test2 folder. If the files in the C:\test folder is not less than 1 day old, then try the task again and again until there are files that are less than one day old. ...more >>

I am running a stored procedure as a job step and in the stored procedure I use return to pass one of several possible values when there is an error in processing (not an system error) so that the job step will fail. However, even when I return a non-zero value using return the job step comple...more >>