Tuesday, April 16, 2013

[SQL Server] How to add variables to a table in SSIS

[SQL Server] How to add variables to a table in SSIS

How to add variables to a table in SSIS

Posted: 16 Apr 2013 07:56 AM PDT

Hi all, I'm in need to import several flat files into a SQL table. I'm used to importing one at a time, but I'm new and starting to figure out SSIS. I do need to update a field in the destination table with the filedate (which is not always the current date or in any consistent format). So I was wondering if there are any methods to input this date variable in SSIS.

Checkpoint Background Process

Posted: 16 Apr 2013 03:15 AM PDT

Hi All, I'm new to SQL DBA tasks. I noticed in sp_who2 output a database is showing checkpoint as shown below. I had the transaction log fill up for this database and didn't understand why the log would not clear out even though it is running trans log backups.Is this process hung since output shows date of 03/08/13? I assume checkpoint is a regular automatic process. SPID Status DBName Command CPUTime DiskIO LastBatch13 BACKGROUND Micro_AB CHECKPOINT 3861851 123296 2013/03/08 10:43Thanks-Alison

Backup failed

Posted: 20 Aug 2012 05:55 PM PDT

Hello Masters,My daily differential backup job failed for user databases. all the user database are in simple recovery model. Below is the error log, any clarification are welcome:messageExecuted as user: FRAHTNIMBUS\SYSTEM. ...parameters not set correctly, or connection not established correctly. End Error Error: 2012-08-20 12:00:15.24 Code: 0xC002F210 Source: Back Up Database (Differential) Execute SQL Task Description: Executing the query "BACKUP DATABASE [ReportServerTempDB] TO DISK = N'E:\SQL_BACKUP\Capgemini\User Diff Backup\ReportServerTempDB\ReportServerTempDB_backup_201208201200.bak' WITH DIFFERENTIAL , NOFORMAT, NOINIT, NAME = N'ReportServerTempDB_backup_20120820120015', SKIP, REWIND, NOUNLOAD, STATS = 10 " failed with the following error: "Cannot perform a differential backup for database "ReportServerTempDB", because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option. BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set ... The package execution fa... The step failed.Failed:(-1073548784) Executing the query "BACKUP DATABASE [ReportServerTempDB] TO DISK = N'E:\\SQL_BACKUP\\Capgemini\\User Diff Backup\\ReportServerTempDB\\ReportServerTempDB_backup_201208201200.bak' WITH DIFFERENTIAL , NOFORMAT, NOINIT, NAME = N'ReportServerTempDB_backup_20120820120015', SKIP, REWIND, NOUNLOAD, STATS = 10" failed with the following error: "Cannot perform a differential backup for database "ReportServerTempDB", because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option. BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog