I've been reading on SSIS for a couple of days now, and haven't come across a mechanism on updating existing data! My data source is a delimited flat file which i'll have to validate and then plug into SQL server 2005. But its possible that the records already exist, in which case i'll need to...more >>

I have an SSIS package that is scheduled to run every 5 minutes by the SQL Server Agent. I only want to allow one instance of the package to run at the same time so it does not step on itself when it is doing some file and database activity. Is there some easy solution to this? I though of u...more >>

Hi, If you connect to SSIS with Object Explorer you can right click and select View Logs. This will load the SQL Server Integration Services/NT Events into a Log File Viewer. This log appear to go all the way back to the first time that SSIS was installed and started. This can make this log...more >>

I need to periodically import a (HUGE) table of data from an external data source into SQL Server, with the following scenarios: 1- Some of the records in the external data source may not exist in SQL. 2- Some of the records in the external data source may have a different value at different ...more >>

Hi! I got a package with a Script task(VB) that runs OK when executing under Stored Packages, File system but fails(stays "yellow") under SQL server Agent Jobs. I've secured the package with "EncryptAllWithPassword". I guess it might be a security issue in Sql server agent. Anyone know how to...more >>

When I execute my SSIS package from SQL Server Agent job or DTEXECUI the configurations stored in SQL server is not read. The connection to the SQL Configuration is specified in the command parameters. When running profiler I can see that the SSIS Configuration table is not accessed at all. ...more >>

Hi, I need to download a file from an ftp server via my dts package. The order is connect to ftp server check if file exists (the name is always the same) if yes, down load file and delete copy on ftp server rename file from test to test.txt parse file (This I got working) I need help wit...more >>

I have SA permission on that SQL 2000 server. I can access that SQL server by using Enterprise Manager from my PC. If I open a DTS package saved in "local packages" on that server, I can open any DataPump connections. But when I open a DTS package saved as .dts file on that server, I can not ...more >>

Why am I getting an invalid column length when I tried to create a DTS package using a text file as the destination? The source of the data is a query. Thanks Emma...more >>

I have two similar triggers one on solodata table and one on components table. I cannot get the trigger on solodata to execute. I have pasted it below. Below that I hve pasted the one on components that does run. i checked and extn5 does change, and the groupid in solodata is 66, I would ap...more >>

Hi, I have a data transform from a flat-file to a SQL server database. Some of the flat-file fields have NULL values. The SQL table I'm importing into does not allow NULL values in any field, but each field has a Default value specified. I need to have it so that if a null value comes acro...more >>

I am trying to receive the return value (@ReturnValue) from a stored proc while using the SSIS Execute SQL command and map it to a package variable. I can run in a SQL query window the following commands DECLARE @ReturnCode INT exec @ReturnCode = usp_Import_Entries 'EMD' Print @Retur...more >>

I'm looking to be able to get the filename of a file that is of a particular type. I know that my DTS package is going to export a file that has the time in the name of it (ex CRB-UHCCIG6-5-2006-11h36m59s.edi), and i want to be able to auto zip that file. Copying, zipping isn't a problem, it's ...more >>

I work with quite a bit of different Excel sheets and often receive columns with mixed data. Sometimes the alpha data won't appear until much further down in the sheet, leaving me with NULLs imported instead of the alphanumeric data. I realize that I can add IMEX=1 to the connect string to ena...more >>

2 databases in sql2000, and from one you want to move new/altered information overnight into a datamart. I'm well aware that DTS is for moving information, but I am not too sure if facilities in it will handle recognising changed records. I was wondering if there was a best practise out there fo...more >>

Hello, "Could not find installable ISAM" with have an WEB application where our customers can upload their contact/data for marketing reports and analytics. For this they fill a Excel data sheet, and once uploaded, we parse it and put data in SQL Server 2000. The platform is H24/ W7 availa...more >>

Hi All , Can i check in which db does a local package DTS is stored - msdb ? and in which table tks & rdgs -- Message posted via http://www.sqlmonster.com...more >>

Hi: I have vs2005 professional and Sql server 2005 dev edition installed on my machine and when I try to open a SSIS package I get: Microsoft Visual Studion is unable to load this document: Could not load type 'Microsoft.DataTransformationServices.Design.DtsComponentDiagram' from assemb...more >>

How do i import a flat file with a filed > 256. Im running a simple DTS package with a text file source. when i import the flat file it cuts off the filed value to 256 any ideas or work around this? thx! ...more >>

Is there a way to programatically change the query that Lookup is executing? I gave up trying to find a way to reset a connection each time the lookup is called. Thom...more >>

