Alternative (or solution) to DTS Parameter ?
Sat, 6 Sep 2008 06:43:49 -0700 (PDT)
Morning All,
I've got a DTS package that takes data from a Pervasive Database into
a SQL Database.
In the query I am using a WHERE clause that instead of your normal
"column name between variable x and variable y" I am doing a "variable
x between column name a and column name b"
When I subsitute the vari ...
|
Output to a .txt File
Fri, 5 Sep 2008 10:20:01 -0700
Can I use a DTS package to output to a .txt file? How? And can I somehow get
the record count previous to writing the .txt file and put the record count
line at the top?
The .txt file has to be delimted.
Thanks in advance.
PSULionRP ...
|
Import Wizard Query
Thu, 04 Sep 2008 21:20:22 -0400
When using the Import Data Wizard in SQL Server, part of the process
allows me to enter a query to import data from the source server and
database. Does this query execute on the destination computer or the
source computer?
In my situation, I use the Import Wizard from a local instance of SQL
Server connec ...
|
DTS Designer in SSMS 2008
Thu, 4 Sep 2008 14:04:01 -0700
Has anyone been able to get the DTS designer to work in the 2008 management
studio? I had it working in 2005 SSMS, now it will not work in either SSMS.
I've tried all combinations of uninstalling the DTS components, and also
copying over the DLLs as mention in the Microsoft article. The 2008 SSMS
still says ...
|
Need a DTS to run multiple data sources.
Wed, 03 Sep 2008 22:11:36 GMT
I am running SQL Server 2000 SP4. My problem is I need to run
sp_reinitsubscription for multiple publications. I try setting up a DTS that
has multiple data sources and Execute SQL Tasks, but my execute seems to fail.
All my publications are in 1 instances, but spread out among the databases.
Any ideas on how ...
|
get error message on error in SSIS
Wed, 3 Sep 2008 07:17:36 -0700 (PDT)
Hi All,
I have an an ssis package with a lot of sql tasks. After finishing the
first task it goes to the next and so on.
All tasks on error (the red line) go to one sql task where I update
the status of the request. How do i get the actual error message in
the the error Sql task
TIA ...
|
Load INI file dynamically in diff environment
Wed, 03 Sep 2008 09:28:40 GMT
I have a dts created in SQL 2000 that loads an INI file to read some file
location. To make it work in different environment [Dev, UAT, PROD], i have
to manually open DTS and map the Dynamic Property Task Property to the
correct INI file, Is there any way to load the INI file dynamically across
different environ ...
|
|
|
How to determine folder from one month ago.
Tue, 2 Sep 2008 14:49:01 -0700
Hi,
I have a DTS package that is run once a month using a text file sent to us
by our customer. Each month we get a new data file and it's placed in a new
folder with the current date. The format of the date is YYMMDD. So for
instance the August file was placed in the folder created and named as 080806.
...
|
SSIS 2008 and MOSS 2007
Tue, 2 Sep 2008 05:41:11 -0700
Does exist a simple task (or manner) to export data from a MOSS list to a SQL
table by using SSIS 2008?
Thanks ...
|
Uploading German characters from Excel sheet using DTS package
Mon, 1 Sep 2008 08:54:01 -0700
When trying to upload German characters from an Excel sheet to a database
table using DTS package the following happens:
Characters can be read in the Excel sheet. After uploading, the characters
cannot be read from the database table. The characters are replaced by a
square.
Does anyone know what I shou ...
|
