Can you help? I'm attempting to create a DTS package but have encountered a problem that I haven't seen before. I'm attempting to compile statistics by inserting a result set from a Sybase query into a MS SQL Server table. The following SQL statement runs fine in SQL Advantage and it also...more >>

I have completed my first SSIS package and want to schedule it in SQL Server 2005. Going through the steps I see the "Package Source" with the options of SQL Server, file system, and SSIS Package Store. I'm thinking that the later is where mine should be, but I don't know how to deploy it th...more >>

How does one configure and manage a remote SSIS Service? When attempting to administer a remote SSIS Service in SQL Server Management Studio, I get an Access is Denied error (message listed below) when trying to connect to the service. How does one set up access to a remote SSIS Service? ...more >>

I have no idea why it would be so hard to simply control the source and destination of data within the new SSIS. In DTS I could cause the connection to a file to change based on global variables and I could change the destination table for a data pump the same way. This was standard, needed f...more >>

I keep reading about the flexibility of SSIS logging, but I'm running into an area that doesn't seem so flexible. I want to have one text log file contain only errors from my package and another text log file that has many more events. While it is easy to configure two text log providers on t...more >>

Every morning I must edit the "schedule" section of a certain job property, click the [_]Enabled check box. Do not confuse the issue, this is not the Enabled property for "the job", but for the "Schedule" w/in the job. The job runs fine all day executing once every 1 minute. The only susp...more >>

Can you imagine?? I wrote a topic before about it, but my view on it has changed a little. Imagine there's a DTS 2000 package (Package A) which executes another package (Package B). Inside Package B, create simply an ActiveX task which causes the package to fail. (Main = DTSTaskExecResult...more >>

Hi everybody! I have a very strange problem, I have created a DTS that delete a table and create again. That table is located in a server running windows 2003 Enterprise x64 SP1 with Oracle 10r2 If I run the DTS works fine, no error, but If I run the DTS by schedulling I always get th...more >>

I am starting to work with SSIS and would like to get a copy of a database from SQL 2000 to SQL 2005. I have been able to make it work using the wizard, which gives me a dataflow with source and destination, but this is not quite what I'm looking for. I would like to use the database tra...more >>

Hi there, I have a DTS package that is exporting data from SQL Server to a text file. I have selected Fixed Field on the Text File Destination properties and defined the column lengths on the Transform Data Task. However, when the package runs, it completely ignores the column ...more >>

I am creating a DTS package to execute a second DTS package conditionaly if a row exists in table. How can I get an output parameter out of an "execute SQL Task" and do conditional workflow based on the value? ...more >>

Hi, Does anyone know how to add DTSpackage Object Library to Access 2000? I can find it in VB6 but not in Access 2000. I also tried to add ActiveX Controls \ Register... but no luck. Please help. Thanks. ...more >>

Hi We just upgraded from sql 2k to 2k5. I was able to import all dts jobs successfully on the 2k5 server. How do i no run those new;y imported jobs on the 2k5 server? when I right click on the main dts job, I dont see any execute job or even schedule the job? So what i did, I migra...more >>