Is it possible to remotely call a DTS with VB6.0 embedded in an Excel application? The Excel application is on Machine A and the SQL DB is on Machine B. They are on the same network in the same domain. I assumed it was and would be fairly easy to implement, but I can not get it working. Do ...more >>

Good Evening, I've a Dts in my sql server 2000 that contain 8 packages. If I fire the dts from local packages all ok If i try to fire the package step by stem I've this error: server busy-this action cannot be completed besause the other program is busy.choose switch to to activate the busy pr...more >>

I migrated a package from serverA to serverB. The package reads the log server name from an INI file via a dynamic properties task. However, the package fails to execute on serverB. It still tries to connect to serverA though the INI file shows the value as serverB. Refreshing the dynamic prop...more >>

I need to dynamically build the columns used in a Transform Data Task (or possibly a Data Driven Query Task). I understand how to read from the registry and/or text files to dynamically set items, but I am not sure where to start to build the source and destination columns in a Transform Data ...more >>

Hopefully someone can help, I have data from 60-70 tables I have to move from one database to another on a weekly basis after a number of tasks are performed on these tables, not all the tables in the database are being copied though. Currently I have a package that does each individual table in...more >>

I have a DTS package that does a lookup to get the number of rows in the sysobjects table of the database. I am just wanting to verify the database is online and connectivity is good. I am using one connection to get all the databases name and the other connection of the workflow to check ...more >>

I am using a vbscript that Exec a DTS. The DTS command string is created with global variables that are passed to the select and used to name the file that is created. In the DTS the file path is defined and the variable with the file name is associated. The path points to a shared folder on...more >>

(SQL Server 2000, SP4) Hello all! I am experiencing some incredibly slow performance in migrating data between SQL Server 2000 and Oracle 10g. The SQL Server database is the source and the Oracle schema is the target. I am sending a handful of integer and relatively short string column...more >>

We are currently embarking a pretty big project to re-develop and deploy employer reports using SQL Server Reporting Services to replace some older custom reporting infrastructure. We are engaging a consulting company to develop these reports. We have traditionally made this company perform fi...more >>

Hi all, I've had a package which ran cleanly for some time. I've since been getting the following error: Error 0xc0202009: Data Flow Task: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 D...more >>

Hi, We are seeing this message when try to import a fixed width text file into a database table from a workstation running SQL2005 gold tools to an SQL2005 gold server. The messages we get are:- Error 0xc00470fe: Data Flow Task: The product level is insufficient for component '"Data Conver...more >>

Is there a way to enter the columns of a flat file without using the GUI? It is easy for me to format a list of column names and column widths that I could copy and paste, but the only way I see to input file parameters is via the GUI. In the old DTS you could edit the connection object and ...more >>

I=B4m importing a large XML-file with SSIS and have performanceproblem. I have 5 output collections from my generated XSD but I=B4m just using one of them, I have tried to uncheck the output columns in the unused output collections in XML Source Editor but then I get a error messege when I exec...more >>

I would like to create a package that connects to a fixed database table, retrieves from there the name of an excel file to get data from, and gets the data. Basically the question is: can I configure the connection managers dynamically? I know I can do it programmatically, but this would m...more >>

Hi, How do I create my own component that joins (actually it does a lot more, so it's not a solution to use the existing merge join transform) two huge sorted input streams without having to cache up too many rows internally in the component? To be more specific: What I wonder about is ...more >>

Hi , Is it possible to script the DTS ? if so how can i do it ? appreciate ur advice tks & rdgs -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-dts/200606/1...more >>

Hello, I am trying to transfer views using SSIS: transfer sql objects. Every time I do, I get the error that the table already exist. All I am trying to do is transfer the view itself, not the data. Can anyone tell me what the parameters should be for this? DropObjectFirst: False (vie...more >>

Hello How do I disable an sql task in ActiveX? thx ...more >>

Hi all I looked at Allens article http://www.sqldts.com/default.aspx?246 and am trying to get this to work. My problem and what I dont understand is this: The program uses a global variable that is supposed to contain a file name: gv_FileFullName. Well, the point of the program is to loop...more >>

How to use a DTS, FSO to move copy the backup of the database to the secondary server and manually restore it in the event of a failure? I have a minimal amount of experience w/FSO, mostly exsits and copying of files, but not with getting the file date to know which backup to copy when there ar...more >>

Is there a way to restore a DTS package? I was removing a DTS package from my server and I clicked on the wrong one. Is there a way to undelete it? Thanks, Joe ...more >>