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...
--Ramesh
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...
--Ramesh
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...
--Ramesh
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...
--Ramesh
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
...
--Ramesh
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...
--Ramesh
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,...
--Ramesh
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
...
--Ramesh
March 17, 2009 at 9:49 am
Lynn Pettis (3/17/2009)
ALTER TABLE [ database_name . [ schema_name ] . | schema_name ....
--Ramesh
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...
--Ramesh
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.
--Ramesh
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.
--Ramesh
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 ,...
--Ramesh
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...
--Ramesh
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...
--Ramesh
March 16, 2009 at 10:52 am
Viewing 15 posts - 406 through 420 (of 1,124 total)