Use Connections Properly in an SSIS Script Task
There are lots of scenarios in SSIS where you'd want to use a connection within a Script Task. Unfortunately, the...
2011-05-31
25,940 reads
There are lots of scenarios in SSIS where you'd want to use a connection within a Script Task. Unfortunately, the...
2011-05-31
25,940 reads
There are lots of scenarios in SSIS where you'd want to use a connection within a Script Task. Unfortunately, the closest help documentation - the comments inside the Script...
2011-05-31
1,544 reads
There are lots of scenarios in SSIS where you'd want to use a connection within a Script Task. Unfortunately, the closest help documentation - the comments inside the Script...
2011-05-31
The topic came up at work awhile back with using various includes/excludes such as IN, NOT IN, and EXISTS. A...
2011-05-31
1,364 reads
Security is an important consideration when designing a database application. Who can get access to what data? How much damage...
2011-05-31
2,095 reads
These are five rules for writing from Ernest Hemingway, which I like and recommend for use in your communications. Definitely...
2011-05-30
1,734 reads
What are the most influential papers in the world of Big Data? Let me suggest: http://bit.ly/BigData1 We face a data management problem: IDC 2010 Digital Unverse Study http://bit.ly/BigData2...
2011-05-30
7 reads
What are the most influential papers in the world of Big Data? Let me suggest:...
2011-05-30
3 reads
I have been compiling a list of what things a person can do to become an expert, or guru, in...
2011-05-30
5,061 reads
It’s Memorial Day, and as usual, I have a blooper reel for the editorial. However I couldn’t fit everything in...
2011-05-30
1,654 reads
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
Comments posted to this topic are about the item The Marked Transaction
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers