DTSrun without default options
Wed, 2 Jul 2008 10:47:12 -0300
anyone knows how to setup the dts run options to:
Source:
Server: remote
auth Mode: SQL
Username: xxx
Password: yyy
Database: bbb
Destination:
server: local
auth mode: sql
username: sa
password blank
database bbb
Copy objects anda data between sql server dat ...
|
DTS - Extracting SQL data based on a Date
Tue, 1 Jul 2008 12:58:59 -0700 (PDT)
SQL Server 2000 -- DTS Package Fails with error: Invalid procedure
call or argument 'DATEDIFF'. This works in a view. Is there a
better way to do this?
What I am trying to do is transfer only yesterdays data (i.e., Now()
-1) to a delimited text file.
Function Main()
IF (DATEADD(dd, 0, DATEDIFF(dd, ...
|
DTS -- Extracting Data using Date Criteria
Tue, 1 Jul 2008 10:50:49 -0700 (PDT)
Hello All!
I have a DTS package that includes all records in the database:
'**********************************************************************
' Visual Basic Transformation Script
' Copy each source column to the
' destination column
'***************************************************************** ...
|
script to backup DB with DTS
Tue, 1 Jul 2008 12:33:00 -0300
Hi...
I have this condition:
2 SQL servers....1 local, 1 remote...
Every friday I have to backup around 15 databases from the remote to the
local...
I would like to use some batch to do this...
does anyone have any sql script ou vb6 / vb.net / c#.net script that
does this?
nor c ...
|
How to solve the SSIS deployment issue :(
Mon, 30 Jun 2008 02:25:04 -0700
Hi experts,
I have no idea why development of SSIS is easy but is hard when comes to
deployment with the wizard and copy the installation "deployment" folder on
the destination server..
The error message is "The AcquireConnection method call failed with error
code 0xC0202009. "
Please provide steps to ...
|
How to set the Script Manager Database Connection String
Sun, 29 Jun 2008 08:33:10 -0700 (PDT)
Hi,
I am using the Script manager within SSIS to execute query. Currently
I have the connection string hardcoded. How do I tie the connection
string to the DTS package Connection Manager Connections so there is
only one place to change the connection for all Script Managers within
the package?
Public S ...
|
problem on ssis
Sun, 29 Jun 2008 13:02:44 +0300
Hello there
I havs ssis who transfer data between two databases.
The process worked fine until i change the password on the destination
databasse.
Since then it won't work: after i set on Protection level: Service storage
and try to save the package it brings me an error:
...cannot be used when savin ...
|
|
|
Using DTS to Extract Yesterday's Data
Sat, 28 Jun 2008 06:48:17 -0700 (PDT)
I am trying to set up a DTS package that extracts all of Yesterdays
data. The code that I am using works great in a view by converting a
DateTime stamp to just a short date, then displaying just the
GetDate() -1 (i.e., yesterday). It does not work with DTS. Any help
with this greatly appreciated. Here is the ...
|
SSIS to file export procedure problem
Fri, 27 Jun 2008 16:00:01 GMT
Hello,
I have a stored procedure to export DTS packages to files and I'd like to
modify it to do same for my SSIS packages, so I have modified the procedure
like that:
CREATE procedure [dbo].[s_SavePackages_90]
@Path varchar(128)
as
set nocount on
declare @objPackage int
declare @PackageName varch ...
|
Executing a DTS Package from a VB Windows Forms App
Fri, 27 Jun 2008 06:26:43 -0700 (PDT)
I have a Windows Form application (not an ASP.NET app) where I would
like to execute a DTS package on my local SQL server instance. The
code looks like this:
Dim objDTSPackage As New DTS.Package
objDTSPackage.LoadFromSQLServer("(local)", "USERNAME", "PASSWORD",
DTSSQLServerStorageFlags.DTSSQLStgFlag_Defaul ...
|
