Viewing 15 posts - 12,331 through 12,345 (of 13,838 total)
To perform updates use an OLEDB Command within your dataflow.
January 10, 2010 at 2:59 am
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
Viewing 15 posts - 12,331 through 12,345 (of 13,838 total)