Are there any samples for DTS of SQL Server 2005 data to FoxPro mdf files ? Thanks. ...more >>

I've inherited a project which has numerous fields that have extra spaces in them -- this is causing a problem with data Inserts, Edits, and Deletions in my .ASP Website. I'm importing data tables from ACCESS 2003 into SQL Server 2005, and I need to know if there's a way that I can Right Tr...more >>

I am tring to convert an existing ActiveX task to a Script Task using VB.net. Below is the code from ActiveXScript (SQL 2000)? What will be the equivlant in SSIS (Script task)? Dim FSO Dim InputFile Dim InputFile2 Dim OutputFile Set FSO = CreateObject("Scripting.FileSystemObject") FSO.C...more >>

We run a scheduled job with Owner: SvcExePUser. In the log after the job completes, it appears to run as US\svcClus as listed below: Executed as user: US\svcClus. ...OnStart: DTSStep_DTSExecutePackageTask_1 One of our scheduled jobs keeps failing because the directory it is transmitin...more >>

Hi, I am writing a DTS package to get data from Teradata. It seems like Teradata driver does not support parameters. I need to pass parameter to the query. Is it possible to write ActiveX to substitute query parameters from global variables? Please give me the steps how to do it. Also, should...more >>

Hello, If I have to restart an SSIS package at the checkpoint, how do I keep my variable values? Is there a way to persist the variables in the checkpoint files so when the package restarts, it knows what variables were written too in an earlier task? Here's my problem, if step A writes ...more >>

Using SSIS 2005, I am importing an excel worksheet whose column c (formatted as number) has some null values. The destination table column "c" (datatype of float) has a default of 0. After executing the SSIS package, there's are NULL values instead 0's. Why is this? Is there a package confi...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. A...more >>

Newbie question. What is the easiest method of transfering DTS packages between servers that cannot see eachother? ...more >>

I am having a puzzling problem with a DTS package in SQL 2000 that uses a combination of "Execute Process Tasks" and "ActiveX Script Tasks." The issue occurs with one of (the second) the ActiveX Script Task. The script invokes a COM object that was written in C#. This COM object connects to...more >>

Hi! I'm calling a VB.net exe using an Execute Process Task and it appears to be timing out on me. It runs for 3 or 4 minutes and then just stops and returns an error 128. I think it is timing out because 1) if I run the exe directly it finishes completely without an error, 2) the program do...more >>

Hi, I'm working with SSIS 2005 and encountered with a problem with specifying the log file path. I need to dynamically set the log file name of a child package in the parent package. I use variables to achieve this. The problem is, in the child package, before it has retrieved the log path ...more >>

Hi, Where I currently work we are using MS-SQL Enterprise Manager 8.0. We use DTS packages to copy daily production files from one area to another and then load the data into a database. I have set up DTS packages up to automatically copy a set of files being produced every day from one a...more >>

Hi, I have an Execute SQL Task in my SSIS Package. Now, this Execute SQL Task has the following query (Connection Type is OLE DB): SELECT dbo.udf_CommonDateTime_Get (GetDate(), ?) As User_Datetime I want 2 things from this Task: 1) It should take the 2nd argument to the UDF from a varia...more >>

Hi, I'm definitely a newbie to SQL 2005. I'm importing data from MS Access 2003 and several tables have a status of Error. The error messages in SQL 2000 DTS were helpful as they included table name, column name and description of data problem that caused the error. This enabled me to ident...more >>

Hi, Another classic example of something silly I must be doing :( I have a "Foreach Loop Container" which uses a "Foreach ADO Enumerator". The object source is a recordset variable. Inside the "Foreach Loop Container", a lot of things are happening - some Execute SQL Tasks, Send Mail Tas...more >>

Hi, I am facing a very strange issue with the Send Mail Task: I am fetching the recipient from a Recordset and storing it in a variable (MailList). Now, I modify the Send Mail Task to include an Expression which updates the "ToLine" property with the email address in the "MailList" variable...more >>

I have a DTS package vba task which loads a list of files into table. It is possible that a file is already in the table from a previous cycle, and as I only want a single entry for each filename, so I have put a primary key on the 'filename' field, thinking that it would prevent duplicate ...more >>

Hi all I've got a bit of a problem doing some changes to existing packages on our db. When I do a small change; say, changing the path of the error log for a transformation task and click ok. I need to wait for about an hour before it stops freezing and completes. This also happens if I cl...more >>

I'm unable to copy my Stored Procedures from one database to another. I'm using mixed mode authentication. I have set CopyAllStoredProcedures to True, DropObjectsFirst to True and CopySchema to True. Nothing gets copied. I have followed many web sites that say Transfer SQL Server Object...more >>

Hi, I have an automated task that runs a process to generate files and then uploads them to an FTP via WS_FTPPro and a script file. the problem in this scenario is that the WS_FTPPro script transfers multiple files in individual sessions for each file and the account I use to sign in on the h...more >>

I have a DTS package that is just a list of 'update statistics <tablename>;' statements. The package has a log file that lets me know that the steps where successful and low long the total step[s] took to run. I want to put print or select statements in the the TSQL script so I can see the ret...more >>

Hi! At least I think I'm after variables. But I'm not sure. I have a book and a CD training course, and I've searched around here but have not been able to find anything that answers my questions. I'm totally stumped - probably because I know what the problem is, but not entirely what I'm l...more >>

Hi, I'm developing my first SSIS project where I need to design a package which would execute around 10 stored procs. All the 10 procs will have to fetch data from a single Source table within a Source DB and insert into each of the coressponding 10 tables in a Destination DB on the same serv...more >>

I have 2 production servers which operate in conjunction with each other (i.e. one will update databases & tables on the other). They're both Windows 2003, SQL server 2000, most current service packs on each. I've run an upgrade tool (inquiry) on them, and it ID's a few stored procedures t...more >>

I'm trying to help a coworker with a DTS package. I mostly use VBA and don't know a lot about DTS. What he had was a hard coded line like this DTSDestination("Aug 07 VS Sales") = DTSSource("Aug 07 VS Sales") and the date was always for the prior month. I came up with some VBScript to c...more >>

Hi, I need to know whether it is good to use a Stored Procedure in the Execute SQL Task inside a SSIS package or whether the functionality of the SP should be emulated using the SSIS tasks and transformations. We have some DTS packages which are calling a Stored Procedure to do all the t...more >>

How can I make a job successful when it contains a DTS package that transfers data from a text file to a SQL Server table and updates the table? The problem is the job should run daily but the file may not always be there : Function Main() Dim oFSO, sFileName sFile...more >>

Hi, DTS job fails with the following error, A Server (Windows 2003 SE with SP1) has 4 SQL Server 2000 instances with mixed of SP3 & SP4. But few jobs are failing in all the 4 instances. Executed as user: DCADB04\SYSTEM. DTSRun: Cannot create COM Server to load and execute DTS Package. ...more >>

I have a Package which can process any number of files and after processing each file it Archives the Processed file in the Archive Folder. I cannot reprocess/Import the same file again(in case by mistake) to avoid this i need to put a check before each run to check the archive folder with the in...more >>

When I first create a package that contains an Execute Process task which runs a batch file, it runs without any errors. But if I run the same package a day later, it fails with the following error: Error: 0xC0029151 at Extract Discoverer Data, Execute Process Task: In Executing C:\ora\bat\NetDirec...more >>

How long can I run the profiler to get trace from the production server. It should not degrade the server performance. what is the minimum time to run the sql profiler to caputure all queries in the trace ...more >>

I have a fixed length (ragged right) flat file with several dates in the format YYYYMMDD which I am trying to load into SQL smalldatetime fields. I have set the input for the fileds at a width of 8 (dt_Str) and output width of 10. I have added a single derived column data flow element and sp...more >>

Hi All, Here is my scenario: I execute a Data Flow Task, that returns only 1 row and one column. I would like to assign that result to a variable. Then, based on that variable (or result), I would like to execute either Data Flow Task 2 or Data Flow Task 3. For example, if the result ...more >>

I have a DTS package that imports records from a fixed-width text file into a table with matching columns. There are about 500,000 records to import, but after "successful" completion of the package, only 288,000 records have been imported. I located in the text file one of the records t...more >>

Hi there... I'm fairly new to SSIS, and am having an interesting issue. I have a fairly standard package, it: - Imports a table - Runs a query - Exports a Flat File - Zips the flat file using a comand line process - FTP's that File to my server. If I run the package in debug mode...more >>

In a DTS package, it is a laborious task to connect an On Failure Workflow to a different Send Mail Task for each task (major or minor). I am trying to do some researching on a single effective way of sending an email with a description of the error and the job->task that it belonged to. What...more >>

Hi All ! im kinda beginner in SSIS and any help will be really appreciated ! we have 2 separate DAtabases and each DB has a common table , lets say Tracking Table. In DB1, Tracking has columns that has varchar datatypes, and at DB2 it has same columns but of INT datatype. Basically, eac...more >>

Hi Everyone - I have the latest version of SSIS/SQL Server 2005. In my package, I have a data flow task w/an OLEDB Source and an OLEDB destination. Nothing else. The source is a table on a SQL Server 2000 database and the destination is a table on a Oracle 9.11e database. I have verif...more >>

hi I must send emails every month with dynamically named files as attachments. The files are named according to the date on which they are generated. For example on the first of November 2007, the file will be named myfile_1_11_2007. I have created a variable called DynamicFileName with pack...more >>

Hi Can you use DTS to read the windows registry on a server via one of the connection? Thanks Simon ...more >>

I created a SSIS package that imports an Excel file that has columns with > 255 chars into a SQL table. I am getting error "Text was truncated or one or more characters had no match in the target code page" For Excel Source Output I tried changing the type for External and output columns to...more >>

I need help converting some existing ActiveX script to use either the Foreach or For loop task. I have a sproc that returns one row containing a dynamic list of column names and values. I want to use that resultset to create global variables in the SSIS package with the assigned values. All of...more >>

I have a DTS package in SQL 2000. It executes a Microsoft Access file(mdb) which moves some data into SQL for me. The package then does some other stuff. When I execute this package from Enterprise Manager, it all works great. I then made a SQL job to run the DTS package, and it won't run ...more >>

I want to create a DTS package (SQL Server 2000) to import order data from an external source. An order consists of Header data for the whole order (OrderID, customer info, payment info, etc) and detail data for the purchased items (OrderID, LineItemID, Sku, item name, price, quantiy, etc). ...more >>

I have a SSIS package on a SQL 2005 server. From within the SSIS package, how do I trigger a DTS package on a remote SQL 2000 server to run on that remote server, as oppossed to importing the 2000 package and executing it locally on the 2005 server? Thanks....more >>

Using a client/server setup with MS Access 2000 over SQL Server 2000, client machines are unable to import. The error is "ActiveX component cannot create object." I have followed the instructions on "Enabling SQL DMO Clients Without Installing the Client Side Utilities" (http://support.m...more >>

Hi All, I have a requirement to execute an SSIS package from within a stored procedure. The package needs an incoming parameter, and from what I've seen, I can't do this in T-SQL. I wrote a simple c# class that uses the Microsoft.SqlServer.Dts.Runtime objects to do this. I am able to execute...more >>

I am finally getting around to upgrading from sql 7.0. I installed a new 2005 express server for testing and am trying to use DTS wizard to move the old 7.0 database to 2005, but when the tables transfer it strips out primary keys and a few other things. Anyone know how to keep that from happen...more >>