I have a package that executes 5 separate selects from an oledb source (which is a SQL Server), sorts each select, and then merge joins them one by one (select 1 and 2 merge, the output of which merges with select 3, the output of which merges with select 4, the output of which merges with sel...more >>

I am converting a simple (at least in the SQL Server 2000 DTS days) to this new SSIS. I have a data source (which is Oracle 8 using .Net ODBC provider) and am trying to pump the data into a SQL Server table. I get an error that it cannot convert between unicode and non-unicode data types. T...more >>

Hi! I hope someone might be able to help me with this... I have a couple of VB6 DTS Tasks that use the same VB UserControl. The Control source code is part of those DTS projects rather than being a separate OCX. The Control raises an event when either of 2 ComboBoxes are changed. However, ever...more >>

I have a large project to complete and my choice for development is in Visual Studio 2005 using VB.NET. My project requires that I create a custom DTS tast tha is going to be used in SQL Server 2000. Is there a way that I can develop my project using VB.NET in Visual Studio 2005 and still use ...more >>

I am writing a custom task (in C#) to add some additional behavior to the ExecuteSqlTask2 object. I am using the CustomTask and ExecuteSQLTask2 interfaces , and have the various properties and methods setup or atleast stubbed out, etc. I want to write the guts of the execute method. I have a ...more >>

Hello, I want to use sharepoint document library as data source in a SSIS package. Is there another way than webservice to do this ? A searched something about Webdav with SSIS, but did not found anything....more >>

Hi, I am new to SSIS. I have been searching for some examples to use Expression Builder in SSIS to use derived columns transformation...I basically want to perform tasks like - 1. Add a new column to my flat file data source (also, next Excel datasource) on the run (which simply contain...more >>

Hello I have created a package to import tables from a second server using a copy sql objects task, and I have run into a little snag. My connection to the external SQL server uses my windows domain account (server uses ONLY windows authentication) and my connection to my SQL server i ca...more >>

Hi, I have developed a simple SSIS package that loads an XML file to SQL 2005 database table, however the loading process fails with the following error messages: [SQL Server Destination (VDMS - L_TESTING_SESSION) [1014]] Error: The thread for the SSIS Bulk Insert task failed initializatio...more >>

I would like to create a DTS package that will copy tables from one database to the other daily. This tables should be 120 days old {created more than 120 days ago and they should have data} After the tables are moved, I would like for the source tables to be truncated. Any suggestion...more >>

Hi, I am new to SQL Server and to DTs. I have to design a DTS package for the following situation and I am not able to decide how to design it. I need to do source filtering based on the destination table's rows values. There is System A with IBM DB2 running on AS/400. There is System B wi...more >>

Hello: I don't have much information to go on and I am not familiar with SQL jobs or package files. So, I'm just going to ask. This client moved locations about ten months ago. And, they got a new server. Doing so required, of course, a change of DNS name, server name, etc. Now, desp...more >>

I've just started using SQL Server 2005 Integration Services and I've come up against a situation where I need to name output files dynamically (i.e. based on a timestmap). Looking through this newsgroup and other resources it looks like my only option is to use a Script Task (ActiveX looks ...more >>

Hi, I have a .DAT file. I'm tyring to map all the columns from the DAT file into one SQL Server table. After certain column i cannot do anything.what is the reason? Please help. VKT ...more >>

Hello All, I have an Execute SQL task that calls a sproc and sets a parameter of that sproc to a global variable of type String. The global variable will be probably at least 25 characters long. For some reason when it is sent to the sproc it gets cut off at 10 characters. The parameter ...more >>

I have a SQL Job that calls a DTS package which in turn connects to a Progress dB and downloads. This has worked perfectly for months. However it's stopped working for no apparent reason. If I run the DTS package manually it connects perfectly and then I can run the SQL Job from Step 2 and it...more >>

Hello: I don't have much information to go on and I am not familiar with SQL jobs or package files. So, I'm just going to ask. This client moved locations about ten months ago. And, they got a new server. Doing so required, of course, a change of DNS name, server name, etc. Now, desp...more >>

I have DTS containing ActiveX task. DTS runs fine on SQL server 2000. But when I schedule it as SQL job, the SQL job is failed. My other SQL jobs which do not contain ActiveX run okay. Why SQL job can not run DTS with ActiveX? Thanks for suggestions. ...more >>

Hi, I tried to set a breakpoint within my script to debug something and that works fine as far as I can tell. When I go to the main window I can see that my task has got a red dot in it, which is expected. However it seems that the breakpoints only work if I execute the whole package and...more >>

Hi Folks, Pretty new to linked servers, however I need to create a linked server from MS SQL Server 2000 into Orcale database sitting on a UNIX platform. I already have successfull DTS application which takes info from the Orcale database into MS SQL, using third party Oracle driver via DSN...more >>

I'm using the Slowly Changing Dimension (SCD) component in SSIS to update dimension tables in a data warehouse we are currently developing. I've been running into problems with "some" of the dimensions having surrogate records being created for type 2 changes that don't really exist. In othe...more >>

Got the following problem: Source Data Column: FirstName; LastName; Salutation Target Data Column: FirstName; LastName; Gender The source-column <Salutation> always contains string "Mr." or "Mrs.". In case of <Salutation> contains "Mr.", target-column <Gender> should be "1". In case of <...more >>

Hi, in my dataflow, I've 5 columns in the input of a 'Derived column' task. 3 of these 5 columns allow me to compute the value of a new column. Then, I don't need anymore these columns in my pipeline. How is it possible to keep only the columns I need ? Maybe I'm blind, but I can't find...more >>

Hi, I've got a scenario where I need to retrieve some xml files from a website. The files can be xml csv, etc. At the moment we have an application written in VB that does it, you enter the file name and then it retrieves the file (normally an xml). Am I right in thinking that I need a w...more >>

Hi all, I'm loading some tables via DTS with the input files being comma delimited .txt files. For 2 date fields (format =smalldatetime in sql) if I pass a value of: "14/10/1980" it stores as 1980-10-14 which is correct. But if I pass a value of: "07/11/1980" it stores a value of 1...more >>

Hi All, I'm getting (what I feel is a silly) message when I open a SSIS package: "Document contains one or more extremely long lines of text. These lines will cause the editor to respond slowly when you open the file. Do you still want to open the file?" I tried setting the precompilebin...more >>

When I run the SQL Server 2005 Upgrade Advisor, I get the following message:- "SQL Server version: 09.00.1399 is not supported by this release of Upgrade Advisor." Is my version of SQL Server to old or too new? How can I use the Upgrade Advisor? ...more >>

I'm new to using DTS. I have a package that contains an ActiveX Script Task that sets two global variables (date1 and date2). I now need to retrieve a record from an sql2000 database that contains a date value to use in comparison. I'm use to msAccess and would typically use a DLOOKUP to g...more >>

I am trying to use the Checkpoint features of IS within a large package. This package runs within a SQL job. To be production-ready, we want to be able to restart any package by just restarting the job step that failed. The package would then start at the correct task based on the Checkpoint ...more >>

I am writing a SSIS package and have a newbie question. I am in the Execute SQL Task Editor and want to create a SQL Statement. I clicked on the Expression Builder and was creating a insert statement. One of the values to insert will have " and ' in it. The value will be gotten from an envi...more >>

Hi, I have a big issue. I have created a DTS package whit some global variable as: DestinationCatalog DestinationDataSource I will call this DTS using c#.net and I will give the global variable as needed. the problem I have is I have 300 import tables to import to the destination (MS...more >>

I have denormalized source data that I want to use SSIS to normalize and distribute to the propert destination tables. What is the proper SSIS task that can do this? I don't think the Conditional Split would work. Would the Multicast Transformation do the trick? ...more >>

Hi! I have a SSIS package that transforms three tables from a SS2000 server to my new SS2005 server. The connection to the sourceserver uses SQLServer credentials with userid and password. Destinationconnection uses windows authentication. The package runs perfectly in BIstudio aswell as whe...more >>

Simple situation. I have imported some records (e.g. flatfile, database) and I want check if these record are already in the database. If not import them otherwise update them. ...more >>

Hi! I'm using Integration services to automate a process from a industrial printing system. I've got a TAB delimited tekstfile which contains 29 columns which is beeing updated every 15 minutes from a remote server. I have one colomn that should be unique, "JobNumber", but it's not. JobNumber ...more >>