Viewing 15 posts - 196 through 210 (of 319 total)
Data_God (8/25/2011)
Could someone explain why the script below allows...
August 25, 2011 at 6:23 am
great question!!!!
WOW!!! 59% of incorrect answer!!! for a conceptual question!!!!
August 25, 2011 at 5:14 am
great question!!! thanks!
August 22, 2011 at 9:10 am
Tom.Thomson (8/17/2011)
August 17, 2011 at 6:00 am
....
(ii) Tested out with same DB(1) with [DT_DBDATE] as Data type from the Derived Transformation ( where only date is picked up yyy/mm/dd). Its's Good.
the 2nd situation, worked on your...
August 16, 2011 at 11:43 am
(Dt_DBTimeStamp)Getdate() .... this is the one in the Derived Column
And then mapped this as an input to the Destination ( column Smalldatetime )
try this: (DT_DBDATE)GetDate()
August 15, 2011 at 7:16 pm
what's your data source??
is a table? in another server, for example Oracle or Text File?
the destination table, we know!!
August 15, 2011 at 11:56 am
your conversion is dt_dbtimestamp to smalldatetime???
August 15, 2011 at 9:55 am
according with microsoft's article http://msdn.microsoft.com/en-us/library/ms141704.aspx that show the convesions illegal/legal to differents data types of SSIS.
quillis131 (8/15/2011) It was running very sucessful, during Development.Verfied the Destination table Datatype on the...
August 15, 2011 at 9:54 am
ANSI_PADDING and ANSI_NULLS are options that will be ON!!! like too CONCAT_NULL_YIELDS_NULL
ANSI_NULLS = http://msdn.microsoft.com/en-us/library/ms188048.aspx
ANSI_PADDING = http://msdn.microsoft.com/en-us/library/ms187403.aspx
CONCAT_NULL_YIELDS_NULL= http://msdn.microsoft.com/en-us/library/ms176056.aspx
August 15, 2011 at 5:22 am
Viewing 15 posts - 196 through 210 (of 319 total)