Hi, I have created a SSIS package. The connection used in the SSIS is SQL Authenticated. This runs perfectly when executed even after it is deployed. However, I face problems when I want to execute this package as a job. The error I get is - "Login failed for user - <user name>". While crea...more >>

Hi, I was wondering is there is a way to start a SQL Server 2000 Job from a command line?? I know you can start a DTS using the dtsrun utility but have not been able to find any information on starting actual jobs!! If any one can point me in the right direction that would be great. ...more >>

I am new to DTS packages. I have to extract data from SQL Server Database and store it in CSV files. In addition to that I need to extract a few columns as Lookup Data from the Oracle Database also to the same CSV file. Is this possible to have Lookup from a different Source Database? Awai...more >>

I Happen to migrate pacages from SQL server 2000 to SQL server 2005 using the Migrate Wizrd - right clicked Management | Legacy | Data Transformation Services and clicked on Migrate wizard and migrated all my DTS packages to DQL 2005 server1. I see the packages in sysDTSpackages90 table. I do...more >>

I apologize if this question seems dumb, but I've looked at both the group and the SSIS book and can't seem to find what I need. I have a package that takes input files from clients and loads the data into staging SQL 2K5 tables. I've set up the connection manager for each of the six sourc...more >>

I need to migrate the DTS, the jobs, users and everything from a database on a Windows 2000 server (SQL 2000, upgraded from SQL 7), to another (Windows Server 2003, SQL 2000). The databases that do not already exist on the new server I can restore those from a backup just fine. The ones th...more >>

Hi all, I am trying to use DTS Package to export some table result to an EXCEL output file. After that, I would like to copy that file from the original location to another directory with a different file name by adding the current date to it. (Filename YYYY-MM-DD.xls). Here is what I h...more >>

Hi, I have a DTS package setup to load a forecast from an Excel file. We have 17 different countries to load, so instead of having a DTS package for each country I'd like to use the same one for all. I setup a package to call the forecast load package, and I'm passing a global variable with...more >>

Hi, I am importing an excel spreadsheet using dts into a table in sql server. The problem is that one of the fields in the excel spreadsheet consists of a number or comma delimited numbers. When i pull the data from the excel spreadsheet it is passing null for the comma delimited numbers. It ...more >>

I have downloaded and installed the latest SQL 2005 BOL. I even installed the msi file in the Samples folder and still the tutorial doesn't work. Has anyone gotten the tutorial to work? Eventhe customers.xls file was missing and even when i did find one in another tutorial, it didn't match....more >>

Hi! I have a DTS package that exports a table to text. I need to find a way to look into the table and get the carrier ID and insert it into the title of the text file to be exported to. the title should look like this: E55N6050.log where 55 is the carrier id N is the region 6 ...more >>

Is there documentation/website/tutorial on how to create a bcp file manually? In one project, I need to generate a bcp file from infromation inside a DataTable but not sure what the file needs to look like. -BKN ...more >>

Hi! I am running a sp which calls a DTS package at the end with following code: EXEC Xp_Cmdshell 'DTSRUN /E /NERROR_FILE_PROVIDERS' GO After I run the sp it gives me this error message: Server: Msg 2812, Level 16, State 62, Line 124 Could not find stored procedure 'Xp_Cmdshell'. W...more >>

Hi Technies, I would like to get the help from the experts of SQL Server. The current requirement for me is "to import the data from the remote server" . I have a SQL Server located in one particular network placed at a particular location. I wanted to import the data from another differ...more >>

Hi, I need to be able to query the database within a Script task. I basically need to get the current connection and then execute some sql or stored proc and find out what's in the database and based on this info make a decision in the script. Does anybody know how to do this? I've tried...more >>

I use a DTS package that imports data from an Excel spreasheet in a table in SQL Server 2000. All tranformations are a simple copy column. Zip Codes with leading 0's are imported without the leading 0. 9 digit zip codes with a hyphen show up as null in column defined as varchar(15). All ...more >>

Hello.. I have been playing around and creating test SSIS packages in my development 2005 environment. I have saved the packages to MSDB. I am now ready to start creating useful SSIS packages. How can I delete the old SSIS packages from MSDB in SQL Server 2005? Please advise... Tha...more >>

