Viewing 15 posts - 61 through 75 (of 540 total)
I have made some progress (rightly or wrongly).
Steps:
1) I created Integration Services Catalog
2) I imported my package
3) I configured my package (Connection Managers > FTP Connection Manager >...
March 27, 2015 at 4:33 am
I may sleep on it and revisit tomorrow as my head is spinning 🙂
Phil.
March 26, 2015 at 10:37 am
Thanks Phil. I will take a look but do not hold out much hope!
Phil.
March 26, 2015 at 10:29 am
Hi Phil.
Are you using Don't Save Sensitive as the package isolation level and then passing the password to the package as a 'sensitive' SSISDB environment parameter?
I am using 'Don't Save...
March 26, 2015 at 10:09 am
OK so now I have a new issue. When I import the package into SQL Integration Services then create a job to run the package it fails to FTP the...
March 26, 2015 at 9:38 am
Hi Phil. It defaulted to values InputColumnWidth = 1 OutPutColumnWidth = 1 (the output value for this column was Y). Manual update made no difference and the values defaulted back.
I...
March 26, 2015 at 7:00 am
Thanks for the link. I have a step before the restore as follows:
-- Create the sql to kill the active database connections
DECLARE @execSql varchar(1000)
DECLARE @databaseName varchar(100)
-- Set the...
February 10, 2015 at 5:28 am
Hi. I backup the production system lets call it 'Live.bak' to location x and call it DEV.bak I then restore DEV.Bak to the Dev System.
Steps in Job as follows:
Backup
BACKUP DATABASE...
February 10, 2015 at 4:15 am
Hi. I have checked the logs and found the entry below for one of the failures:
2015-02-09 16:59:17.18 spid69 * BEGIN STACK DUMP:
2015-02-09 16:59:17.18 spid69 ...
February 10, 2015 at 4:08 am
WITH MOVE option appears to have done the trick.
RESTORE DATABASE Training
FROM DISK = 'H:\DB.bak'
WITH
MOVE 'File_Data' TO 'X:\DB.mdf',
MOVE 'ftrow_fulltext_catalog' TO 'X:\ftrow_fulltext_catalog_db.ndf',
MOVE 'File_Log' TO 'W:\DB_log.ldf',
RECOVERY, REPLACE, STATS = 10;
Phil.
February 9, 2015 at 11:02 am
A server re-boot appears to have resolved the issue. I am now able to execute backups and maintenance plans appear to run OK.
Prior to the reboot I noted when running...
February 9, 2015 at 10:19 am
🙂
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
Thanks,
Phil.
February 9, 2015 at 9:39 am
Hi.
Backup failed for Server 'SERVER-NAME'. (Microsoft.SqlServer.SmoExtended)
System.Data.SqlClient.SqlError: BACKUP DATABASE is terminating abnormally. (Microsoft.SqlServer.Smo)
Kind Regards,
Phil.
February 9, 2015 at 9:32 am
Viewing 15 posts - 61 through 75 (of 540 total)