Viewing 15 posts - 1 through 15 (of 23 total)
In addition, that function acts as a correlated subquery; it is executed for each record in the result set. Although it may be just a union of two tables...
January 21, 2012 at 10:02 am
It appears you may be attempting to convert a string that is not in a proper date/time format. For example your string may be '15/35/2012 27:72:66.123'; there's no Month...
January 21, 2012 at 8:22 am
(…eye twitching…)
You struck a nerve…
http://msdn.microsoft.com/en-us/library/aa175244(v=sql.80).aspx
http://msdn.microsoft.com/en-us/library/ms181055.aspx
The two links provided are similar; ones for SQL Server 2000 while the other is for SQL 2008 R2.
Bad code is bad code. If you’re...
January 20, 2011 at 1:44 pm
I'm hoping to have it completed over the weekend. I have a C# class library that I use and want to reproduce it in VB after I clean it...
January 7, 2011 at 9:29 am
Bill,
Thanks, I'm glad it was useful. I'm putting together another article describing how to build the PackageVariable nodes. I have methods for creating the Pipeline Paths and Precedence...
January 6, 2011 at 6:45 pm
As Adi an Paul say, replication may be your best choice if you're not too far down the road. However, if you're dealing with something like clients having their...
December 29, 2010 at 5:54 pm
Jason,
I’m glad you found this useful. As I stated in the article annotation will do nothing for your SSIS package performance, but will make it easier to read....
December 20, 2010 at 11:10 am
From the menu bar Tools>Options:
In the Options dialog box, select Integration Services Designers under the Business Intelligence Designers, in the left panel. Then select the language in the Language...
December 17, 2010 at 12:58 pm
Have you ensured your variables are listed in either the ReadOnlyVariables or the ReadWriteVariables in the Script Task Editor? Or are your variables in a different namespace?
December 16, 2010 at 11:21 am
Dave,
Sorry I mispoke, I was referring to /*comment*/ or -- comment as "any comment line" and should have clarified. Anything before the SELECT statement will disable the SQL from...
December 13, 2010 at 8:32 am
Dave,
Great catch! I was just composing a sarcastic response about the fact that the oledb connection does not allow comments when I switched back and saw your response.
I don't...
December 13, 2010 at 7:12 am
In general, processing will be done on the server where the packages are running. There are situations that you could initiate a stored procedure on a remote server that...
December 12, 2010 at 8:37 pm
Abhas,
Go ahead and look at the attachment. I don't know what I'm doing wrong on the Execute Process task (UnZip File), but it's not unzipping (expanding) the zipped log...
December 8, 2010 at 2:48 am
Abhas,
You can use the Execute Process Task and File System Task to perform your operations. Create the necessary variables so that you can configure your package and applying these...
December 6, 2010 at 4:38 pm
SELECT id,companyname, Count(companyname) - 1
FROM prospects
GROUP BY companyname,id
HAVING Count(companyname) > 1
why does it give NO results? Propably because id is unique, but how can I select it anyway?
You...
November 24, 2010 at 4:21 pm
Viewing 15 posts - 1 through 15 (of 23 total)