The Execute Package Task and a second instance of Business Intelligence Development Studio can be a satisfactory method of background execution of SSIS packages in batch mode when you don't have access to Integration Services.
2017-07-11
1,083 reads
The Execute Package Task is an essential tool for any SSIS developer. Learn how to get the most from it.
2017-07-06
11,114 reads
How can I change the following so REPLACE "writes" changes to the database instead of the current "display new results, don't write changes" like it currently does ?SELECT REPLACE(NAME, SUBSTRING(NAME, CHARINDEX('2004', NAME), 4), '2005') FROM dbo.[PRODUCT] WHERE (NAME LIKE '%2004%')
2005-02-01
1 reads
Hello,what I suggest you is to create cursor with your DB names and to run DATABASEPROPERTYEX( database , property ) function inside that cursor
2005-02-01
Phew! Glad to know that your jobs are secure! As far as how often I test backups, not nearly often enough. Basically, whenever someone requests a copy of their production database, disaster recovery tests (about every 6 months, and not all servers or databases), when it is actually needed, or when I suspect that there […]
2005-01-31
I read this article today and thought you might be interested:U.S. businesses will add IT staff this year as they start new projects and seek desired skills, such as wireless networking expertise and integration. Harvard Medical School and CareGroup Healthcare System CIO John Halamka plans to hire five new networking, wireless, and security experts this […]
2005-01-31
My suggestion would be to create a temp table of the attributes (attrID and value) from the tblSearchCr table (ignoring non supplied entries). Count the number of rows in that table (for use see later). Left Join this table to each attrSFloat, attrRFloat and attrString table and assuming attrID can only exist in one of […]
2005-01-26
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers