|
Execute DTS with userid
How do schedule a DTS package to run at certain time using a certain userid?
Thanks, ...
Fri, 14 Jan 2005 11:41:08 -0800
|
get text files from a folder
Hi all!
I have a package that imports data from a text file, located in an specific
folder.
My problem is that many files can be inside the folder and their names are
unknown for me. How can I find out the name and quantity of files within the
folder, and use these informations into a dynamic task to start ...
Fri, 14 Jan 2005 15:59:25 +0100
|
Running DTS package as a Job
I am trying to run DTS pakage as a job and the job fails because it
does'nt have read access to required files in the file system. The job
runs to completion when run from the console but not from CmdExec in the
job. The files and directories have full control for all users. Any
ideas.
*** Sent via Deve ...
Fri, 14 Jan 2005 09:48:57 -0800
|
Column Order in reverse order in Transformation Options
In a DTS package, I am trying to define the transformations between the
source and the destination. I have selected the "Copy Column" type and went
into the "Transformation Options" dialog box. I selected my source columns
and my destination columns. My problem is that when I then hit the
"Properties" bu ...
Fri, 14 Jan 2005 09:23:06 -0800
|
Foxpro Import to SQL Server Help
Hi,
I have a foxpro database--not sure what version, but it is a .dbf file and
I know it is foxpro. I need to get the data out of the database and into sql
server, so i run my DTS, and I am asked for a data source. I then select
Microsoft FoxPro VFP Driver(*.dbf).
Then, I go to create a DSN for the ...
Fri, 14 Jan 2005 08:39:08 -0800
|
Loop through a table and assign a value to a global variable
Hi,
I have 2 tables: 1 contains postcodes and map coordinates - tblpostcodes.
The other contains new locations with postcodes and map coordinates
tblpostcodes - tblnewLocations. eg:
tblpostcodes
------------
ID Postcodes Col1 Col2
1 GU6 8NQ 504.5 139
2 GL20 5PA 389.2 232.6
tblnewLocations
...
Fri, 14 Jan 2005 08:23:03 -0800
|
Fact Table Population ...
Hi All,
Can any one give me an idea in how to plan the popluation of Fact Table
in a ware house ?.
...
14 Jan 2005 07:14:01 -0800
|
Please help. CSV problem.
Whilst importing a CSV file, DTS fails on fields with commas in them.
The text fields are surrounded by quotes and I've managed to get other
pieces of software to successfully read the file, but not Microsoft
Office products.
DTS seems to have set the Text Qualified property to Double Quote{"}
and I'v ...
Fri, 14 Jan 2005 13:01:05 +0000
|
Connection test
How would you test if there is established connection to a data source and
then use this information
when continuing...?
If no connection abort operation....
...
Fri, 14 Jan 2005 13:25:40 +0100
|
Missing steps when opening a SQL 7 package in SQL 2000 EM
Hi,
I am trying to make a working SQL 7 DTS export package for exporting
data to ms access, to be run on macines using MSDE 1.0.
In the VB program that I have developed, it looks like if some steps
are missing, which causes errors when executing the package.
I decided to open the SQL 7 package on my SQL ...
14 Jan 2005 00:39:56 -0800
|
DTS Disigner. Bug or Feature?
Hello
Why DTS Designer doesn't shows description of Data Transformation Task, as
it does make for any other kind of task? It's pretty uncomfortably.
Thanks,
Vladimir Chtepa
...
Fri, 14 Jan 2005 08:43:04 +0100
|
Compare data
How do I compare data in 2 tables if tables are located in
2 different sql servers? ...
Thu, 13 Jan 2005 11:30:38 -0800
|
Accessing Source File on Client
I have a DTS that access an .XLS file and imports the content to a SQL
Server table. I am executing the DTS via a Windows .Net application which in
turns calls a store procedure which actually initiates the DTS Package.
Folder/File permissions are set correctly. In fact, I do the below as the
Administr ...
Thu, 13 Jan 2005 10:19:02 -0800
|
Using DTS Dynamic Properties
Hi,
I have used the DTS Wizard to generate a DTS script
that migrates table data from a Sybase DB to SQL Server.
I now want to be able to plug in the DTS Dynamic
properties such that I can change both the Source and
Target databases.
I'm hoping I do not have to edit the original tasks
that were genera ...
Thu, 13 Jan 2005 09:08:40 -0800
|
Write to Application Log From DTS
Hi,
Is it possible to write to the application log from within a script in an
ActiveX task? It's pretty easy to do with a custom task in VB, and there's
also an undocumented system stored procedure that let's you do it (although
you need to be running under high priveledge to use it), but is there an
eas ...
Thu, 13 Jan 2005 16:35:17 -0000
|