Hi,
I would like to import several text file in SQL 2005 using bulk insert. Can anyone please tell me how to do it?
Thanks
I've recently upgraded to SQL 2005. Using the legacy tools, I have a DTS package that I made changes to. Now there are multiple versions of that DTS package. In 2000, you could just right ...
DTS package was created in SQL Server 2k. The package runs an ActiveX script to check if a file exists in a directory. If so, it moves the file to a new location, creates the result table from...
I have a SQL Server 2005 database hosted with a third party. I want to create a copy of the whole database, including schema, data, stored procedures - everything. This copy is to be used loca...
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...
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 Experts,
I have problems running a simple activex Script in a SSIS Job.
The Script:
'**********************************************************************
' Visual Basic ActiveX S...
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 ...
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...
Question:
I import tables and views from server A to server B use DTS Export/Import Wizard Microsoft SQL Server 2000.
The message windows said successfully 1 copied table(s) from Microsoft S...
What is the command to get a listing of all the dts package names, package id and version names? I try and run MSDB..SYSDTSPACKAGES but get an error saying... The request for procedure 'sysd...
I have an ActiveX task in a DTS package (SQL Server 2000) that is building a .cmd file that I wish to then execute from within the script. The code I have is shown below. The data shown in th...
I need to register my server on SQL 2000 Enterprise Manager in order to use the Data Transformation Services to import / export tables (was using it before, but managed to delete the server in...
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...
I support a DTS package writtern by someone else. One part of it is to send email.
This has been working fine for 18 months.
Today the email part ofthe DTS package failed - it said one o...
I have a job that kicks off about 6 different steps, each step is its on dts. So i used the dtsrunUI to create the command argument but i get the following error "Error 170: Line 1: Incorrect ...
Bit of a conundrum here. SQL server management studio has a generate scripts function that allows you to script any operation that it performs, except one. It doesn't offer the ability to scri...
Hi Experts,
I have one package with several shapes.
This package should be executable for different countries.
That means e.g.
There is a Data flow shape with a flat File Source and a ...
When loading SQL I dont get the icon in the system tray like I used to - Where has it gone?
hey there
i have an access Db that i down-sized friom an SQL database. the export did not maintain the autonumbers in the database tables.
i know that i cannot swuthc them onto auto numb...
The scenario is: I have a C# .Net ASP 2.0 application and it is a executable file, when this executable file runs it generate a XML file. I have to send this XML file to a ftp site every hour....
Hi,
How to create CVS file using SQL 2005.
Hi all, I am trying to use a DTS package to move a worksheet to the first of my workbook. I can do this in VB with no problem, but DTS doesn't like this command.
objExcelMaster.Worksheet...
Hello,
I have few question about SSIS
1)I am trying to transfer data into SQL in SSIS project.
I can successfully transfer data into new table. However date/time in text file is not bei...
I upgraded our production server to SQL 2005. I had several DTS jobs that had Analysis Services cube refreshes in them. However, even with the DTS conversion tool package loaded, when I run ...
