Viewing 15 posts - 406 through 420 (of 1,124 total)
I don't think it's possible to do a "regEx" search using standard SSIS components (such as Conditional Split) because of non-availability of "regEx" functions in SSIS.
Other option is...
March 18, 2009 at 1:18 am
What errors do you get when executing the query?
Has the Login/Service Account has read permissions on that folder? If the file is in the network drive (i.e. on a...
March 18, 2009 at 12:45 am
I really loved the colored output:-D, it makes real easy to read the code. But there seems to be some problem with the text "ADD" as it adds itself...
March 17, 2009 at 12:15 pm
As Adi said, you can add both column as well as constraint in a single ALTER statement:
IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'type_of_fraud' AND COLUMN_NAME = 'matchfile_autoload')
BEGIN
ALTER...
March 17, 2009 at 12:07 pm
Add a script component (of data flow task) between Source & Target components.
The VB.NET Code should be something like:
Imports System
Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper
Imports Microsoft.SqlServer.Dts.Runtime.Wrapper
Public Class ScriptMain
Inherits UserComponent
...
March 17, 2009 at 10:30 am
You have to explicitly specify that you want the value of IDENTITY column to be generated by SQL Server. This can be set by un-checking the "Keep Identity" property...
March 17, 2009 at 10:18 am
Florian Reischl (3/17/2009)
If you don't use an IDENTITY column you can import the date into a temp table and use the following statement to add an incremental id:
This should work,...
March 17, 2009 at 10:02 am
nabajyoti.b (3/17/2009)
Now, i dont know the relevance. But i am tempted to ask, is it possible in Oracle?
Yes, it's possible in Oracle. This should work:
ALTER TABLE SomeTable
...
March 17, 2009 at 9:49 am
Lynn Pettis (3/17/2009)
ALTER TABLE [ database_name . [ schema_name ] . | schema_name ....
March 17, 2009 at 9:42 am
It's not possible to ALTER more than 1 column in a single ALTER TABLE statement, you have to write 2 different alter statements.
Straight from BOL:
ALTER TABLE table_name
{ [ ALTER COLUMN...
March 17, 2009 at 9:40 am
Does the RowID needs to be arbitrary? If not, then you can add an IDENTITY column to your destination table and leave the complexity for SQL Server to handle.
March 17, 2009 at 9:31 am
Yes, you can update the value of variable from within the script task. Cross check the updated value of the variable after the script task using breakpoints.
March 17, 2009 at 9:27 am
Like "InStr" function, "CHARINDEX" function returns the first occurrence of the specified text within another text from a specified position. For e.g.
The syntax for the functions are:
InStr( SearchTextFromPosition ,...
March 17, 2009 at 9:22 am
You have to explicitly set "Connection String" property (through Expressions) of the Connection Manager to the value of a variable (that resides in the configuration file).
"Delay Validation" just skips...
March 17, 2009 at 4:39 am
Well, in that case, this should do:
SELECT( CASE WHEN CHARINDEX( ' ', FIRST_NAME ) > 0 THEN SUBSTRING( FIRST_NAME, 1, CHARINDEX( ' ', FIRST_NAME + ' ' ) - 1...
March 16, 2009 at 10:52 am
Viewing 15 posts - 406 through 420 (of 1,124 total)