Homeowner secured loans, fast secured loans in UK.
 SSIS- PARAMETERS IN SUBQUERY [1 reply]
microsoft.public.sqlserver.dts, Sunday, January 29, 2006
Hi,
I'm using ssis 2005 - I'm trying to create an ole db coomand which uses
parameters in sub-qyery:
SELECT vwContactInteraction.iContactID,
vwContactInteraction.iInteractionID, 1...
Improving the Sql environment at our Place ? [0 replies]
microsoft.public.sqlserver.dts, Saturday, January 28, 2006
I need to improve the sql setup at my current location (long term contract)
Currently there are
100+ msde installations (1 gb average running a retail back end processes)
Backup to dis...
Task FTP SQLServer 2000 [1 reply]
microsoft.public.sqlserver.dts, Saturday, January 28, 2006
Hello,
how can i send a file with the FTP Task direct from the SQLserver 2000
R
Stefan
dts error [1 reply]
microsoft.public.sqlserver.dts, Friday, January 27, 2006
I'm using sql server 2005.
I'm trying to create a package that import data from Oracle 10g to SQL
server 2005.
in the Data Flow Designer the OLEDB Source is displaying a warining icon
say...
Transfer SQL Server Objects Task - Change Schema - SQL 2005 [3 replies]
microsoft.public.sqlserver.dts, Friday, January 27, 2006
Hi there,
I have a development server where I have tables that are bound to the
dbo schema, I tried to use the "Transfer SQL Server Objects Task" to
transfer these tables to my hosting pro...
JOB fails immediately [2 replies]
microsoft.public.sqlserver.dts, Friday, January 27, 2006
I have windows2000 server
running sql server2000 sp4
with sqlmail installed, configured, and working.
Sql Server Agent is started using a dummy domain account with administrative
rights f...
Problem with ExecuteSQK Task in SSIS [0 replies]
microsoft.public.sqlserver.dts, Friday, January 27, 2006
Hi I am writing an app in c# that will create a package and utilise the
executesql task to execute some sql. from these task, i want to trap the
output via a varaible (or any facility avail...
=?iso-8859-1?q?Problem_importing_=A3_symbol_from_Excel_to_SQ... [0 replies]
microsoft.public.sqlserver.dts, Friday, January 27, 2006
I have created a DTS package (SQL Server 2000) to import data from an
Excel 2002 worekbook into a table.The problem I am experiencing is that
the =A3 sign is being translated as a =FA. Any id...
Db2oledb for SQL2005 used for SQL 2000 DTS [0 replies]
microsoft.public.sqlserver.dts, Friday, January 27, 2006
Hello,
Does anybody know if I can use the new oledb provider for DB2 that shipped
with SQL2005 feature pack on a SQL2000 box in order to create DTS jobs ?
Thanks
GM
Dynamic transformations in SSIS [1 reply]
microsoft.public.sqlserver.dts, Friday, January 27, 2006
Hi,
I would like to create a dynamic package which exports results of
different stored procedures
with select statement and different number of columns to a .csv file.
I've already got a sc...
load postscripts into sql [2 replies]
microsoft.public.sqlserver.dts, Thursday, January 26, 2006
We are having a website that generates postscript files when an order is
placed on it. These files are placed in a folder on the network.
I have been told to Load the postscript files into...
building a web site [0 replies]
microsoft.public.sqlserver.dts, fri,
I just got back working on my website. Its taken a long time to finish but I am getting there.
I got great web hosting at http://www.domainnamefree.net where I got a free .com name and a ...
Class not registered [0 replies]
microsoft.public.sqlserver.dts, Thursday, January 26, 2006
I have a DTS package that I create and execute from vb.net. It works fine on
my development machine, but when I move it to another computer it does not
work. I copied all the dlls and rll...
Load empy file [1 reply]
microsoft.public.sqlserver.dts, Thursday, January 26, 2006
Is it possible to load a blank or empty file with a data pump task? We have
a process that loads multiple files, and sometimes they contain data and
sometimes they don't. We don't know wh...
DTS to transfer data from different database failed [0 replies]
microsoft.public.sqlserver.dts, Thursday, January 26, 2006
My SQL server is SQL 2000. The DTS package uses SQL anthentication to
transfer data from database A to database B. It fails. The error message
shows Windows NT user or group 'A\Guest' not f...
DTS (Modify data written to tables based on input from txt f... [1 reply]
microsoft.public.sqlserver.dts, Thursday, January 26, 2006
Given:
I'm using a DTS Package to import data into a table. Each row from a text
file gets placed into a corresponding table.
What I need to do:
I'd like to modify the DTS Package to ch...
DST to copy from one database to another, but using a JOIN a... [1 reply]
microsoft.public.sqlserver.dts, Thursday, January 26, 2006
Hi All,
Firstly apologies for the obscure subject line.
The task I am try to achieve is to copy information from Database A on
Server 1 to Database B on Server 2.
I would like this to...
Unable to load DTS within SQL 2005 [0 replies]
microsoft.public.sqlserver.dts, Thursday, January 26, 2006
I installed the legacy component so that i can access SQL 2000 DTS packages
from within SQL 2005. It was working fine for several weeks but now I get
the following error:
"Unable to lo...
Archive - DTS problem [1 reply]
microsoft.public.sqlserver.dts, Thursday, January 26, 2006
I'm trying to implement an archive operation using DTS. In this case, data
from certain tables I need to overwrite in the destination DB, so I'm using
Copy SQL Server Object task, its fine....
SSIS in SQLServer 2005 Express Edition [1 reply]
microsoft.public.sqlserver.dts, Thursday, January 26, 2006
We've been trying to convert an application from MSDE to SQLServer 2005
Express Edition.
That application transfers some data form a SQLServer database to an
Access database and the other wa...
How to edit package which was created by Import and Export W... [1 reply]
microsoft.public.sqlserver.dts, Wednesday, January 25, 2006
Hi, All,
I want to edit a package was created by sql server Import and Export Wizard.
It did run great before. but I found there are some files or
innerpackage.dtsx were missing which wer...
Help with DTS packages!!! [1 reply]
microsoft.public.sqlserver.dts, Wednesday, January 25, 2006
Hi
Using DTS Packages:
I have to downlaod a file from ftp server which is not a problem, but this
file is a zip file which consists of a mdb file.
Now, is there a way to extract the mdb f...
Task status [1 reply]
microsoft.public.sqlserver.dts, Wednesday, January 25, 2006
Hi
I have DTS got 12 task, I am using on completion flow, even if task failed,
i want to continue to run other task, My question is, is there any way to
find out through workflow prope...
T-SQL strong. VBScript weak. Help? [2 replies]
microsoft.public.sqlserver.dts, Wednesday, January 25, 2006
I need an activeX script that will:
Query a table in my database:
Select FailReason from ErrorLog where DateOfFileCopy = getDate()
I want to store the result in a variable called fl...
Oracle driver [1 reply]
microsoft.public.sqlserver.dts, Wednesday, January 25, 2006
I have a DTS package that copies data from an Oracle db to a MSSQL db .
When I schedule this package to run on the target server, it fails with the
following error…
Step Error Source...
compare [0 replies]
microsoft.public.sqlserver.dts, Wednesday, January 25, 2006
I am new SQL
I have XML files (jobs) that are generated from a third party app on a
weekly basis.
My SQL application loads the the xml files for production.
>From time to time changes w...
Optimize transformation [3 replies]
microsoft.public.sqlserver.dts, Wednesday, January 25, 2006
I have the below table that I need to load about 1 billion records
into. I was wondering if anyone could offer some tips on how to
optimize the process.
I load data_table via a staging ta...
SQL Server 2005 Import and Export Wizard Error [0 replies]
microsoft.public.sqlserver.dts, Wednesday, January 25, 2006
I am getting the following error when trying to import data from a SQL Server
2000 database table to SQL Server 2005:
Operation stopped...
- Initializing Data Flow Task (Success)
- I...
Row delimeter issuein fixed length record [1 reply]
microsoft.public.sqlserver.dts, Wednesday, January 25, 2006
Hi,
The fixed length column input file includes the data from next record if
one or more of the previous record columns are missed.
Tried all the row delimiter (CF,LF,CF&LF).Is there an...
|