I have an access database that is encrypted using a workgroup file (security.mdw) Although the DTS wizard has an area that you can provide a password - this must only be setup for Access databases that are protected using a "Database Password" How can I export data to an Access Secured d...more >>

I am creating a DTS package from a VB application. I have no problem creating and connecting to the Source and Destination data sources. I also have no problem with the Data Pump to transfer the data from source to destination. Is there a way to read the Source tables properties, to dynam...more >>

I'm rebuilding my server after a total crash - two drives in the RAID failing at the same time. Pretty much a worst case scenario, I'm having to rebuild. I did have backup routines set up on my databases, so I didn't lose them. However, the DTS scripts did not get backed up so I'm having to rewr...more >>

I got a dts package running ok manually. But it does not work when scheduled. I read article 269074. But I wonder if trouble could come from ODBC FoxPro driver : My dts job includes accesses to FoxPro source, and SqlServer source (data pumps). Accesses to SQLServer source work ok, which is not...more >>

I have SQL 2K and I have created a local package to import data from Access mdb and I have saved it in Data Transformation Services --> Local Packages I would like to know if this can be executed from SQL query analyzer. Thanks Dimitris ...more >>

I needed to figure out how to have a spreadsheet perform a lot of data processing and then send the data to Sybase. It occurred to me to let DTS bring the data from Excel and then process the data. I found a link on the web that details how to have VB execute a DTS package. http://www.s...more >>

Just started a Data Migration project that involves moving 12 tables with about 100mb of data from one SQL Server to another. For various reasons, the dba won't let us use DTS so we're using ADO.NET to pull the data down. The arguement is now between manually generating a bcp file to upload in...more >>

I am running 64-bit SQL 2000 sp3 on top of Windows 2003 Advanced Server and Windows Cluster Services. I have a DTS package which loads data from an xml file in Sharepoint. I am able to run it successfully from EM using the SQL Agent service account sql_agent, but it fails when it is scheduled ...more >>

SSIS Community: I have some .txt files I need to work with in SSIS. When I create a Flat File connection, the connection manager does not seem to recognize the row delimiters. For example, in a file that contains two rows, all I see in the preview pane is one long row, as if the connection...more >>

Is it possible to setup an automated job to download files from an FTP site? I am running SQL 7.0 on a Windows 2000 server. I'm not sure how to proceed if it is possible....more >>

Very long story short, I have a group of steps in an SSIS package that I would like to loop through based on the values returned from an SQL SELECT statement. I've tried to set up the ForEach Loop container to process the statement, but have been unsuccessful. How do I tell the container to ...more >>

Hello, I have created a SSIS package that loads a SQL 2005 table with data from an Excel Source. Error (row redirect) outputted to an flat file. I have added a Send mail task to the control flow, but cannot figure out how to conditionally cause it to execute when the data flow actually outp...more >>

After upgrading to SS2005 from SS2000 I am not able to find where the legacy DTS package logs are now located. (I can no longer right click on a DTS package to open the "package logs.") thank you....more >>

In my DTS package there are two possible execution paths. They both finish with a common "end" task. I am able to execute the desired path by disabling the steps of the path I do not want to execute. However, the "end" task does not get executed. The last task in both paths have a constr...more >>

Hello, SSIS 2005 EE x64, I created an Excel connection 97-2005 within the connection manager and mapped it to an excel source. After the source is a data conversion ending in an SQL Server destination. When I execute the data flow in the BIDS I get the follwing error: [Excel Source [431]...more >>

How can I resolve the following error? The error message appears when I am running the package. ERROR: [DTS.Pipeline] Warning: The output column "Password" (191) on output "OLE DB Source Output" (26) and component "IPC-SQL - PSTM - PSIUsers" (16) is not subsequently used in the Data Flow...more >>

Hi, I want to execute a DTS in VB and found that there are few ways to do that: 1. Create the DTS and schedule the package and use msdb..sp_start_job to execute the DTS 2. Use DTS.Package2 LoadFromSQLServer 3. (I havn't try this) Use DTS.Package2, DTS.Task to create the task from a dts ...more >>