Viewing 15 posts - 16 through 30 (of 157 total)
Did u try to see the values in SSIS using data viewer in between source and conversion Task.. Try to see what value is coming in from Excel and please...
July 29, 2010 at 1:27 pm
Try using Row_Number() Function then you can alter the table to make it a primary key
July 14, 2010 at 2:34 pm
I am not much familiar with ActiveX script task. I did use it when migrating from DTS and had the same problem... so slowly changed the code to Vb.net .....
July 14, 2010 at 2:29 pm
If you just need the 1st 8 character.. Then use {LF} as your Row and Column Delimeter and then you can use derived column to get the 1st 8 characters...
July 14, 2010 at 12:44 pm
You can use ActiveX script task in Control Flow to write your VB code.. But its not suggested as its being deprecated
July 14, 2010 at 12:35 pm
Novicejatt (7/14/2010)
July 14, 2010 at 12:26 pm
itsaditi2001 (7/14/2010)
Yes , i changed the properties of excel connection manager but still can't load the leading zeros..
Did you Change the IMEX Value to 1 ? If the Number of...
July 14, 2010 at 9:33 am
Novicejatt (7/13/2010)
Yes I can do that, but I was thinking not to import in the first place. I guess I will Drop them after importing.Thanks Guys.
If you just want to...
July 14, 2010 at 9:10 am
That's true.. you need to convert it to varchar to get the leading 0's.. You might not see the leading 0's even if you change it to varchar, because Excel...
July 14, 2010 at 9:01 am
Same way as you have inserted the data into Temp table... 🙂
Select a Source and Write a select statement or select the temp table from the drop down.. you...
July 14, 2010 at 8:58 am
Phil Parkin (7/13/2010)
You'll have a problem with September if you use that code verbatim!<= 9 works better 🙂
Thanks for correcting it 😉
July 13, 2010 at 7:12 am
Try this. I did not test it, but it might work
Dim fileDate As String = year(today()) &"0" & month(today()) & day(today())
OR
IF month(today()) < 9
Dim fileDate As String = year(today())...
July 12, 2010 at 9:18 pm
lynns (6/9/2010)
Try the following modification to the Switch statment (changed the arithmetic operators)=Switch(DateDiff("m",CDate(Fields!ActsDate.Value),CDate(Fields!DecisionDate.Value))>6,"Red",DateDiff("m",CDate(Fields!ActsDate.Value),CDate(Fields!DecisionDate.Value))<=6,"Black")
lol 🙂 Thanks for correcting it Lynn
June 10, 2010 at 8:05 am
It runs good in sql analyser but does not return data in SSIS
It runs fine in SSIS also, It might me the datatype mismatch and also check on what others...
June 9, 2010 at 7:24 am
Trying using a switch Case Like Below
=Switch(DateDiff("m",CDate(Fields!ActsDate.Value),CDate(Fields!DecisionDate.Value))>=6,"Red",DateDiff("m",CDate(Fields!ActsDate.Value),CDate(Fields!DecisionDate.Value))>=6,"Black")
June 8, 2010 at 7:51 am
Viewing 15 posts - 16 through 30 (of 157 total)