The DTS package reaches out to another server on the network to pull in a text file. The DTS package runs fine when launched from Enterprise Manager or if scheduled as a job. It FAILS to import the file when launched from an ASP page. The other tasks in the job run fine (backup and delete f...more >>

I have a column containing string data like the following: CORP/EAST/TENNESSEE And I need to transform this data to split out the names using the "/" as the delimeter. I was doing this in Excel using "Text to Columns". Please let me know how I can accomplish this in SSIS. Thanks -- ...more >>

Hello I want to convert a datetime to a julian day. TSQL has a DAYOFYEAR function but SSIS Expression builder does not. Is there a way to calculate the day of the year in SSIS expression builder. For example Today, March 28th, 2007 is the 87th day of the year. I am looking for a functi...more >>

I'd like to be able to execute an SQL command automatically when the database is brought online (or attached or the server starts). I assume it'll require DTS, but I don't even know what to ask for in Help. (SQL Server 2005 SP2)...more >>

Hello, everyone! I'm attempting to develope an SSIS package that uses variables passed to determine selected values. I'm using an OLE DB Source, and passing the query in that source values from paramters. For example: Select * from dbo.Test where Value1 = ? This works fine. Howev...more >>

Hi, I need to Import an XML file in to SQL Database using SSIS, Plz let me know how do I acheive this. I am quite new to SSIS, So if you can Point me to some samples on importing XML files using SSIS, nothing like that. Any additional references, if any, are most welcome. Thanks in Advan...more >>

Hi, I can't Copy a database from Sql Server 2000 to 2005. I am using the Copy Database option from Management menu. I want to transfer all tables, and all stored procedures. I've tried everything for the past 3 days, and it didn't work. I always get the same error. Below is the error that I...more >>

This is a long explanation, so apologies in advance!! In a Control Flow I can use precendence constraints to determine how and when things run. However, I've got a need to do something similar in a Data Flow. I have a dataset that I need to perform some work on, as follows: 1. Sample ...more >>

We have just upgraded our 3 main production servers to Windows Server 2003 from Windows Server 2000, these consist of a file server, SQL server and exchange server. We are having problems running SQL jobs that run DTS packages. The error message is as follows :- Error string: DTSStep_DTSDa...more >>

Hey, I just installed sql server 2005 onto a new machine to play around with it, having used client tools from sql server 2000 on an old machine. I connect to a remote sql server 2000 database and pretty much all the functionality is there using management studio - however I am having issues wit...more >>

I have a pump that does one data pump and then runs a series of sprocs (In Execute SQL tasks) on the data to transform. The transaction file is growing quite large (I don't have access unfortunately to the customer's production server). If the DTC service is not started, that means I cannot use ...more >>

Hi, I can't Copy a database from Sql Server 2000 to 2005. I am using the Copy Database option from Management menu. I want to transfer all tables, and all stored procedures. I've tried everything for the past 3 days, and it didn't work. I always get the same error. Below is the error that I...more >>

Hello all, Microsoft provides a report pack of RS reports to use with Integration Services standard logging. The link is here http://www.microsoft.com/downloads/details.aspx?FamilyID=526e1fce-7ad... I have been trying to use these reports in the UK and have come across a problem wi...more >>

Greetings, Well I don't think I have an Orphaned User problem but similar. I DTS copied a database to a new SQL Server. It seems that all my user ids have lost public role rights. Why I think this? sp_change_users_login 'report' returns no entries. So I assume that means that there a...more >>

Hello there I have Sql server 2000 SP4. I've just created 2 DTS's that create text files form views on my databases. When i run it from dts managment it works fine But when i scheduale the dts. the job run failed: Access denied what i need to do in order to run it propery? ...more >>

Hi, I have a SSIS package with sql command for SQL server 2005 and VS2005. First, I create a database in the database Master using the commande USE [master] then I had tables in that new database using the commande USE [new database] and the command USE does'nt work any more. All the tables ar...more >>

I have the following in a dts exec task: exec master..xp_cmdshell ftp -i -s:d:\laufer.txt laufer.com I get an error Line 2 Incorrect syntax near "-" This runs OK in a dos batch file. What do I need to change? Thanks. ...more >>

Hi, I need to import via DTS a text file with 3 fields into a table with a counter primary key and the same 3 fields. When I execute the DTS, I've got an error saying null values are not allowed for my primary key. But in the Transformations via DirectCopyXform, i haven't selected this the ...more >>

I would like to be able to store connection information (like server name and db name) for Analysis Services as well as SQL server connections for SSIS tasks in an Sql server table and to retrieve them at run time. Any advice?...more >>

Hello All Quick question I have a package that I am developing that is going to have a bunch of connections in connection manager. Lets say the number is 20 just so everyone doesn't go crazy. They are all File Connetions pointing to specific files in a folder. I am creating the package on ...more >>

Has anyone come up with a solution for copying a dynamic table list? I have a source with 50 or so tables my destination has the same schema. Is there a way to create a loop routine to copy the source data to the destination? I really don’t want to create 50 copy routines and then have to m...more >>

Hi all, I want to connect from a Client workstation to the SSIS engine of my SQL2005 server. But, the only choice of authentication I have is Windows Authentication. Is it possible to change it and use a sql account to log into the SSIS engine? thanks in advance. Regards Cédrick B....more >>

Hi, I am really new to SQL SERVER 2005, i am not even familiar with Creating procedure So what i am trying to do is dump some data form CSV file to a table the following shows the flow of the data base CSV.file --------- > Dump_table ----------> Actual table SSIS ...more >>