Tag Info

Hot answers tagged

5

have built my SSIS packages to check and make sure that the day isn't a holiday by comparing the date to a table that contains holidays. You can have your 1st job step as IF EXISTS (SELECT 1 FROM HolidayTable WHERE Date = GETDATE()) begin RAISERROR ('There is nothing to run as today is holiday !', 16, 1) end else print 'The job can run .. ...


2

How about making use of the OUTPUT virtual table? Set your transaction isolation level correctly (snapshot/serializable) so that you only see the rows as of the moment your process begins. Use the following for your OLE DB Source UPDATE T SET Archive = 1 OUTPUT DELETED.* FROM Table T WHERE T.Archive = 0; That updates everything in a nice atomic ...


2

Since you are using SSIS and capturing the changed rows, you should have SSIS capture the PK values for the rows that are being processed. The last step of the package should be to do a targeted update on the source table, setting the [Archive] field to 1 based on those PK values. And if not already done, the update trigger needs to exclude those changes ...


2

The issue is caused by a clash in code pages between 1252 (i.e. Windows-1252) in SQL Server and 65001 (i.e. UTF-8) that your CSV file is expecting. I believe one solution to the issue would be to CAST your source columns to NVARCHAR in the initial SELECT from the database, or use a Data Conversion task to convert them to Unicode strings. An alternative ...


2

I think you need to be clearer on your exact intended setup. That will allow for a better reading of those two linked questions. I would guess that those two links are actually irrelevant. SQL Server Express comes with a stripped down version of SSIS (or can be installed via the Tools or Advanced install), according to Link #2. But yet your question regards ...


1

Permissions to assign her are going to be based on what deployment model she is going to use within your environment. SSIS 2012/2014 added an additional model: Project and Package For Package Deployment model she has the option of deploying the packages to msdb. Granting her permissions for this type of deployment you will grant her permissions to an SSIS ...


1

Pls make sure you have tried the solutions below Set DelayValidation property set to True for the Send Mail Task. Close the filestream of the log file before sending the email


1

First make sure that you are able to connect FTP server through windows explorer, and then try three things For Package: 1- Package Protection Level= EncryptSensitiveWithUserKey For FTP Connection Manager: 2-Server Port= 21 3-UsePassiveMode= False


1

Change Tracking (CT) and Change Data Capture (CDC) are built into SQL Server. CT can identify the rows which changed since you last asked. CDC can provide a complete history of all data changes since you last asked. Both are easily manipulated from SSIS. There will be no need to reset flags per row after processing. The system handles all this through ...


1

Batching large data sets into smaller data sets, e.g. 100,000 rows or 1,000,000 rows will make the load run better than One Big Insert. But the same is true from SSIS, of course, as it batches inserts. The difference in time that you show in your example is fairly small. That does not give much hope for great speed improvements, but it does encourage you ...



Only top voted, non community-wiki answers of a minimum length are eligible