I am writing an MS Access 2003 application which needs to execute a DTS package on the server from a client machine.
The following code attempts to execute the LoadFromSQLServer method on t...
I have a DTS package on a SQL server scheduled to run as a Job. This package connects to a remote SQL server to grab data and update local tables. In the past, we had a SQL login for the rem...
Hello, I am trying to dynamically adjust the Error File name in the Error Handling section on the Logging tab of my DTS package properties. That is, if the package is named "B2B_Import_Daily",...
Hello all,
I have a MSSQL 2000 database that I am migrating to a new server box with SQL 2005 installed on it.
This is my first attempt at something of this nature. I moved the Data and User...
After moving my application to IIS (from the VS.NET app server) - I get permissions errors when I call my SSIS package from a static method in one of my C# classes.
Package package = app.Lo...
Dear Experts,
I have a foreach loop in my SSIS package.
In this loop there are many Data Flow, Execute SQL tasks, Execute Process Tasks and Script Tasks.
The Loop is running properly.
No...
I have a SQL Agent Job in SQL Server 2000 that uses a DTS Package to import information from an ORACLE source. This is a direct import with no special transformations. I have this job schedu...
Hi, I have an SSIS package I created via the import/export wizard in management studio. Something happened to the package and it said I had to update the metadata for the source fields or som...
I'm looking at a DTS Package here that is launched from a Stored Procedure. The DTS Package writes data to an Excel spreadsheet. For this it uses a JET connection (apparently!)
The problem ...
hI
I am moving huge volumes of data from a dbase file to SQL Server using DTS. The table into which the data is moved contains a clustered index and 2 non-clustered indexes. My problem is t...
DTS Import of flat (text) file / VBScript transformation (ActiveX)
Fld 20 Fld 21
- 00002500.2369
NULL 00000182.50
Fld 20 Positive / Negitive indicator
Fld 20 Number ...
I migrated one DTS package from SQL 2000 to SQL 2005 through Migration Wizard. It's migrated successfully. I didn't know where migrated DTS package located, and didn't know how to run the DTS ...
Hi all, I am mostly done with this, but can't seem to get the part where I copy my data to a specific cell location on an Excel spreadsheet. Normally I would just do an add new and copy my da...
MS SQL Server Enterprise Manager Had DTS but SQL Server Management Studio Express Does Not. How can I get Data Transformation Services for Studio Express? I have tried installing a DTS setup...
Hi i need a ActiveX script to ececute a *.bat file through SSIS ActiveX Task.
any suggestion, would be helpful.
Hi Experts,
I have a Access db which I am moving into SQL db and doing some message with the data and pushing back into Access db.
When I create a DTS package I am facing problem when I tr...
I saw the "Command Line" like - /FILE "d:\DBA\user.dtsx" /CONNECTION "Connection ...
How to put it into job and run it as one step of job? Do I need to put dtsrun at the begining? Do I need t...
Hi,
I Need to change dd-mm-yyyy to mm-dd-yyyy on import of Excel file to SQL server 2000
Sometimes I receive Excel files with a date column which has the format of dd-mm-yyyy
My preferred...
Hi
I am exporting data from SQL server 2000 table to a CSV file using DTS.
One column in particular is giving an issue.
It is a serial number column - it can have mixed data types - eg; n...
Hello
I've just been setting up a DTS job in VS integration services.
I'm now trying to save the package to a SQl server 2005 on another machine.
I am able to access the package loc...
An Excel workbook contains a worksheet to be imported into a SQL2000 table. The sheet shows a couple of rows of text as header and rows of column headers/footers and blank dividers between gro...
In my DTS package ---->Execute SQL task I have list of querys I want to comment out each and every query at the begining and the data source for my DTS package is MS Access.
when i tryed --qu...
Im trying to copy a table from SQL Server 2005 standard to MySQL 5. Ive tried right clicking on the database in MSSQL and going to tasks and trying to export that way but there is no provider ...
I have an updated question, since I dont think assigning Global Variables under DTS packages is intuitive at all. I now have a ext file source connection callled 'Conect1' with a hardcoded tx...
I have a DTS package that imports a text file into a table. I have a stored procedure that uses xp_cmdshell to run the DTS package using a dtsrun command line. My user is the creator of the ...
