createing package on 2008
Tue, 9 Sep 2008 11:24:08 +0300
Hello there
My local computer has upgrated to 2008 and far server is still 2005.
I took package i've made on 2008 and save changes on my visual studio 2008
at my local computer.
How can i set it on far server in 2005 version?
...
|
connect to Intergration services
Tue, 9 Sep 2008 11:22:21 +0300
Hello there
I have an integration services on far server.
How can i access to integration services from my local computer?
...
|
Transactions in For Each Loop
Sun, 7 Sep 2008 20:34:00 -0700
Hi
I have a For Each Loop that iterates over the nodes in an XML document. The
For Each Loop contains a Sequence Container that wraps all the actual
processing elements (data flows and Tasks). I need to set up the Loop so that
even if a row fails processing, either in the Tasks or Data Flow, it is
skipped ...
|
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 ...
|
