Viewing 15 posts - 2,431 through 2,445 (of 2,484 total)
Thanks Antares. Initial test performed great.
I'll link in the DTS logging tables so I can remove the old log records as well.
Thanks
Phill Carter
November 26, 2002 at 5:33 pm
When you're in Disconnected Edit, make sure you change the task that is associated with the step as well.
Thanks
Phill Carter
Edited by - phillcart on 11/26/2002 5:15:10 PM
November 26, 2002 at 5:14 pm
The 'DTSSQLStgFlag_Default' constant specifies that SQL Security is used.
For Winodws Authentication use the 'DTSSQLStgFlag_UseTrustedConnection' constant instead.
Thanks
Phill Carter
November 25, 2002 at 5:55 pm
How are you copying the database? Using the "Transfer Database" or "Copy Objects" task?
Thanks
Phill Carter
November 25, 2002 at 2:59 pm
1) Why do you want to delete the data in the worksheet? Wouldn't you just create a new file or overwrite the old one?
2) If you use Text file output...
November 25, 2002 at 2:54 pm
quote:
Look again under Advanced...You can set Global Variables, generate command line or even generate encrypted command line
November 25, 2002 at 2:44 pm
quote:
Check out dtsrunui. No more building parameters or jobs for dtsrun by hand. Excellent tool!
Pity...
November 25, 2002 at 5:27 am
quote:
I had no issues with SQL 2000 SP2. What version are you running so I am comparing Apples to Apples here?
November 24, 2002 at 5:01 pm
quote:
There does not appear to be a solution to run DTS with parameters directly from ASP. I believe the solution we're...
November 24, 2002 at 4:53 pm
By using DTSGlobalVariables.parent you are creating a package object which is referencing the current package.
You need to create a new package object to load your stored package into.
eg:
November 24, 2002 at 4:41 pm
This article is probably more what you're looking for.
http://www.databasejournal.com/features/mssql/article.php/1459181
It shows how to use the sp_OA procedures to set global variables on page 2.
Thanks
Phill Carter
November 21, 2002 at 3:38 pm
As you are using a variable, not a static value, you need to put the BULK INSERT statement inside an EXEC statement.
EG:
EXEC ('BULK INSERT CUSP001.dbo.tmpALDB_BI2 FROM... November 21, 2002 at 3:34 pm
Try something like
DECLARE @Err int
CREATE TABLE #Tmp (
PingText varchar(255)
)
INSERT INTO #Tmp
EXEC xp_cmdshell 'ping <your server ip address>'
SELECT @Err = COUNT(*) FROM #Tmp
WHERE...
November 20, 2002 at 9:16 pm
You need to use the RETURN statement, not RAISERROR.
eg: Return(1)
Thanks
Phill Carter
November 20, 2002 at 9:06 pm
Can you use ping via ExecuteProcess Task or xp_cmdshell?
Thanks
Phill Carter
November 19, 2002 at 9:04 pm
Viewing 15 posts - 2,431 through 2,445 (of 2,484 total)