Viewing 15 posts - 11,896 through 11,910 (of 13,401 total)
Can you confirm that if you fix up the header in the source file, everything runs OK?
If so, can you post some actual data - just the first couple of...
January 10, 2010 at 2:52 am
Bru Medishetty (1/9/2010)
Check if the last line has any additional data which does not align well with the rest of...
January 9, 2010 at 7:32 am
Or you can reverse the string and parse from the right - useful if there is a possibility of multiple '=' or ';' in your input strings.
REVERSE(SUBSTRING(REVERSE([Column 0]),2,FINDSTRING(REVERSE([Column 0]),"=",1) -...
January 8, 2010 at 11:56 pm
You can't easily parse that. I'd bring all the rows in to a single Varchar field and then use T-SQL to parse it.
If you want to exclude rows depending on...
January 8, 2010 at 11:22 pm
Gkhadka (1/8/2010)
... and use JOHN command in ur update SQL code.
Wow, did Mr Rowan get his own command? 😎
January 8, 2010 at 11:13 pm
Sounds to me like you are asking someone here to provide you with a working solution. That's not really how this forum works - people here will provide you with...
January 8, 2010 at 2:14 am
jyoti_bhatt (1/5/2010)
Name Address Phone Age
aaa bbb ...
January 5, 2010 at 9:55 am
Can you provide an example - just 3 or 4 rows - showing what you mean exactly by "blank with no data"? Can a column be "blank with some data"?...
January 5, 2010 at 9:24 am
Much easier - I always choose CSV over Excel, given the option.
January 4, 2010 at 3:50 pm
User::FileName
and it's case-sensitive.
January 2, 2010 at 11:31 am
Trick? 🙂
Why not use Windows Authentication - as desired - but have a File System task that runs first to copy the file to the local server? Then run your...
December 31, 2009 at 11:00 am
Dataflow with appropriate source and target connections.
December 31, 2009 at 2:35 am
It seems that you are not alone in having this problem. One solution might be first to copy the text file to a local drive on the server & then...
December 31, 2009 at 2:33 am
OK, I just read this a bit more carefully.
Can you confirm that the number of columns in the datasource and their names and their data types are always the same...
December 31, 2009 at 2:20 am
As Sabya suggested, please read up on the SCD component and then post back with any additional questions.
December 30, 2009 at 9:59 am
Viewing 15 posts - 11,896 through 11,910 (of 13,401 total)